About This Training Course

This Brisbane Excel 2010 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 2010. By the completion of This Excel Training Course, participants will have a broad knowledge of Excel.

Subjects Covered

This Excel 2010 Advanced Training Course will cover the following subjects:

Auditing Tools
• Overview of Auditing Tools
• Tracer, 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 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 Pivottable 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
• Filtering using Slicers
• Using PivotTable Styles, Themes and Colours
• PivotTable Layout Tools
• Creating PivotCharts

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 Controls
• Selecting Controls
• Moving A Control
• Adding Data To Controls
• Setting Up For On-Line Use

Training Course Outcomes

This Excel 2010 Advanced Training Course has been designed for experienced users of Excel who wish to used the advanced features of Excel 2010.

Prerequisites

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

Other Information

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