Alandale Training Courses: MS Excel

Microsoft Excel Level 2

Windows

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

 

Participants will learn how to:

  • Add, rename, copy, move and delete worksheets
  • Set the Print Area and choose print options
  • Add headers and footers to a workbook
  • Work with multiple workbooks
  • Create a Named Range and use it in a formula
  • Use the If and Vlookup formulas
  • Analyze data using Sort, Filter and Tables

 

Course Modules

 

  • Managing Workbooks – 1.5 hours
  • Using Workbook Views
  • Selecting and Switching Between Worksheets
  • Inserting and Deleting Worksheets
  • Renaming, Moving, and Copying Worksheets
  • Splitting and Freezing a Window
  • Creating Headers and Footers
  • Hiding Rows, Columns, Worksheets, and Windows
  • Setting the Print Area
  • Adjusting Page Margins and Orientation
  • Adding Print Titles, Gridlines, and Row and Column Headings
  • Adjusting Paper Size and Print Scale
  • Printing a Selection, Multiple Worksheets, and Workbooks
  • Working with Multiple Workbook Windows
  • Creating a Template
  • Protecting a Workbook
  • Protecting Worksheets and Worksheet Elements
  • Sharing a Workbook
  •  

  • More Functions and Formulas – 2.5 hours
  • Defining Names
  • Using and Managing Defined Names
  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • AutoCalculate and Manual Calculation
  • Displaying and Tracing Formulas
  • Understanding Formula Errors
  • Using Logical Functions (IF)
  • Using Lookup Functions (VLOOKUP)
  • Financial Functions
  • Date & Time Functions
  • Statistical Functions
  • Lookup & Reference Functions
  • Database Functions
  • Text Functions
  • Logical Functions
  • Information Functions
  •  

  • Working with Data Ranges – 1 hour
  • Sorting by One Column
  • Sorting by Colors or Icons
  • Sorting by Multiple Columns
  • Sorting by a Custom List
  • Filtering Data
  • Creating a Custom AutoFilter
  • Using an Advanced Filter
  •  

  • Working with Tables – 1 hour
  • Creating a Table
  • Adding and Removing Data
  • Working with the Total Row
  • Sorting a Table
  • Filtering a Table
  • Removing Duplicate Rows of Data
  • Formatting the Table
  • Using Data Validation
  • Summarizing a Table with a PivotTable
  • Converting to a Range

 

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: $245/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