Kursusmål
On 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.

Deltagere
The 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.

Kursusmateriale
On 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.

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

Functions

• 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

Advanced formatting

• Creating your own user defined formats
• Conditioned formatting
• Management of the format when collating dynamic texts

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