[Click here for more info...]

About This Training Course

This 2-day Microsoft Excel 2007 - Advanced Training Course is designed for people who have a good working knowledge of Excel, and who wish to use the advanced features of Excel 2007. By the completion of this Microsoft Excel 2007 - Advanced Training Course, participants will have a broad knowledge of Excel.

Multiple-day course sessions are conducted 8-days apart to enable participants’ greater opportunity to absorb and practice learned topics, and cement transfer of skills to their everyday job roles. Our experience is that this course structure assists with the most effective learning and skills retention.

Subjects Covered

This Microsoft Excel 2007 - Advanced Training Course will cover the following subjects:

Auditing Tools
• Overview of Auditing Tools
• Tracer Arrows, Dependent and Precedent Arrows
• Removing Tracer Arrows
• Tracing Cells Causing Errors
• Understanding Error Messages - #DIV/0; #NA; #Name; #Ref!, #Value
• Overcoming Error Messages
• Advanced Functions

• Nested IF Functions
• AND, OR functions
• Using an AND Condition with IF
• Lookup Functions - VLOOKUP, HLOOKUP, Match and Index
• String Functions
• Rounding Functions
• Array formulas
• What If Analysis

• Using Scenario Manager
• Creating a Scenario
• Displaying and Editing a Scenario
• Creating a Scenario Summary Report
• Using Goal Seek
• Data Tables
• One Variable and Two Variable Data Tables
• Using Solver
• Saving Solutions as Scenarios
• Creating a Solver Report
• Worksheet Consolidations

• Consolidating by Position
• Consolidating by Category
• Custom Views

• Creating a Custom View
• Display a View
• Editing a View
• Tables

• Setting up an Excel Table
• Adding Rows
• Using Dynamic Headings
• Table Tools and Formats
• Using the Table Style Gallery
• Deleting Table Records
• Find Duplicates
• Sorting and Filtering


• Sorting and Filtering records
• Creating complex filters
• Sorting on Multiple Columns
• Sorting and Filtering by Colour
• Performing Custom Sorts
• Sorting Left to Right
• Data Validation


• Data validation for a range of values
• Using Validation Circles
• Using Data Validation Lists
• Creating Subtotals
• Advanced Filters

• Using a Criteria Range
• Clearing the Filter
• Using Comparison Criteria
• Using AND and OR conditions
• Extracting Filtered records
• Using Database functions - Dsum, Daverage, Dget
• Creating Pivot Table Reports

• Creating a PivotTable
• Adding PivotTable Report Fields
• Editing and Refreshing a PivotTable Report
• Changing The Summary Function
• Moving Pivot table Report Fields
• Hiding And Unhiding Items
• Adding Multiple Data Fields
• Custom Calculations In Pivot Tables
• Creating Calculated Fields and Calculated Item
• Grouping/Ungrouping Items
• Sorting A Pivot Table
• Using PivotTable Styles, Themes and Colours
• PivotTable Layout Tools
• Creating Pivot Charts
• Macros

• Defining Macros
• Recording and running a Macro
• Personal Workbook
• Visual Basic Editor Understanding Your Code
• Running Code In VBA Environment
• Recording a Relative Record
• Debugging a Macro
• Correcting Errors
• Assigning A Macro To A Menu
• Deleting A Macro From A Menu
• Assigning A Macro To a Button
• Creating an Online Form

• Creating a Form
• Adding, Selecting & Moving a Controls
• Adding Data to Controls
• Setting Up For On-Line Use

Training Course Outcomes

At the end of this Microsoft Excel 2007 - Advanced Training Course, participants will have a broad knowledge of Excel.

Prerequisites

Participants must be competent users of Excel who are able to create and manage multiple sheet workbooks.

Other Information

Multiple-day course sessions are conducted 8-days apart to enable participants’ greater opportunity to absorb and practice learned topics, and cement transfer of skills to their everyday job roles.

Our experience is that this Microsoft Excel 2007 - Advanced Training Course structure assists with the most effective learning and skills retention.

If you need more information contact Startnextweek.com.au on 1300 728 102