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
Prerequisites:Must have attended the Microsoft Excel Introduction and Intermediate courses, or have an extensive working knowledge of the product
Duration:One Day
Fees:Course fees for this particular course will depend on your chosen Training solution. Please click on the links below for corresponding course fees:
PDF Course Download
You can download a PDF version of the course.
Download Microsoft Excel Advanced course outline.
If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.
If you are interested in our Excel Advanced course call us on
0113 243 2226
Enquire about
this course Now
Course Dates
| Available dates |
|---|
| 8th June 2012 |
| 4th July 2012 |
| 6th August 2012 |
| 5th September 2012 |
Course Outline:
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 Functions?
- 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 the 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
- Displaying a View
Introduction to Macros
- What is a Macro?
- Recording a Macro
- Assigning a Macro to a toolbar or menu
- Viewing the Macro Editor
