Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy for ONLY $1!
Access for $1- 30+ Excel & Office Courses
- Certificates of Completion
- Practice Workbooks
- 5 Amazing Bonuses
Course Curriculum
Beginner
5 courses • 56 Lessons • 7 Hours
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!
Charts
Introduction to Images, Shapes, Smart Art & various Charts to spice up your presentations!
Formatting
Learn the most used formatting features like adding/deleting columns or rows, copying & moving worksheets, font formatting, number formatting and conditional formatting.
Printing
Learn how to properly layout your page, print your documents and create custom templates that you can reuse time and time again.
Intermediate
5 courses • 216 Lessons • 10 Hours
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.
Advanced
10 courses • 569 Lessons • 29 Hours
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
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!
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!
Microsoft 365
13 courses • 288 Lessons • 11 Hours
Copilot
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.
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.
Power Automate
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.
About Me
Since 2014 I have helped over 1 million professionals from 100+ countries to ADVANCE their Excel level and stand out from the crowd!
I am an Amazon #1 bestselling author (101 Most Popular Formulas, 101 Ready To Use Macros and 101 Best Excel Tips & Tricks), sought-after speaker, and teacher of Microsoft Excel & Office over at my flagship Academy online course.
In 2020 I was recognized by Microsoft Corporation for my outstanding Excel expertise and community work with the prestigious "Microsoft MVP" award.
I have a degree in Accounting and have worked for Fortune 500 companies such as Avon Cosmetics and General Electric as a financial analyst.
I blog about Microsoft Excel and host the only Excel podcast show in the world.
I live in Spain (even though I was born in Australia) with my wife and 2 beautiful kids and love a good bbq and red wine!
Testimonials
I've now 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
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!”
Jonathan Group
Sales Manager
It really saved me tons of time and my financials were done within a week and a half versus a month!
Just do it!"
Sue Koenig
Book Keeper & Office Manager
I can now demand a higher level of compensation from my clients. I can do more myself and not have to pay other people to do something that I would have to job out."
Andrew Phillips
Business Consultant
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."
Lori Crossen
Director of Front Office Systems
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
I would say I'm saving a day a week, just in terms of the amount of information that I'm able to process now versus before."
James Durkan
Commercial Director
If somebody really wants to learn a lot more about Excel and do it in a fashion where you're not just searching in the dark, then I think this is a good tool to do that."
Jim Nicklas
Engineer & Manager
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
It's nice that people can come to me and say 'Michele can you do this for me?' and I can actually say 'YES I CAN!'. It's helped my confidence immensely. "
Michele Porchina
Office Administrator
I think it's one of the best investments that I've ever made on myself, besides school!"
Debbie Trenholm
Business Analyst
If you were an advanced Excel user you would be a benefit to that company and you would be adding value right from day one. So you should be learning something new every day and that was why I signed up for the academy."
Jerri Van Hoose
Accounting Manager
That's one of the best investments I've made, as far as for myself. Becoming the expert in the office, that they can come to me and be the go-to person, I think that's gonna help me down the road."
Keith Fariss
Sales Executive
I knew it was so important to me personally that I made the personal investment. It turns out that my boss saw the value of the company making the investment for me, which was a plus for me. And I can take that skill with me wherever I might find myself."
Lawrence Almengor
Financial Controller
In this Academy, it's really well structured. It's really a huge volume of knowledge, which you can get on a really easy way. And also for me, as a non-native speaker, it's really easy to understand."
Sebastian Weiß
Global Business Manager
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