Microsoft Excel Advanced

Microsoft Excel Advanced Logo

Microsoft Excel Advanced

Aims: Enables users to customise Excel spreadsheets to produce valid and clear reporting of data integrated with macros for faster ways of working

Pre-requisites: Must have attended the Microsoft Excel Introduction & Intermediate courses, or have an extensive working knowledge of the product

Duration: One day


Text and Conditional Functions
Common Text Functions
Countif and Countifs
Sumif and Sumifs
Averageif and Averageifs
Combining and Nesting functions

Lookup Functions
What is a Lookup Function?
Using LOOKUP to extract information
Looking up with VLOOKUP and HLOOKUP

Pivot Tables
What is a Pivot Table?
Using Pivot Tables to display Data Lists
Creating a Pivot Table
Modifying the structure of a Pivot Table

Further Pivot Tables
Formatting a Pivot Table
Producing Drilldown Reports
Grouping and Ungrouping Pivot Table data
Showing and Hiding data in a Pivot Table

Goal Seek
What is Goal Seek?
Using Goal Seek to solve problems

Solver vs. Goal Seek
Using Solver to solve problems
Specifying Solver constraints and limits

Displaying a View Scenario Manager
What is Scenario Manager?
Creating a Scenario
Showing a Scenario
Generating Scenario Reports

An introduction to Custom Views
Using a View to control the display
Using a View to control print settings

Introduction to Macros
What is a Macro?
Recording a Macro
Assigning a Macro to the Quick Access Toolbar
Viewing Macro Editor

For further information on our Microsoft Excel Advanced Course, please contact us via the contact page, or alternatively telephone the office on 0113 243 2226