Advanced Microsoft Excel 2007
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
Learn how to use advanced 'If' statements and macros to automate repetitive tasks Be able to use analysis tools to forecast figures based on a range of scenarios Ensure important data is highlighted by summarising large workbooks and sorting data into key elements. Suitable for: This course is suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel 2007 and would like to explore the more complex functionality it can offer. Prerequisites A working knowledge of Microsoft intermediate topics or attendance to our Intermediate Microsoft Excel course.
Facilities
Location
Start date
Start date
Reviews
Course programme
Who is it for
This course is suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel 2007 and would like to explore the more complex functionality it can offer.
Prerequisites
A working knowledge of Microsoft intermediate topics or attendance to our Intermediate Microsoft Excel course.
What is it about
- Learn how to use advanced 'If' statements and macros to automate repetitive tasks
- Be able to use analysis tools to forecast figures based on a range of scenarios
- Ensure important data is highlighted by summarising large workbooks and sorting data into key elements
Course overview
- Group And Outline Features
- Linking worksheets
- Goal Seek to reverse calculate a formula
- Creating Single Input Data Tables
- Setting up and manipulating scenarios for What-If? Analysis
- Named Ranges
- Consolidating Data by position
- Text Functions in Excel 2007
- Group And Outline Features
- Nested IfÂ' statements
- Use of Lookup functions
- Use of Logical functions
- Create a Pivot Table Report
- Analysing Data with Pivot Tables
- Manipulate the Pivot Table
- Formatting Pivot Tables
- Creating Pivot Charts
- Grouping data in Pivot Tables
- Setting Up Database Queries
- Connecting Excel to the Web to Import Data
- Recording Macros
- Edit a Macro
- Creating Buttons to Run the Macros
- Creating your own Menu
Advanced Microsoft Excel 2007