Intermediate Excel

Duration: ONE DAY

Pre-requisites:

Delegates should have attended the Day 1 and Day 2 Introduction to Excel courses, or have similar knowledge 

Course Objectives:

After attending the course, delegates should have enhanced their use of the intermediate features of reporting, customising and analysis tools in Excel

Course Content:

More advanced features  

Exploring Excel’s Functions:

Function structure and syntax

Insert Function Dialog Box

Natural language formulas

Financial functions

Date and time functions

Lookup and reference functions

Text, logical and information functions

Linking Workbooks 

Data validation: 

Input messages

Creating a valid input range of values

Creating an input range to validate a formula

Restricting data entry 

Data Validation and Lookup Functions

Data tables:

Using data tables to perform sensitivity analysis

Editing data tables 

Databases: 

Understanding databases

Sorting data

Entering data into a list

Using AutoFilter for easy interrogation

Advanced filters

Criteria formulas

Using database statistical functions 

Custom views: 

Using the Custom View to view your data with different display and print options

Creating, displaying and deleting views 

Scenarios: 

Creating scenarios using the scenarios list

Switching between scenarios

Creating scenarios using the Scenario Manager

Applying scenarios from other workbooks

Protecting scenarios

Producing summary reports 

Reports: 

Creating a report

Printing a report