Du kan finde alle informationer om dette kursus
her:
http://www.4d.dk/Kurser/Office/Excel/2007-2010/1086KursusmålOn the course you will learn to create more advanced and automated Excel spreadsheets and therefore be able to use even more of Excel's many functions.
DeltagereThe course is directed to you who need to use the spreadsheet program Excel in your daily work, either as an advanced user or as a "super-user". You are expected to have knowledge of the program corresponding to our basic course and have used Excel for some time.
KursusmaterialeOn the course you will achieve the highest level of advantage by alternating between theory, elaborated questions and practical exercises. To support these exercises you will be supplied with thoroughly-prepared course material developed by 4D Konsulenterne A/S especially for this course.
In order to maintain and develop your Excel proficiency, we recommend that you use the course material as a efficient reference material after the course. If this is not sufficient, you are always welcome to contact our instructors with further questions etc.
Kursus indholdFunctions - Easy and automatic ways to make advanced calculations
- Examination of the different categories:
- Mathematical functions
- Statistic functions
- Text functions
- Data functions
- Financial functions
- Logical functions
- Informative functions
- References functions
Data analysis and calculation tools - Removing duplicates from lists
- Dynamic grouping of rows and columns
- Totals - subtotals
- Combination functions with criteria (SUM, IF, COUNTIF)
- Pivot tables - analysis, grouping and calculation tool
- Pivot diagrams
- Homing
- Scenarios
Keyboard shortcuts - Reference manual to Excel's keyboard shortcuts
Advanced formatting - Creating your own user defined formats
- Conditioned formatting
- Management of the format when collating dynamic texts
Sheets and projects folders - Creation and management of multiple sheets
- Using formulas on multiple sheets
- Arranging multiple project folders in the same window arranger
- Creating chains between project folders
- Saving multiple project folders in one work area
- Collection of data through consolidation
- Creating and using templates
- Splitting the project folder, allowing multiple users to work simultaneously
- Protection of sheets, project folders and files
Validation and special tools - Data validation - track data entry on the spreadsheet
- Compounding dynamic texts
- Special entering of copied contents
- Select and go to special areas in the spreadsheet
Revision of formulas - Visual overview of the connection between the formulas on the spreadsheet
- Methods of error control
- Comments
- Mark invalid data in connection with validation of data
- Evaluate formulas - a tool for an easier way to find calculation levels in a formula
- Value control chart - an overview of all the cells in the spreadsheet
Spar helt op til 40% med et:4D Klippekort:
http://www.4d.dk/Priser/Klippekort/Pages/klippekort.aspx
Vi har mange Excel kompetencer - se alle vores::Excel ydelser:
http://www.4d.dk/Produkter/Office/Excel
Er I flere - skræddersy kurset med eksempler fra jeres hverdag:Læs mere om firmakurser:
http://www.4d.dk/kursus/kursustyper/Pages/kursus_typer.aspx
