Track your team's progress & completion rates via our analytics dashboard.
Course completion certificates so you can put on LinkedIn or add to your CV
Access to 1,000+ short video tutorials covering all Microsoft Excel & Office features, tailored to your level.
24x7 Support to answer your Excel & Office questions, so you are never stuck or feel alone
Downloadable workbooks so you can practice and increase your skills
Get 5 Amazing FREE Bonuses which include Courses, E-Books, Templates, Cheat Sheets & an Exclusive Academy Welcome Pack!
5 courses • 56 Lessons • 7 Hours
An introduction to Microsoft Excel taking you through the workbook interface, menu ribbon features, entering data into your worksheet and saving.
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!
Introduction to Images, Shapes, Smart Art & various Charts to spice up your presentations!
Learn the most used formatting features like adding/deleting columns or rows, copying & moving worksheets, font formatting, number formatting and conditional formatting.
Learn how to properly layout your page, print your documents and create custom templates that you can reuse time and time again.
5 courses • 216 Lessons • 10 Hours
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!
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!
An introduction to Macros & VBA, recording Macros, creating Macro buttons and editing your Macros that will save you hours each week!
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!
Visualize your data with Charts like Column, Bar, Pie, Bubble, Scatter and Sparklines.
10 courses • 569 Lessons • 29 Hours
Advance your Formula skills with various nested formulas, Array formulas and advanced Lookup formulas like VLOOKUP, INDEX/MATCH, OFFSET, SUMPRODUCT plus heaps MORE!
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!
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!
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!
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!
Gain insights on how to use the various data predictive tools like: Goal Seek, Solver, Data Table, Scenario Manager, Relationships and Forecasting!
Expand on your Charting knowledge by learning the advanced Charts, formatting Charts and the new Excel 2016 Charts!
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.
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!
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!
13 courses • 288 Lessons • 11 Hours
Microsoft Copilot is your AI-powered productivity assistant inside Microsoft 365, designed to help you work faster, think smarter, and create better results across tools like Excel, Word, PowerPoint, Outlook, and Teams. In this course, you’ll learn how to use Copilot to write emails, summarize documents, analyze data, create presentations, generate ideas, automate repetitive tasks, and save hours every week. Whether you’re a beginner or an experienced Microsoft user, this course will show you practical, real-world ways to turn Copilot into your everyday work assistant.
Use Microsoft Word to create business letters, business cards, resumes, product manual, reports, flyers, restaurant menus, invitation cards, labels, forms, and many more.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
We do our best to provide you the best experience ever
The tutorials were recorded using Excel 2010, 2013, 2016, 2019 and Office 365.
Most of the concepts taught are compatible with:
No - this isn’t like school - this is self-paced learning - you decide when you start and when you finish.
You get access to all the training materials.
You can access the course site from your work computer, home computer, tablet, smartphone or any other device with an internet connection.
The course site remembers your progress, so you can pick-up right where you left off on any device. That means you can watch a few videos at work, then continue right where you left off on your home computer.
If you choose to cancel your membership you will no longer have access to the membership resources.
MONTHLY MEMBERSHIP - You have access to the Academy courses & teacher support each month, as long as you are a paying monthly member. Once you cancel your membership your course access and teacher support will end and you will not be rebilled again the following month.
ANNUAL MEMBERSHIP - You have access to the Academy courses & teacher support for 12 consecutive months. After 12 months you will be rebilled for another 12 months access. You can cancel your membership at any stage and you will not be rebilled again.
* Our 30-Day Money Back Guarantee means you can enroll today, get instant access to all the training resources & support, and if you then decide the Academy isn’t for you, we’ll give you a full refund within 30 days of enrolment.
* There are no pro-rata refunds on the ANNUAL MEMBERSHIP for cancelling after 30 days.
The Academy course is broken down into the following levels:
• Excel Beginner - 7 hours
• Excel Intermediate - 10 hours
• Excel Advanced - 29 hours
• Microsoft Office - 10 hours
This depends on how much time you have to spend each day watching the videos. We recommend watching one or two videos a day and then practicing the techniques in your job.
Each person learns at a different pace, so one can finish all the courses within a few weeks or a few months.
Yes! You will be able to download and keep all the excercise files in each of the courses inside the Academy as well as our PDF Cheat Sheets.
This makes it easy to follow along and practice with our data, whether you are online or offline.
Yes, the Academy course and all the training materials can be accessed on any tablet or smartphone, and it looks beautiful. You can watch the course on your iPad, Tablet or mobile phone anywhere and anytime!
Each video has a discussion section. You can use this section to ask questions and see what questions other students have. We will be there helping to answer your questions.
You can also find answers to your questions on the MyExcelOnline Forum which all members have access to.
You can also send an email to our dedicated email support if you cannot find your answer.
Yes, you can use your company's credit card to pay for the course. A receipt will also be emailed to you that you can submit for reimbursement to your employer. Most companies are willing to invest in making their employees even more awesome at Excel!
Yes, there is a team package available at a discounted price. If you get 1 or more of your colleagues or friends to join up to The MyExcelOnline Academy, then we will give you all a 30% discount on your membership!
Each team member will have their own account and be able to track their progress in the course. Get a quote by filling in this form here: https://www.myexcelonline.com/corporate-academy-team-packages
MONTHLY MEMBERSHIP - You will automatically be billed on the same day every month as you made your first payment. So if you enroll on the 15th of the month, you will be billed on the 15th of each month.
ANNUAL MEMBERSHIP - You will automatically be billed every 12 months. So if you enroll on the 15th of the January 2020, you will be billed again on the 15th of January 2021.
You can cancel your membership at any time and your next scheduled payment will not be taken.
You can get a full refund of your purchase within 30 days of Academy enrolment, with our 30 day money back guarantee.
You can cancel your Academy Membership at any time during your subscription.
If you are cancelling your membership outside the initial 30 day money back guarantee period, a refund will not be issued for your account.
We accept all major credit cards like Visa, MasterCard and American Express, as well as PayPal for the ANNUAL membership only.
The course fees are shown in USD $
Get in contact with us if you want to pay via bank transfer or check at support@myexcelonline.com
If you need a Tax Invoice for your records, then this can be emailed to you.
We are happy to complete any paperwork your company or government may require.
If you have any questions about joining the MyExcelOnline Academy, we will be happy to answer you by sending an email