Microsoft Excel Training Courses
Live In-Person
Instructors
Guaranteed
To Run
Customizable
Objectives
Joining us from Ottawa? Learn more about how we help Ottawa learn Excel.
Compuease is now part of The Great Canadian Training family. Same great team - Same great service.
Book Excel Training Today: Choose from One of Our Top Courses!
At the Great Canadian Training & Consulting Company, we want you to get the most out of Excel. We offer three standard levels of Excel training, along with specialized courses that dig deeper into what this powerful tool has to offer.
Whether you are an Excel beginner or want to build proficiency in its specialized features (such as Excel VBA, analytics, macros and more).
You can click on each course outline for more information on the specific topics covered or get in touch with one of our training coordinators to help you determine which course is right for you.
Having trouble choosing an Excel course? If you want:
- An overview of Excel: Start with Excel Level 1 (Basic), 2 (Intermediate) or 3 (Advanced)
- To be more productive: Check out Excel Tips and Tricks
- To display your data more effectively: We cover charts, dashboards and visualizations
- To power up how you use Microsoft Excel and its functions: Check out our power functions and features courses
Unless otherwise noted, public training is scheduled for 9:00 a.m. to 4:00 p.m. Eastern Time (ET)
Essential Excel Training
Designed For
New Excel users who want to become more comfortable using Excel's most commonly used features.
Results
- Create, open, save, and navigate workbooks
- Explore Excel's user interface, including the Ribbon, Backstage View, and Quick Access Toolbar
- Work with data by entering, editing, deleting, and using features like Autofill and Find/Replace
- Perform basic calculations with formulas, functions, and cell references
- Format workbooks, manage large workbooks, and set print options effectively
Length
6 hrs
Venue
Virtual
Cost
$ 295.00
Upcoming Public Classes
| May 6, 2025 9:00 AM to 4:00 PM ET |
| June 5, 2025 9:00 AM to 4:00 PM ET |
| July 3-4, 2025 1:00 PM to 4:00 PM ET |
Designed For
Users who are familiar with the Home Ribbon and want to learn more advanced features.
Results
- Work with range names, including applying, editing, and using them in formulas
- Use specialized functions, nested functions, and automatic workbook calculations
- Analyze data with logical and lookup functions like IF, AND, VLOOKUP, and XLOOKUP
- Perform financial and date calculations
- Organize data with tables, sort/filter data, and visualize data using charts and sparklines
Length
6 hrs
Venue
Virtual
Cost
$ 295.00
Upcoming Public Classes
| May 13, 2025 9:00 AM to 4:00 PM ET |
| May 21, 2025 9:00 AM to 4:00 PM ET |
| June 11, 2025 9:00 AM to 4:00 PM ET |
Designed For
Advanced users who want to use advanced data analysis and time-saving features in Excel.
Results
- Add comments, hyperlinks, watermarks, and background pictures to workbooks
- Prepare for multiple audiences by adding alt text and using accessibility tools
- Consolidate data, link cells across workbooks, and merge data while managing duplicates
- Protect workbooks, group and outline data, and use subtotals
- Analyze data with Pivot Tables/Charts and slicers, and automate tasks with macros
Length
6 hrs
Venue
Virtual
Cost
$ 350.00
Upcoming Public Classes
| July 15, 2025 9:00 AM to 4:00 PM ET |
| August 28, 2025 9:00 AM to 4:00 PM ET |
| October 27, 2025 9:00 AM to 4:00 PM ET |
Designed For
Those who want a comprehensive overview of Excel, including essential features, formulas, data visualization, and data management.
Results
- Explore a wide range of Excel topics, from essentials to formulas, functions, and more
- Customize the Quick Access Toolbar, navigate cells, and use the Fill Handle
- Create and apply formulas and master functions like SUM, AVERAGE, and XLOOKUP
- Build and format charts, modify data sources, and use chart elements effectively
- Organize data with tables, analyze with Pivot Tables, and apply data validation rules
Length
6 hrs
Venue
Virtual
Cost
$ 425.00
Upcoming Public Classes
| June 16, 2025 9:00 AM to 4:00 PM ET |
| October 28, 2025 9:00 AM to 4:00 PM ET |
| January 27, 2026 9:00 AM to 4:00 PM ET |
Be More Productive With Excel
Designed For
All Excel users who are focused on working efficiently and increasing their productivity using Excel.
Results
- Update values with Paste Special, Flash Fill, and the Fill Handle for quick adjustments
- Hide cells, highlight formulas, and transpose data for faster organization
- Insert screenshots and colour-code sheet tabs to stay organized
- Use AutoCalculate and create custom column headings for precision
- Apply conditional formatting, SUMIF/CountIF, and create charts to visualize data efficiently
Length
12 hrs
Venue
Virtual
Cost
$ 795.00
Upcoming Public Classes
| July 16-17, 2025 9:00 AM to 4:00 PM ET |
| November 27-28, 2025 9:00 AM to 4:00 PM ET |
Designed For
All Excel users who would like to learn essential tips and tricks to save time when using Excel.
Results
- Use Paste Special to update values and convert formulas to values
- Highlight all formulas and functions quickly for better visibility
- Maximize efficiency with Excel's Fill Handle and learn ten ways to utilize Flash Fill
- Organize workbooks by colour-coding sheet tabs and efficiently creating column headings
- Explore handy features like great keyboard shortcuts
Length
6 hrs
Venue
Virtual
Cost
$ 475.00
Upcoming Public Classes
| July 16, 2025 9:00 AM to 4:00 PM ET |
| November 27, 2025 9:00 AM to 4:00 PM ET |
Designed For
Experienced users who use Excel regularly and want advanced tips on working more efficiently.
Results
- Develop multi-tiered data validation lists and work with checkboxes and drop-downs
- Compare lists using conditional formatting and apply wildcards in IF statements
- Expand your skills with COUNTIF and SUMIF functions
- Create charts and Gantt charts, including incorporating images into your charts
- Utilize Pivot Table tricks, manage data in filtered lists, and create custom date formats
Length
6 hrs
Venue
Virtual
Cost
$ 475.00
Upcoming Public Classes
| July 17, 2025 9:00 AM to 4:00 PM ET |
| November 28, 2025 9:00 AM to 4:00 PM ET |
Data Visualizations
Designed For
Experienced Excel users who wish to learn how to quickly and easily create charts and graphs.
Results
- Explore and select the most effective chart types for your data needs
- Apply best practices to improve the design of Excel charts for clearer communication
- Use creative techniques to enhance the power of data visualizations
- Customize charts with elements, such as layouts, colours, and styles, for better impact
- Create and modify any chart, including heat maps and geospatial maps
Length
6 hrs
Venue
Virtual
Cost
$ 425.00
Upcoming Public Classes
| July 24, 2025 9:00 AM to 4:00 PM ET |
| October 23, 2025 9:00 AM to 4:00 PM ET |
| February 10, 2026 9:00 AM to 4:00 PM ET |
Designed For
Experienced Excel users who want to prepare and summarize data, then display it using dashboards.
Results
- Create range names and advanced formulas to streamline data handling
- Automate workbook tasks using data validation, forms, and controls
- Apply conditional logic with lookup functions for complex data insights
- Visualize data with basic and advanced charts, including trendlines and sparklines
- Build dashboards using Pivot Tables, Pivot Charts, and slicers for dynamic analysis
Length
6 hrs
Venue
Virtual
Upcoming Public Classes
Designed For
Advanced users who want to summarize and display data using Pivot Tables, charts, and dashboards.
Results
- Create an interactive dashboard from start to finish using effective design principles
- Automate workbook functions with advanced formulas and data validation
- Apply conditional logic and formatting to enhance data presentation
- Visualize data with charting techniques, including combination charts
- Analyze data using Pivot Tables, slicers, and Pivot Charts for dynamic insights
Length
12 hrs
Venue
Virtual
Cost
$ 995.00
Upcoming Public Classes
| July 10-11, 2025 9:00 AM to 4:00 PM ET |
| November 6-7, 2025 9:00 AM to 4:00 PM ET |
| February 18-19, 2026 9:00 AM to 4:00 PM ET |
Designed For
All Excel users who want to create eye-catching visualizations or build stunning dashboards.
Results
- Understand Excel’s graphics tools and create basic charts
- Combine skills to develop non-standard, visually effective charts and visualizations
- Create and modify various chart types using insertion methods and formatting
- Insert and modify graphic objects, including shapes, text boxes, and images
- Create custom visualizations like pictographs, progress bars, and gauge charts
Length
6 hrs
Venue
Virtual
Cost
$ 495.00
Upcoming Public Classes
| September 4, 2025 9:00 AM to 4:00 PM ET |
| November 12, 2025 9:00 AM to 4:00 PM ET |
Designed For
Experienced Excel users who want to use Pivot Tables to analyze and visualize data more effectively.
Results
- Create and modify Pivot Tables for data summarization and analysis
- Organize and format data for effective Pivot Table functionality
- Use VLOOKUP/XLOOKUP to merge information from various sources
- Apply conditional formatting to emphasize critical data insights
- Customize layouts, add calculated fields, create Pivot Charts, and utilize slicers for dynamic filtering
Length
3 hrs
Venue
Virtual
Cost
$ 425.00
Upcoming Public Classes
| July 29, 2025 1:00 PM to 4:00 PM ET |
| September 10, 2025 1:00 PM to 4:00 PM ET |
| November 5, 2025 9:00 AM to 12:00 PM ET |
Power Functions & Features
Designed For
Experienced Excel users who want to learn to use Power Pivot to make better use of their data.
Results
- Combine multiple data sources into a consolidated report for better analysis
- Import, refresh, and organize data, including creating calculated columns and managing relationships
- Create Pivot Tables and Pivot Charts to visualize your data effectively
- Use DAX functions to manipulate data and extract insights
- Protect reports and save them in various formats for distribution
Length
12 hrs
Venue
Virtual
Cost
$ 895.00
Upcoming Public Classes
| August 7-8, 2025 9:00 AM to 4:00 PM ET |
| December 2-3, 2025 9:00 AM to 4:00 PM ET |
Designed For
Advanced Excel users who work with financial data and want to explore more mathematical functions.
Results
- Identify the right functions to generate accurate results in your spreadsheets
- Apply strategies to create functions that are tailored to your needs
- Build custom functions using the fx tool for greater flexibility in data analysis
- Combine multiple worksheets for a fuller analysis across datasets
- Work with array formulas to enhance data manipulation and streamline complex calculations
Length
6 hrs
Venue
Virtual
Cost
$ 475.00
Upcoming Public Classes
| September 9, 2025 9:00 AM to 4:00 PM ET |
| December 9, 2025 9:00 AM to 4:00 PM ET |
Designed For
Experienced Excel users who want to learn about Power Query and its advanced selection features.
Results
- Connect to various data sources, including Excel files, databases, and the web
- Transform and cleanse data by editing queries, removing duplicates, and sorting
- Pivot and transpose data for effective analysis and reporting
- Group data and create custom calculated columns for advanced insights
- Send Power Query data to other destinations like Excel workbooks and data models
Length
6 hrs
Venue
Virtual
Cost
$ 495.00
Upcoming Public Classes
| June 19, 2025 9:00 AM to 4:00 PM ET |
| October 8, 2025 9:00 AM to 4:00 PM ET |
| January 30, 2026 9:00 AM to 4:00 PM ET |
Automation with Macros and VBA
Designed For
New users or those with limited Excel VBA experience who want to understand basic macro concepts.
Results
- Record and run macros to automate repetitive tasks in Excel spreadsheets
- Use the VB Editor and Code Window to create and edit VBA code effectively
- Work with objects and variables to enhance code efficiency and organization
- Create procedures and functions to simplify complex tasks in your macros
- Understand debugging techniques to identify and fix errors in your VBA projects
Length
12 hrs
Venue
Virtual
Upcoming Public Classes
Upskilling
Designed For
Anyone who uses Excel and wants to learn the latest Microsoft 365 updates and new features.
Results
- Streamline your Excel spreadsheets with the Check Performance feature for improved accuracy
- Elevate data analysis using new Data Types in Pivot Tables for insightful reports
- Unlock insights with Excel’s Data Analysis tools to simplify decision-making
- Boost productivity with the new Paste Values shortcut
- Enhance navigation with the improved Narrator support for accessibility
Length
1.5 hrs
Venue
Virtual
Cost
$ 195.00
Upcoming Public Classes
| June 17, 2025 1:00 PM to 2:30 PM ET |
| September 16, 2025 9:00 AM to 10:30 AM ET |
| November 19, 2025 1:00 PM to 2:30 PM ET |
Essential Excel Training in French
Designed For
Les nouveaux utilisateurs d'Excel qui souhaitent se familiariser avec les fonctions les plus courantes d'Excel.
Results
- Créer, ouvrir, enregistrer et naviguer dans les classeurs.
- Explorer l'interface utilisateur d'Excel, y compris le ruban, la vue arrière et la barre d'outils d'accès rapide.
- Travailler avec des données en les saisissant, en les modifiant, en les supprimant et en utilisant des fonctions telles que le remplissage automatique et la recherche/remplacement.
- Effectuer des calculs de base à l'aide de formules, de fonctions et de références de cellules.
- Formater les classeurs, gérer les classeurs volumineux et définir les options d'impression de manière efficace.
Length
6 hrs
Venue
Virtual
Cost
$ 450.00
Upcoming Public Classes
| July 8, 2025 9:00 AM to 4:00 PM ET |
| September 5, 2025 9:00 AM to 4:00 PM ET |
| November 14, 2025 9:00 AM to 4:00 PM ET |
Designed For
Les utilisateurs qui sont familiers avec le ruban d'accueil et qui souhaitent apprendre des fonctions plus avancées.
Results
- Travailler avec des noms de plage, notamment les appliquer, les modifier et les utiliser dans des formules.
- Utiliser des fonctions spécialisées, des fonctions imbriquées et des calculs automatiques dans le classeur.
- Analyser des données à l'aide de fonctions logiques et de recherche telles que SI, ET, RECHERCHEV et RECHERCHEX.
- Effectuer des calculs financiers et des calculs de date.
- Organiser des données à l'aide de tableaux, trier/filtrer des données et visualiser des données à l'aide de graphiques et sparklines.
Length
6 hrs
Venue
Virtual
Cost
$ 450.00
Upcoming Public Classes
| May 16, 2025 9:00 AM to 4:00 PM ET |
| July 21, 2025 9:00 AM to 4:00 PM ET |
| September 25, 2025 9:00 AM to 4:00 PM ET |
Designed For
Les utilisateurs avancés qui souhaitent utiliser des fonctions avancées d'analyse de données et de gain de temps dans Excel.
Results
- Ajouter des commentaires, des hyperliens, des filigranes et des images d'arrière-plan aux classeurs.
- Préparez-vous pour des audiences multiples en ajoutant du texte alt et en utilisant des outils d'accessibilité.
- Consolider des données, lier des cellules entre classeurs et fusionner des données tout en gérant les doublons.
- Protéger les classeurs, regrouper et délimiter les données, et utiliser les sous-totaux.
- Analyser des données à l'aide de tableaux/cartes croisés dynamiques, des segments et automatiser des tâches à l'aide de macros.
Length
6 hrs
Venue
Virtual
Cost
$ 550.00
Upcoming Public Classes
| May 29, 2025 9:00 AM to 4:00 PM ET |
| August 6-7, 2025 9:00 AM to 4:00 PM ET |
| October 22, 2025 9:00 AM to 4:00 PM ET |
FREE Microsoft Excel Training Courses Resources
We hope you'll visit our FREE Resources Page, where we have more of what you need to excel online! Choose from a list of our most commonly used shortcuts, blog articles and our previous FREE webinars.
Work Efficiently
- Navigate your way around a spreadsheet, including how to format it for easier viewing
- Customize the interface so it suits you and your work pattern
- Save time accessing the tools you use most often
- Share your work across your organization, while protecting its data integrity
Work Effectively
- Come to grips with basic formulas and functions so you can work comfortably with your data set
- Master the use of tables using sorting and filters to present your data clearly
- Explore more advanced functions like Logical and Lookup functions
Work Brilliantly
- Release the power of array formulas
- Use Excel as a database, opening up a world of possibilities to you as a more experienced Excel user
- Discover what Goal Seek, Solver, and Scenarios can do for you
- Master advanced Excel skills like outlining and pivoting your data that make your spreadsheets clear and easily interpreted by all who see them
And More...
From Data Analysis to Pivot Tables: Why You Need Excel Training
Microsoft Excel has become the industry standard for spreadsheets. It features all sorts of calculations, charting tools, table tools, database tools, and more. No matter what you already know about Excel, there will always be something new to learn. You want to learn to use Excel to its full potential to save time and keep your data well organized.
- Tired of spending hours trying to figure out simple calculations in Excel?
- Have a hard time creating spreadsheets that simplify your data?
- Wish Excel could do more of your work automatically on your behalf?
Our Excel basic to advanced training is the perfect solution.
A Hands-On Approach, Whether You Learn Excel Online or In-Person
Where can I take an Excel class? Private classes can be online, delivered at our convenient Downtown Ottawa location, or right at your location, saving you the hassle of travelling offsite. Our public classes are available online, so you can learn from anywhere.
In private classes, or in groups, you’ll learn from experienced, friendly instructors who know how to make you feel comfortable in your learning environment.
Our public classes are regularly scheduled. This online training provides a cost-effective way to provide training for individuals. Our experienced instructors offer engaging, practical sessions that will help you bring the skills you need to life.
A more cost-effective way to learn is with private group classes held within your organization. Here, you can train multiple students together, with the classes optimized to focus on the Excel training topics you specifically need.
Our Great Canadian Training Advantage
The Great Canadian Training & Consulting Company is patient and reliable. Our Excel basic to advanced training will help you find and learn the functions and features you need, so you can work more efficiently and painlessly. We offer private training and consulting services that will help you learn to use Excel at any level.
Many people are intimidated by the power of Excel, but we’ve got the experience and the passion to help you learn at your own pace and convenience. We can help you customize your course with very little hassle and with very competitive pricing.
We care and we are there for you every step of the way. We stick by you even after training is over, by ensuring your Excel training success with our after-training support options as well.
Tailor Or Customize the Topics Covered
We can also provide customized Excel basic to advanced training to suit your specific requirements. You can mix and match from our various Excel training topics to build a course especially suited to you.
You can even learn using your own Excel spreadsheets instead of our packaged exercise files if you prefer.
Let us know what you want, and we’ll work with you to develop the course you’d like.