onsite-training.com has been a trusted training partner to the Government of Canada since 2004. With consultants in Toronto and Ottawa, we’re uniquely positioned to deliver Microsoft Excel training to government clients throughout Ontario.
The Government of Canada has engaged onsite-training.com on an ongoing basis because our Microsoft Excel courses focus on developing the skills that their employees need most. We offer a complete learning and development solution – from identifying training goals to course selection and delivery.
Our instructors are subject matter experts. All of our Microsoft Excel courses come with practice files, student manuals, and 30 days of post-training support.
For the safety of our clients and team members, we are currently only offering online training with a live instructor using Microsoft Teams or Zoom.
Microsoft Excel Courses
We offer 3 levels of Microsoft Excel training. All courses are built around a carefully selected list of objectives and are an effective way to prepare for Microsoft Excel certification.
In the sections below, there is a summary of each course, along with recommendations as to the course’s intended audience and links to detailed overviews.
Excel Level 1
The Excel Level 1 course is intended for new users and users seeking a refresher of basic Excel skills.
This course is designed to help participants create new Excel files and customize spreadsheets by working with rows and columns and editing cells. This course also explores basic formulas, functions, formatting, and printing in Excel.
Excel Level 2
The Excel Level 2 course is designed to help users with basic skills utilize more of Excel’s capabilities.
This intermediate course helps users become more efficient by exploring named ranges, templates, worksheet security, and outlines. Additionally, the course includes full coverage of the IF function, linking worksheets, charts, and advanced formatting.
Excel Level 3 Data Management
The Excel Level 3 Data Management course is ideal for users who work with large data sets.
This advanced course covers VLOOKUP / HLOOKUP, sorting, filtering, and creating various reports using automatic subtotals, PivotTables, PivotCharts, and database functions. Additionally, this training session examines importing and exporting data from a variety of sources.
Excel Level 3 Spreadsheet Analysis
The Excel Level 3 Spreadsheet Analysis course is aimed at users who perform financial analysis and modelling.
This advanced course includes detailed coverage of financial functions, absolute and mixed cell references, Goal Seek, data tables, Scenarios, Solver, and worksheet auditing tools.
Discounted Pricing for Government Employees
We are happy to provide discounted pricing to all Government of Canada employees.
Government of Canada Client List
Here is a partial list of government agencies we have worked with.
- Agriculture and Agri-Food Canada
- Canada Post / Innovapost
- Canada Revenue Agency
- Canadian Coast Guard
- Canadian Food Inspection Agency
- Correctional Service Canada
- Environment and Climate Change Canada
- Fisheries and Oceans Canada
- Global Affairs Canada
- Health Canada
- Immigration and Refugee Board of Canada
- Immigration, Refugees and Citizenship Canada
- Royal Canadian Mounted Police
- Treasury Board of Canada Secretariat