Microsoft Excel – 2019 / 365
Announcements
-
What are people saying about our courses?
-
Re: our Memory and Recall Skills Course
I was in your group recently and I would like to let you know that I use the different methods for lists. It is true that we don't need paper anymore, specially when you are in the bus and you
need to remember some tasks. I visualize the ten items (pencil, swan etc.) with my tasks and when I arrive at the office I know what I have to do. It's awesome.
Thank you again for the 2 days that are really useful.
L.D. Canadian Heritage
-
From: CRA
"This was a great course, but more importantly it was greatly delivered by a very amazing/impressive instructor. Thanks."
-
From: Public Health
"Highly recommend this course for all users of Excel. Informative and useful in the workplace. Thank You!"
-
-
THE DEFINITIVE & COMPLETE EXCEL SERIES
We have extended our Excel offering for 2019 / 365 versions by adding several new premium courses in addition to our Excel Fundamentals courses.
-
Excel 2019 / 365 Fundamentals and Premium Courses
-
↑ Return to Course Outlines
Microsoft Excel
Advanced Charts, Graphs & Sparklines
Do you use Charts and graphs in your reports? If so, then you don’t want to miss this great 1 day course. There is so much which you can do with Charts and Graphs and we will look at all the nooks and crannies of this great Excel feature. What you will learn: Add …
Creating Advanced Reports with Dashboards
If you create reports on a regular basis, and of course many of you do, be prepared to be absolutely amazed by what you can do after attennding this great course. The secret sauce to creating incredible reports is something called Dashboards. So, what is an Excel Dashboard? An Excel Dashboard provides insight, analysis and …
Database Management in Excel
Excel has proven to be the software of choice for a broad range of database management tasks. While Excel is not a true relational data management program like Access, it does a terrific job of handling a wide range of database tasks. Excel has multiple features for organizing and managing data, so you can ensure …
Excel 2010 to 2019 Transition & Advanced Features
This unique 2 Day course builds upon the Microsoft EXCEL 2010 knowledge and skills you’ve already acquired at the foundation level. We will focus on the enhanced features you’ll want to leverage to improve the way you create your spreadsheets and manage your data. You’ll explore a variety of enhancements which will dramatically increase the …
Excel 2010-2019 / 365 – Level 2
Level 2 – 2 Days Simple spreadsheets are fine for basic applications but in a real-world business environment things are not usually that simple. This course will take you through several techniques and situations for handling more realistic situations and will give you the understanding and the tools to create more complex spreadsheets on your …
Excel 2010-2019 / 365 – Level 3
Level 3 – 2 Days If you have attended our Level 1 and Level 2 courses you have a good foundation of how to navigate Excel as well as having a good grasp of the tools to build worthwile spreadsheets. In this course we will get under the hood of Excel and explore all of …
Excel 2019 / 365 – Level 1
Level 1 – 1 Day This course shows you the basics of how Excel can calculate budgets and financial projections for you by teaching you how to create a small spreadsheet from the beginning of a blank page to the end of saving and printing a professional-looking document. If you’ve never used Excel before, or …
Excel Advanced Formulas & Functions
This 2 day advanced functions and formulas class has the goal of teaching as many useful functions and formulas as possible. It has also the goal of teaching the best way to link functions together in the different tools excel has for you. Excel’s core strength is its ability to perform calculations, and …
Excel for Project Managers
Duration: 2 Days This 2 day course will help project managers and analysts save a substantial amount of time in their project management activities, learn better solutions to their existing problems and help them plan more effectively. This hands-on course is divided in three main modules, Planning & Budgeting, Tracking and Reporting. It will systematically …
Excel for Statistical Data Analysis
Duration: 2 Days Course Objectives This 2 day course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research. This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It …
Excel Macros
This great 1 day class is all you need to know about macros! Do you tend to repeat tasks multiple times? Do you have to do the same thing day in and day out? Why not make your process in 1 click? In this class you will see the beauty of recording macros and …
Excel Productivity Tips & Tricks
This course is packed full of amazing, time busting and problem solving tips and tricks. Make the effort to attend!! You’ll love it! You will Learn: How to have a picture automatically pop up when hovering over a cell HELP!! – I have sorted but how do I get back to the original sort order? …
PowerPivot for Excel
PowerPivot for Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the application users already know and love— Microsoft Excel. You can transform enormous quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. By …
The Complete Excel Pivot Tables
An In-depth Look at the Power of Pivot Tables Get under the hood and unleash the power of Pivot Tables! Of all the great features that make Excel so great and so much fun to use none are as powerful and compelling as Pivot Tables. In this great 2 Day dedicated workshop we will get …
VBA for Excel
Level 1 Duration: 3 days While Excel is a very powerful and complete tool, you’ll sometimes encounter situations where the program is missing some feature you really need. Using VBA will allow you to solve a variety of problems as well as greatly improving the efficiency of your workflow particularly when faced with repetitive tasks. …