When you join the MyExcelOnline Academy, you get access to all the Excel course levels & all Microsoft Office courses.
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!
Learn the most used formatting features like adding/deleting columns or rows, copying & moving worksheets, font formatting, number formatting and conditional formatting.
Introduction to Images, Shapes, Smart Art & various Charts to spice up your presentations!
Learn how to properly layout your page, print your documents and create custom templates that you can reuse time and time again.
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.
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 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.
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!
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.
You can cancel at any time within the first 30 days and receive a full refund.
Plus, you get to keep all our best-selling Excel ebooks, templates, Cheat Sheets and workbooks!
Billed monthly. Cancel anytime.
30 day money back guarantee
Billed monthly. Cancel anytime.
30 day money back guarantee
Billed annually. Cancel anytime.
30 day money back guarantee
Billed annually. Cancel anytime.
30 day money back guarantee
Excel Time-Saving Resources: 101 Excel Tips E-Book, Ready-Made Excel templates & 333 Excel Shortcuts Course that will save you hours per day!
Instant access to all our Microsoft Office courses
A cheat sheet of insights from world class Excel and HR experts into the top Excel questions that get asked in a job interview - and the best way to answer them!
Get 24x7 support from our Microsoft trained experts and instant Excel answers through our Q&A Forum, so you are never stuck or feel alone.
Our Best Selling Excel E-Books: 101 Ready To Use Excel Macros E-Book, 101 Most Popular Excel Formulas E-Book & 101 Ways To Master Excel Pivot Tables E-Book!
An Exclusive Academy Welcome Pack: Academy pen, stickers, mouse pad, laminated keyboard shortcuts template & T-Shirt, that will be mailed out to your, free of charge!
Thousands of managers, accountants, finance analysts, administrators, CFOs and other corporate professionals, trust the MyExcelOnline Academy to enhance their professional development and every day.
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!
Finance OfficerRead more
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.
Sales ManagerRead more
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.
Director of Front Office SystemsRead more
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.
Data AnalystRead more
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!
Maintenance PlannerRead more
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".
Finance and Business EconomistRead more
Anyone who wants to elevate their Excel knowledge & skills, including…
• New users, beginners, intermediates and advanced Excel users.
• Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and reporting.
• People who want to change career and apply for a new job that requires knowledge of Microsoft Excel
It doesn’t matter if you are completely new to Excel. No prior Excel knowledge is necessary to participate in the Academy.
The tutorials were recorded using Excel 2010, 2013, 2016, 2019 and Office 365.
Most of the concepts taught are compatible with:
• Excel for Windows: 2007, 2010, 2013, 2016, 2019 & Office 365
• Excel for Mac: 2011, 2016, 2019 & Office 365
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 email@example.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.