|
 This course is designed for people who have a good working knowledge of Excel, and who want to wish to use the advanced features of Excel 2003. By the completion of this course, participants will have a broad knowledge of Excel
Duration:
2 Days
Audience:
The course has been designed for experienced users of Excel who wish to used the advanced features of Excel 2003.
Prerequisites:
Participants must be confident users of Excel who are able to create and manage multiple sheet workbooks.
Course Content:
Auditing Tools
• Overview of Auditing Tools
• Tracer Arrows, Dependent and Precedent Arrows
• Removing Tracer Arrows
• Tracing Cells Causing Errors
• Understanding Error Messages
• 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
• Round Function
• Array formulas
Database/Lists
• Creating a Database List
• Adding/Removing Records
• Adding / Removing Fields
• Sorting Records by Multiple Fields
• Performing a Custom Sorts
• Sorting from Left to Right
• Using a Data Form to find and edit data
• Creating Subtotals in a List
• Removing Subtotals from a List
Advanced Filters
• Creating a Criteria
• Using a Criteria
• Showing All Records
• Using Comparison Criteria
• Using an Advanced AND or OR Conditions
• Extracting Filtered Records
• Using Database Functions
Scenario & GoalSeek
• Using the Scenario Manager
• Creating, Displaying and Editing a Scenario
• Creating a Scenario Summary Report
• Using Goal Seek
Problem Solving
• Using Solver to find solutions to spreadsheet problems
• Savings a Solver Solution as a Scenario
• Restoring the Original Values
• Changing a Constraint
• Creating a Solver Report
• Using Scenarios to View Solutions
Consolidating Worksheets
• Overview of Consolidating data
• Consolidating by Position or by Category
Working with Views
• Using Views
• Creating a Custom View
• Displaying a View
• Editing a View
• Deleting a View
Report Manager
• Working with the Report Manager
• Using Sheets in a Report
• Printing a Report
• Using Scenarios and Views in a Report
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
• Pivot Table Options
• Adding Multiple Data Fields
• Custom Calculations In Pivot Tables
• Creating Calculated Fields and Calculated Item
• Grouping/Ungrouping Items
• Sorting A Pivot Table
• Creating Pivot Charts
• Creating Interactive PivotTables • Web
• Adding Fields To A PivotTable • Browser
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
|
Software Courses 
(07) 3210 0002
info@CTStraining.com.au
