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.

This course is also relevant for you, if you are working with Excel as a part of Office 365.

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.

Kursus indhold

Worksheets and Workbooks
In this module you will learn how to use several worksheets and workbooks. You will learn how to manage multiple worksheets efficiently and create formulas across worksheets. You will learn how to create links between workbooks and how to share and protect a worksheet.

- Managing Multiple Sheets
- Formulas on Multiple Sheets
- Arranging Multiple Workbooks
- Creating Links Between Workbooks
- Saving Multiple Workbooks in a Workspace
- Merge Data Using Consolidation
- Creating and Using Templates
- Sharing the Workbook, Permitting Multiple Users to Work Simultaneously
- Protection of Cells, Sheets and Workbooks

Validation and Special Tools
In this module you will learn how to control data entry in your worksheet and you will learn how to paste different properties from a copied cell or range.

- Data Validation - Check Data Entry on The Spreadsheet
- Concatenate Cells With Text
- Paste Special Options
- Select Specific Areas in the Spreadsheet

Revision of Formulas
In this module you will learn a number of tools to review formulas in a complex worksheet. It can be a visual overview with lines and colors. In addition, tools for error control are explained.

- 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

Using Functions
Functions are an easy way to manage advanced calculations in Excel and can be used for a number of problems. In this module you will learn what functions are and how to use them. There will be a number of examples of functions from the list below.

- Exploring the Function Library
- Mathematical Functions
- Statistic Functions
- Text Functions
- Date Functions
- Financial Functions
- Logical Functions
- Information Functions
- Lookup Functions

Advanced Formatting
In this module you will learn how to make custom formats and how to make formatting's based on a cell content or a formula.

- Creating Custom Formats
- Conditional Formatting
- Combining Text and Numbers in One Cell

Data Analysis and Calculation Tools
In this module you will be acquainted with some useful tools to work with large worksheets and huge amounts of data.

- Removing Duplicates in a List
- Grouping of Rows and Columns
- Totals and Subtotals, Ignoring Hidden Data
- Combination Functions with Criteria (ie. SUMIF, COUNTIF)
- PivotTables - Analysis, Grouping and Calculation Tool
- PivotCharts
- Goal Seek

Help and Keyboard Shortcuts
In this module you will get an overview of keyboard shortcuts and key tips.

- Using Excel Help
- Excel Standard Keyboard Shortcuts
- Accessing All Commands from the Keyboard using Key Tips

Du kan finde alle informationer om dette kursus ved at gå ind på http://www.4d.dk/Kurser/Office/Excel/2007-2010/1086