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
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
Views
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
