WHAT YOU WILL LEARN
THIS COURSE INCLUDES:
|
|
7 hours on-demand videos
127 bite sized video training
Downloadable practice workbooks & resources
Lifetime Access on any device
Certificate of Completion
24x7 supportWHO THIS COURSE IS FOR
- You're starting to
learn Microsoft Excel late in life or you've been using it for decades, you're a manager, accountant, finance analyst, administrator, CFO or any other corporate professional, and have wondered how toADVANCE your Excel skills and level so you can get an advantage over your colleagues or peers. - You're
preparing for job interviews, wishing for a quicker way to become confident at Excel, so you’ll have a greater chance of landing a job! - You
often search on Google and YouTube to find answers to your Excel problems. Wishing for a more comprehensive, reliable, and up-to-date source of answers with quick support whenever you get stuck. - You
spend hours each month running reports and analyzing data. Wondering if there’s a better, more efficient way of doing things, so you can save hours from your busy schedule and go home early to your loved ones. You’ve been given new data handling, analysis, and reporting responsibilities with little or no Excel training. - If you want to
dramatically reduce repetition, stress, and overtime andexponentially increase your chances of a promotion, pay raise or new job! - This course is compatible with Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2022 or Microsoft 365
COURSE CURRICULUM
| Introduction to Formulas |
| Cell References |
| Basic Formulas |
| Relative vs. Absolute References |
| Order of Operation |
| Function Basics |
| Common Formulas |
| Sum |
| Min & Max |
| Average |
| Count |
| AutoSum |
| AutoFill |
| Named Ranges |
| Creating a Named Range |
| IF Formulas |
| IF |
| Nesting the IF & AND Functions |
| COUNTIF |
| COUNTIFS |
| SUMIF |
| IFERROR |
| LOOKUP Formulas |
| VLOOKUP |
| HLOOKUP |
| INDEX & MATCH |
| TEXT Formulas |
| LEFT, RIGHT & MID |
| LEN |
| SEARCH |
| CONCATENATE |
| Formula Auditing |
| Trace Precedents |
| Trace Dependents |
| Watch Window |
| Show Formulas |
| Worksheet protection |
| Workbook Structure Protection |
| Workbook Password |
| DATE & TIME Formulas |
| DATE & REGIONAL LOCATION SETTINGS |
| DATEDIF |
| DATEVALUE |
| DAY |
| DAYS |
| EOMONTH |
| HOUR |
| MONTH |
| NETWORKDAYS |
| TODAY |
| WEEKDAY |
| WEEKNUM |
| WORKDAY |
| YEAR |
| ADVANCED FORMULA FUNDAMENTALS |
| Relative Cell References |
| Absolute Cell References |
| Variations on Absolute References |
| Name Ranges |
| Nesting Functions |
| EVALUATING & DEBUGGING FORMULAS |
| Evaluate Formulas |
| Locating Errors in a Formula |
| Using Excel's IFERROR() Function |
| ARRAY FORMULAS |
| What are Arrays? |
| Nesting Array Formulas |
| Using Arrays to SUM Data |
| Streamline Conditions Using Arrays |
| FUNDAMENTALS OF USING THE INDEX() AND MATCH() FUNCTIONS |
| INDEX() Function |
| MATCH() Function |
| Nesting INDEX() and MATCH() |
| ADVANCED INDEX() AND MATCH() EXERCISES |
| Creating a Dynamic SUM() Using INDEX() - Part 1 |
| Creating a Dynamic SUM() Using INDEX() - Part 2 |
| Combine Multiplication with INDEX() and MATCH() - Part 1 |
| Combine Multiplication with INDEX() and MATCH() - Part 2 |
| Create a Dynamic VLOOKUP() with MATCH() - Part 1 |
| Create a Dynamic VLOOKUP() with MATCH() - Part 2 |
| Create a Dynamic VLOOKUP() with MATCH() - Part 3 |
| Turn INDEX() and MATCH() into an ARRAY - Part 1 |
| Turn INDEX() and MATCH() into an ARRAY - Part 2 |
| Returning Multiple Values with INDEX() - Part 1 |
| Returning Multiple Values with INDEX() - Part 2 |
| Returning Multiple Values with INDEX() - Part 3 |
| Returning Multiple Values with INDEX() - Part 4 |
| Adding Criteria to INDEX() and MATCH() - Part 1 |
| Adding Criteria to INDEX() and MATCH() - Part 2 |
| Return an Associated Value Using INDEX() and MATCH() - Part 1 |
| Return an Associated Value Using INDEX() and MATCH() - Part 2 |
| Conditional Formatting Using MATCH() - Part 1 |
| Conditional Formatting Using MATCH() - Part 2 |
| TEXT FORMULAS |
| CLEAN - Intro |
| FIND - Intro |
| MID - Extract Numbers Between Hyphens |
| PROPER - Intro |
| REPLACE - Intro |
| REPLACE - Phone Area Codes |
| REPLACE - Insert Hyphens In Your Serial Number |
| REPLACE - Extract Last Name |
| REPLACE - Clear Everything Before the Hyphen |
| REPLACE - Insert New Code within Old Part Numbers |
| SUBSTITUTE - Intro |
| SUBSTITUTE - Add a Comma after the Surname |
| SUBSTITUTE - Remove Second Hyphen |
| SUBSTITUTE - Count Text Occurrences in a Cell |
| SUBSTITUTE - Report Name |
| TEXT - Intro |
| TRIM - Intro |
| TEXT TIPS! |
| Convert Formulas to Values |
| Convert Text to Numbers |
| TEXT ARRAY FORMULAS |
| MID {ARRAY FORMULA} - Extract Cell Contents in Separate Rows |
| ADVANCED VLOOKUP |
| VLOOKUP - A TAX TABLE WITH APPROXIMATE MATCH |
| VLOOKUP - SUM MULTIPLE COLUMNS WITH DATA VALIDATION DROP DOWN MENUS |
| VLOOKUP - MULTIPLE CRITERIA |
| SUMIFS |
| SUMIFS WITH DATA VALIDATION DROP DOWN MENUS |
| NEW EXCEL 2019 FORMULAS |
| CONCAT |
| IFS |
| MAXIFS |
| SWITCH |
| TEXTJOIN |
| NEW MICROSOFT 365 FORMULAS |
| FILTER |
| LAMBDA |
| LET |
| RANDARRAY |
| SEQUENCE |
| SORT |
| SORTBY |
| UNIQUE |
| XLOOKUP |
| XLOOKUP - More Examples |
| How to use the XLOOKUP function in Excel with 7 Examples! |
| LAMBDA Function in Excel - Create Custom Functions in Excel |
| OTHER ADVANCED FORMULAS |
| Dynamic Search List using Data Validation & Formulas |
| Nested IF Formula with VLOOKUP Formula |
| MATCH, HLOOKUP & VLOOKUP |
But Don’t Just Take Our Word For It
Thousands of managers, accountants, finance analysts, administrators, CFOs and other corporate professionals, trust MyExcelOnline 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 more
Some of our course students work at...
Save with our Courses Bundles!
Intro to Excel Bundle
An introduction to Microsoft Excel to get you up to speed and confident using the most common features!
- Introduction to Excel
- Formulas
- Formatting
- Charts
- Printing
- 5 Hours | 56 Lectures | Beginner Level | Certificate of Completion | 24x7 Support | Lifetime Access
Intermediate Excel Bundle
Learn the must know Microsoft Excel features to elevate your Excel level!
- Formulas
- Pivot Tables
- Macros & VBA
- Data & Analysis
- Charts
- 11 Hours | 216 Lectures | Intermediate Level | Certificate of Completion | 24x7 Support | Lifetime Access
Advanced Excel Bundle
Learn the must know Microsoft Excel features to advance your Excel level!
- Formulas
- Pivot Tables
- Macros & VBA
- Power Query
- Power Pivot
- Power BI
- Excel Dashboards
- Financial Modeling
- Charts
- 40 Hours | 569 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access
Microsoft Office Bundle
Learn the must know Microsoft Office applications to make you more productive at work!
- Outlook
- PowerPoint
- Word
- Teams
- OneNote
- Access
- Power Automate
- Power Apps
- Project
- SharePoint
- Visio
- Forms
- 14 Hours | 50 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access
- You're starting to learn Microsoft Excel late in life or you've been using it for decades, you're a manager, accountant, finance analyst, administrator, CFO or any other corporate professional, and have wondered how to get an advantage over your colleagues or peers.
- You're preparing for job interviews, wishing for a quicker way to become confident at Excel, so you’ll have a greater chance of landing a job!
- You often search on Google and YouTube to find answers to your Excel problems. Wishing for a more comprehensive, reliable, and up-to-date source of answers with quick support whenever you get stuck.
- You spend hours each month running reports and analyzing data. Wondering if there’s a better, more efficient way of doing things, so you can save hours from your busy schedule and go home early to your loved ones.
- You’ve been given new data handling, analysis, and reporting responsibilities with little or no Excel training.
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 careers and apply for a new job that requires knowledge of Microsoft Excel
- If you want to dramatically reduce repetition, stress, and overtime and exponentially increase your chances of a promotion, pay raise or new job!
- It doesn’t matter if you are completely new to Excel. No prior Excel knowledge is necessary to participate in this course.
The tutorials were recorded using Excel 2010, 2013, 2016, 2019, 2022 and Microsoft 365.
Most of the concepts taught are compatible with:
- Excel for Windows: 2007, 2010, 2013, 2016, 2019, 2022 & Microsoft 365
- Excel for Mac: 2011, 2016, 2019, 2022 & Microsoft 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 for life.
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.
Yes! You will be able to download and keep all the excercise files in each of the courses 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, this 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 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!
We accept all major credit cards like Visa, MasterCard, American Express, Apple Pay and PayPal.
Through our partners like Klarna, Afterpay, and Affirm, we can give you the flexibility of breaking up your purchase into easy installments.
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.
Yes! Each course comes with lifetime access to all course materials.
There are team packages available at a discounted price!
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
Yes! You will receive a Completion Certificate at the end of each course.
You can cancel at any time within the first 30 days and receive a full refund.
Plus, you get to keep all our downloadable course Cheat Sheets and Workbooks!