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
What is a Lookup Function?
Using LOOKUP to extract information
Looking up with VLOOKUP and HLOOKUP
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
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