Excel is the spreadsheet application in the Microsoft Office suite. And it does so much more than just tally numbers – you can easily organize, visualize, and discover insights from your data with Excel. Whether you’re just learning how to create spreadsheets or you need to perform advanced data analysis with functions, our training will get you up and running comfortably.
I had been using Excel for years but only scratching the surface. Al explained everything clearly, with examples that applied directly to my work. This was by far the most useful training I’ve ever taken.
No matter where your data comes from – whether it’s a small or very large data set – you can connect, clean, analyze, and share your data faster using Power Query. This course guides you through the essentials of data extraction and transformation, teaching you to seamlessly integrate data from multiple sources and transform the time-consuming chore of data preparation into an efficient, automated process.
This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors. You will also learn how to organize and manage lists and tables (including sorting, filtering, and analyzing).
Get ready to ramp up your productivity. Using robust formulas and surprisingly simple techniques, you will be slicing and dicing to discover the power of data analysis. You’ll create Pivot Tables, build fully functional financial dashboards, and complete relevant exercises. At this level, Excel is an eye-opener. Unlike Intermediate Excel courses found elsewhere, this workshop teaches you features you will actually use and remember.
Are you an advanced Excel user? Do you need to consolidate data from several worksheets, work with external data, or perform What-IFs? Would you like to learn how to use macros or create rolling charts? This one-day course will teach you all that and a whole lot more with time-saving techniques and formulas. We also dive into Power Query for gathering data quickly and shaping it easily.
Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized and analyzed with just a few mouse clicks, and without any formulas. You'll be able to drag and drop fields directly into a Pivot Table to change your report layout to whatever you want, whenever you want. This one-day workshop culminates in building a sophisticated, yet uncomplicated dashboard that communicates financial information with power and ease you never thought possible.
This course is especially beneficial to accountants, financial managers, and analysts.
<p>Forecasting is a valuable tool in business planning. It allows you to reliably predict company performance, trends, etc. Forecasting applies to expenses as well as revenues, and can provide a clearer understanding of future profits and losses. Ultimately, business forecasting enables better decision-making. Historical data is analyzed to detect patterns which helps to predict future performance.<br /></p>
When you need special training, you can cherry-pick your own topics of interest and create a course agenda that suits you perfectly. If you want, we can help you plan exactly how you want to enhance your productivity with Excel. Custom Training courses have a very high satisfaction rating from our clients.
Dynamic Arrays are the most significant enhancement to Excel in years. Traditional array formulas (one formula, multiple results) have always been possible but they’re complicated and cumbersome to use, and usually require careful replication. New functions you will learn include: XLOOKUP, UNIQUE, FILTER, and SORT. Now, with Dynamic Arrays, formulas are simpler and easier to manage, and they usually require no replication at all. Dynamic Arrays are available to users of Excel 365 or later.
Anyone who works with data, reports, or spreadsheets will benefit. Our courses are designed for professionals in business, finance, administration, sales, marketing, HR, operations, and beyond. We offer beginner through advanced options, so there’s something for every level.
A live instructor guides you step by step. Each concept is demonstrated, then you’ll practice it right away. Training is delivered virtually, and sessions are hands-on from the start.
Participants receive a digital resource pack with step-by-step instructions and exercise files they can use during and after training.
No. If you’re new to Excel, you can start with our Excel for Beginners course. If you already use Excel and want to expand your skills, our intermediate and advanced courses will help you progress
We offer flexible options — from short 2-hour workshops to half-day, full-day, or multi-day sessions. The length can be tailored to your team’s needs.
While this is not a certification program, students receive a certificate of completion from The Training Company as proof of professional development.
Depending on the level, courses cover everything from basic formulas and charts to advanced tools like pivot tables, Power Query, Power Pivot, and Macros. We also offer specialized courses in data analysis and Excel for business professionals. See the complete course listings, below.
Yes. We can adapt examples, exercises, and topics to reflect your industry, data types, and specific Excel challenges.
At The Training Company, we help professionals build the skills that make work easier, faster, and more impactful. Our courses combine expert instruction with real-world projects so you can immediately apply what you learn.
Whether you’re creating stunning designs, managing complex projects, analyzing data, or producing compelling content, our goal is simple: to help you work smarter, not harder.
We are proud to be a Canadian company.
You can expect your instructor to be helpful and engaging. Your Microsoft Excel training will be hands-on, right from the start, and your day lasts about 7 hours including breaks and lunch. You will get lots of practice with the basics so you can be confident diving into projects back in the office. Your Microsoft Excel training is structured so that you understand and remember the lessons learned.
You will work on practical exercises—learning new skills and professional techniques that you will use in your own real-world projects. You will meet attendees who are like-minded people pursuing similar goals. You can expect lively Q&As. We hope you’ll ask all the questions you want. Please let us know before the event if you have any special requests or challenges.
» Cancellations made more than 5 days before a course date qualify for a full refund minus a $35 administration fee per student.
» Cancellations made less than 5 days before a course do not qualify for a refund but the class may be rescheduled.
» Cancellations made within 48 hours of the start time are not eligible for a refund and may not be rescheduled.
» We are not able to offer refunds or rescheduling for no-shows or uncompleted courses.
» There is no charge for rescheduling when you inform us at least 3 days before the course.
» An administration fee of $35 per person is charged when rescheduling less than 3 days before a course.
» Student substitutions are free. If you cannot take a course maybe your colleague can. Just let us know.
» It is rare that classes do not run as scheduled but we do reserve the right to reschedule previously confirmed classes.
