Course Outline
Pre-Requisites
Good Working Knowledge of Excel.
Lessons
This course is designed for users of Excel who need to analyze spreadsheet data. Concepts covered include using goal seek, creating and managing what-if scenarios, and analyzing spreadsheets using auditing concepts such as tracing, evaluating formulas and watch window. An introduction to Macros will be covered.
Course Content
Overview
Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Command Shortcut Keys
Auditing Workbooks
Auditing Concepts
Tracing a Worksheet
Evaluating Formulas
Show Formulas
Watch Window
Advanced Formulas
Using Absolute, Relative and Mixed Formulas
Nested If Statements
If Statements using And/Or
And Nested Ifs
Scenarios
Creating a Scenarios
Creating a Scenario Report
Projecting Figures
Goal Seek
Solver
Macros
Recording a Macro
Playing and Deleting a Macro
Adding a Macro to the Quick Access Toolbar or Ribbon
Cancellation Policy
10 business days cancellation or full course fee will be charged
Training Location
Online Classroom
.
.,
.
.
I had a very bad experience with the instructor - he centered me out throughout the entire class - asked me continuously if I on pace or knew how to do the work. If I asked him a question he seemed anger made me feel little, stupid, he was very condescending. At one point he helped me and he said things like "this is a desktop" "do you know that?" others laughed. I almost left the course halfway through. I'm a much older person and First Nations and I'm shocked he treated me the way he did. It's like I was less of a person, discriminating, and etc.