Alandale Training Courses: MS Excel

Microsoft Excel Level 3

Windows

This advanced level course covers Pivot Tables and data analysis features such as Scenario ManagerConsolidate.  We also cover Macros and Customizing Excel. 

 

Participants will learn how to:

  • Analyze data using PivotTables, Slicers and PivotCharts.
  • Create and manage scenarios, as well as create scenario reports.
  • Use the Goal Seek feature.
  • Define and solve problems with Solver.
  • Consolidate data by position or category.
  • Create and work with subtotalled lists.
  • Import external data into Excel from a variety of sources.
  • Record and run a macro and edit the Visual Basic code.

 

  Course Modules

  • Working with PivotTables – 1.5 hours
  • Creating a PivotTable
  • Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Filtering and Sorting a PivotTable
  • Working with PivotTable Layout
  • Grouping PivotTable Items
  • Updating a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart
  • Using Slicers
  • Sharing Slicers between PivotTables

 

  • Analyzing Data – 2.5 hours
  • Creating Scenarios
  • Creating a Scenario Report
  • Working with Data Tables
  • Using Goal Seek
  • Using Solver
  • Using Text to Columns
  • Grouping and Outlining Data
  • Using Subtotals
  • Consolidating Data by Position or Category
  • Consolidating Data Using Formulas
  • Working with the Web and External Data – 0.5 hours
  • Inserting a Hyperlink
  • Importing Data from an Access Database or Text File
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections
  • Working with Macros – 1.0 hours
  • Recording a Macro
  • Playing and Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar
  • Editing a Macro’s Visual Basic Code
  • Inserting Copied Code in a Macro
  • Declaring Variables and Adding Remarks to VBA Code
  • Prompting for User Input
  • Using the If…Then…Else Statement
  • Customizing Excel – 0.5 hours
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options
  • Creating a Custom AutoFill List
  • Creating a Custom Number Format

 

Assessment Methods: Lab exercise completed after each module to reinforce the topics covered in the module.  Q&A throughout the course.  Course evaluation completed after the course. 

Delivery Method: Classroom

Course Duration: Full day

Training Hours: 6 hours

Total Cost of Program: $285/per person plus GST

Course Capacity: Maximum 16 participants

 

 

Instructor Bio: John Chandler


John ChandlerJohn Chandler specializes in delivering Microsoft Office computer training courses in Vancouver and throughout B.C.

 

He is a seasoned software instructor with broad-based business skills developed during more than five years as a management consultant. He has over 26 years’ experience teaching adults how to use computers. He is comfortable working with people at all levels in an organization, including senior management, and has demonstrated skills working with users at all levels of computer literacy.

 

John is a results-oriented team player with excellent interpersonal and presentation skills, and proven abilities teaching all levels of computer software from introductory to advanced.

 

He holds the Certified Management Consultant designation and is a current member of the Canadian Association of Management Consultants. The CMC designation is granted to individuals who have demonstrated their knowledge of management, and their capacity to consult, according to international standards of practice and ethics. It is earned through a combination of university education, experience, peer review, study & examination.

 

John is a member of the Vancouver Executives Association and is the President of the association this year.

 

 

Excel Level 1

This introductory level course will provide participants with a solid foundation in the basics of using Microsoft Excel.

 

Excel Level 1

 

Excel Level 2

This intermediate level course covers useful Excel features such as Named Ranges, Functions and Sort & Filter.

 

Excel Level 2

 

Excel Level 3

This advanced level course covers Pivot Tables and data analysis features such as Scenario Manager...

 

Excel Level 3

 

 

All Microsoft and Adobe courses can be customized to your particular version.


What our learners say

His teaching style is engaging.

"John Chandler is very knowledgeable in Excel. His teaching style is engaging and he makes it very easy to follow and understand. I’d recommend his training to anyone looking to brush up on their Excel knowledge."

Keshni de Vaz

Assistant Brand Manager
LifeScan Canada

Want to be an HR Hero? Contact Us