Advanced Excel
For Delegates with a solid foundational knowledge of Excel who wish to explore the advanced features of Excel
Aims & Objectives To introduce delegates to the powerful data summary features of Excel, What If? facilities, advanced, conditional and financial functions, automating a spreadsheet and web interactivity.
Pre-requisites Delegates should have a good all-round knowledge of Excel and have preferably attended both the introductory and intermediate Excel courses.

Content

 Financial Functions: PMT, FV
Lookup Functions:
- MATCH
- INDEX
- Data Tables
Conditional and Summary Functions
- IF
- COUNTIF
- SUMIF
- SUMPRODUCT
- Automatic Subtotals
Pivot Tables and Pivot Charts
Macros, inc 
- Assigning Macros to a Toolbar Button
- Editing VBA code
- Creating a Function Procedure
Goal Seek
Scenarios and Scenario Manager
Web Interactivity, inc
- Lookup tables on the World Wide Web
MsQuery
- Querying External Databases
- The Web Query
Workbook Hiding & Protection Facilities

Duration

 1 day                     back