Alandale Training Courses: MS Excel

Microsoft Excel Level 1

Windows

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

 

Participants will learn how to:

  • Create a spreadsheet by entering text, numbers, dates and formulas
  • Use the mouse and keyboard shortcuts to move around in a workbook and efficiently select cells
  • Calculate values using formulas and use the AutoSum function to add the numbers in a group of cells.
  • Use Relatives and Absolute References in formulas.
  • Copy cell contents to adjacent cells using AutoFill.
  • Insert and delete columns, rows and cells.
  • Apply formatting to make the workbook more readable.
  • Use Charts to present numbers

 

Course Modules

  • Program Fundamentals – 1 hour
  • What’s New in Excel 2013
  • Understanding the Excel Program Screen
  • Giving Commands
  • Using Command shortcuts
  • Creating a New Workbook
  • Opening a Workbook
  • Previewing and Printing a Worksheet
  • Saving a Workbook
  • Closing a Workbook
  • Exiting Excel

 

  • Getting Started with Worksheets – 1.5 hours
  • Navigating a Worksheet
  • Entering Labels and Values
  • Selecting a Cell Range and Entering Date in a Cell Range
  • Overview of Formulas and Cell References
  • Entering Formulas
  • Entering Content Automatically
  • Referencing External Data

 

  • Editing a Worksheet – 1.5 hours
  • Editing Cell Contents
  • Copying and Moving Cells
  • Controlling How Cells Are Moved or Copied
  • Collecting Items to Move or Copy
  • Checking Spelling
  • Inserting Cells, Rows, and Columns
  • Deleting Cells, Rows, and Columns
  • Using Undo and Redo
  • Adding Comments to Cells

 

  • Formatting a Worksheet – 1 hour
  • Formatting Text
  • Formatting Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Cell Borders and Background Colours
  • Copying Formatting
  • Applying and Removing Cell Styles
  • Applying Conditional Formatting
  • Creating and Managing Conditional Formatting Rules

 

  • Creating and Working with Charts – 1 hour
  • Choosing and Selecting the Source Data
  • Choosing the Right Chart
  • Inserting a Chart
  • Editing, Adding, and Removing Chart Data
  • Changing Chart Data
  • Changing Chart Layout and Style
  • Working with Chart Labels
  • Changing the Chart Gridlines
  • Changing the Scale
  • Emphasizing Data
  • Using Chart Templates
  • Using Sparklines

 

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

I'm looking forward to the next level of training.

"John recently presented an Excel level 1 course at our plant. The course was well presented. John was very knowledgeable about the program and was always willing to stop and clarify any points that we were having difficulty with. I was amazed by how fast the day went and I'm looking forward to the next level of training."

Gord McIlrath

Electrical Planner
Howe Sound Pulp and Paper

Want to be an HR Hero? Contact Us