Advance your employees Microsoft Excel & Office Skills without breaking your training budget!
Develop The Skills Your Workforce Needs To Grow & Succeed
Exponentially Increase Your Employees Motivation & Retention!
Training solutions for companies of all sizes.
Find out more
Course Curriculum
When you join the MyExcelOnline Academy, you get access to all the Excel course levels & all Microsoft Office courses.
Introduction
An introduction to Microsoft Excel taking you through the workbook interface, menu ribbon features, entering data into your worksheet and saving.
Formulas
An introduction to Formulas, cell referencing, order of operations, relative v absolute references and exposure to common formulas that will get you up and going fast!
Formatting
Learn the most used formatting features like adding/deleting columns or rows, copying & moving worksheets, font formatting, number formatting and conditional formatting.
Charts
Introduction to Images, Shapes, Smart Art & various Charts to spice up your presentations!
Printing
Learn how to properly layout your page, print your documents and create custom templates that you can reuse time and time again.
Formulas
Learn how to create Named Ranges, the various useful IF formulas, VLOOKUP, HLOOKUP, INDEX & MATCH, OFFSET, INDIRECT, SUMPRODUCT, TEXT formulas, nesting formulas, auditing your formulas and List formulas!
Pivot Tables
Build your must have Pivot Table skills and learn its various powerful data analytic features including: Summarize Values, Group data, Filter & Sort, Slicers, Calculated Fields & Items, Pivot Charts plus Conditional Formatting!
Macros & VBA
An introduction to Macros & VBA, recording Macros, creating Macro buttons and editing your Macros that will save you hours each week!
Data & Analysis
Learn the must know analytical tools within Excel like: Sorting & Filtering, Excel Tables, Data Validation drop down menus, Text to Columns, Flash Fill plus MORE!
Charts
Visualize your data with Charts like Column, Bar, Pie, Bubble, Scatter and Sparklines.
Formulas
Advance your Formula skills with various nested formulas, Array formulas and advanced Lookup formulas like VLOOKUP, INDEX/MATCH, OFFSET, SUMPRODUCT plus heaps MORE!
Pivot Tables
Learn the tips that Excel gurus use to analyze their data with a few mouse clicks, create KPIs on you business, interactive Excel Dashboards, learn the GETPIVOTDATA formula plus much MORE!
Macros & VBA
Learn the key VBA concepts to automate your Excel reports & make you more productive, like: Worksheet & Range Objects, Relative References, Modules & Procedures, Variables & Data Types, Conditional Statements & Loops, Message & Input Boxes plus create interactive data entry User Forms! WOW!
Power Query (Get & Transform)
Learn how to install Power Query, consolidate workbooks & worksheets and create management, clean up your dirty data and transform your data into easy to read reports!
Power Pivot
Expand on your Pivot Table knowledge with this super charged add-in! You will learn how to import your data, create relationships, advanced calculations/measures plus various DAX formulas. This is Pivot Tables on STEROIDS!
Data & Analysis
Gain insights on how to use the various data predictive tools like: Goal Seek, Solver, Data Table, Scenario Manager, Relationships and Forecasting!
Charts
Expand on your Charting knowledge by learning the advanced Charts, formatting Charts and the new Excel 2016 Charts!
Microsoft Access
Learn Microsoft Access, a database management system where you can store over 1 million rows of data for reference, reporting, and analysis. You can also use Excel to create more robust reports & charts by importing data from Microsoft Access.
Power BI
Learn Microsoft's most powerful Business Inteligent platform. Power BI is a business analytics service that delivers insights to enable fast, informed decisions. Transform data into stunning visuals and share them with colleagues on any device.
Excel Dashboards
Learn to create awesome interactive Excel Dashboards that showcase your Key Performance Indicators (KPIs) on one page by using Excel Charts, Formulas, Tables, Form Controls and more!
Financial Modeling
Learn how to create a Financial Model using the core Excel concepts & formulas, learn various Financial Modeling skills and create a real life Financial Model business case with Profit & Loss, Cash Flow, NPV, IRR, payback periods, scenario analysis plus MUCH MORE!
Word
Use Microsoft Word to create business letters, business cards, resumes, product manual, reports, flyers, restaurant menus, invitation cards, labels, forms, and many more.
Outlook
Microsoft Outlook is a powerful email client used by most corporate enterprises in the world. It also includes such functions as calendaring, task managing, contact managing, note-taking, journal logging and web browsing.
PowerPoint
Microsoft PowerPoint is your tool to create slides for your presentations. PowerPoint supports audio, videos, and animation effects to help you give your presentation greater impact.
Access
Microsoft Access is an application used to create databases to store and manage your business data. It provides you with tools to create data tables, queries, forms, reports, and tools to help you write Visual Basic codes to customize the functionality of your database application.
OneNote
Microsoft OneNote is a feature-rich note-taking application. OneNote keeps your notes, plans, and thoughts all in one place. You create sections, pages, and sub-pages just like a tradition paper notebook and use color codes to organize your notes.
Teams
Microsoft Teams is a feature-rich and secure collaboration and communication application. It supports instant message/chat, audio calls, video conferencing, and collaboration features. Other features include the ability to host meetings with thousands of participants, record your meetings, and to share your screen for when you are hosting a training session.
PowerAutomate
Formerly Flow, Microsoft Power Automate is a cloud-based tool to help organizations develop workflows to automate tasks and processes. It's a useful tool to help bring automation to repetitive tasks, such as approval workflows, data collecting, or synchronize files between applications.
Power Apps
Microsoft Power Apps is a collection of tools to help you build customized web-based and mobile apps to meet your business needs. It's biggest benefits are automation and workflow. These enable businesses to improve productivity and processes, streamline tasks, and minimize the use of paper.
SharePoint
Microsoft SharePoint is a cloud-based application used to build intranet websites to share and management information and collaborate with others within your organization. Features of SharePoint can be used to create as a document management tool, a knowledge base, a management workflow, a calendar of events, a ticketing system, and much more.
Visio
Microsoft Visio is a diagramming and vector graphics application. You can create diagram types such as Flowcharts, Org Charts, Floor Plans, Network Diagrams, UML Diagrams, Mind maps and more.
Project
Microsoft Project is a powerful and popular tool to plan and manage projects. It provides the tools to management tasks, dependencies, milestones, Gantt chart and more.
Forms
Microsoft Forms is a web-based application that allows you to create forms to collect data and feedback from users, such as surveys, questionnaires and polls.
But Don’t Just Take Our Word For It
Thousands of managers, accountants, finance analysts, administrators, CFOs and other corporate professionals, trust the MyExcelOnline Academy to enhance their professional development and every day.
I got another job and my career has improved immensely!
To get a promotion or to get another job, I did need to have better Excel skills. I've got a new job and I feel that I can use some of the aspects of Excel without even doubting that I can do them, which I did before!
Anne Train
Finance Officer
Read more
It's really improved my confidence in working with Excel
It's really improved my confidence in working with Excel and also just opened up a lot of opportunities that I didn't have before because I didn't even know the huge amount of things you can do with Excel.
Jonathan Group
Sales Manager
Read more
I am saving so much time that I'm actually getting off on time and taking breaks
I am saving so much time that I'm actually getting off on time and taking breaks, because I'm not just behind all the time. People are now coming to me and saying "Can you help me with this?", instead of, I was always the one going to people. It's been kind of a turnaround.
Lori Crossen
Director of Front Office Systems
Read more
It's your first source to go to
When you don't know something you tend to go to Google to try to find it, but using MyExcelOnline, that is your first source to go to and they've been really good about keeping the training courses relevent and updated all the time.
Gary Kendrick
Data Analyst
Read more
It's been the best investment I've ever done!
Like anything online I'm very sceptical about memberships, and I was very hesitant to start with but I liked what I saw and I thought I'd give it a go.
I've never looked back since, it's been the best investment I've EVER done!
Mark Moggridge
Maintenance Planner
Read more
You need to enroll. You don't have any idea what I've learnt.
You need to enroll. Do you think you know so much about Excel? You don't have any idea what I've learnt. Even I started from the basics and I'm like "oh, I didn't know I could do that".
Sophia Ekokobe
Finance and Business Economist
Read moreSome of our Academy students work at
If any of this strikes a chord, then this course is for your company…
- Your employees are starting to learn Microsoft Excel late in life or they’ve been using it for decades, they’re a manager, accountant, finance analyst, administrator, sales rep, CFO or any other corporate professional, and have wondered how to increase their professional development in a cost-effective way!
- You want to upskill your employees with personalized training that will keep them motivated and engaged for a long period!
- Your employees spend hours each month running reports, analyzing data and working overtime. Wondering if there’s a better, more efficient way of doing things, so they can save hours from their busy schedule and save your company money!
What’s included?
Access to 1,000+ short video tutorials covering all Microsoft Excel & Office features, tailored to your level.
New Excel & Office video tutorials and courses added every month, so you are up to date with the new features that come out
Downloadable workbooks so you can practice and increase your skills
Course completion certificates so you can put on LinkedIn or add to your CV
24x7 Support to answer your Excel & Office questions, so you are never stuck or feel alone
Get 5 Amazing FREE Bonuses which include Courses, E-Books, Templates, Cheat Sheets & an Exclusive Academy Welcome Pack!
Contact support
If you have any questions about joining the MyExcelOnline Academy, we will be happy to answer you by completing this form: Get in touch
© Copyright 2024 MyExcelOnline SLU. All rights reserved.