Microsoft Excel® Training - 8 Hours Online MS Excel Course

8+ Hours Microsoft Excel Training. 100+ Lectures, Foundations of MS Excel, Formatting, Charts, Pivot Tables, Formulas, Lookups and more.

Your 100% online, self-paced Microsoft Excel® Training includes:

-8+ hours of Microsoft Excel® Training designed by industry experts
–Learn at your own pace whenever and wherever you want, even if you work full-time
-Learn how to use and create a Workbooks, Charts, Formulas, Formatting and more in MS Excel from the ground
-Sample step-by-step lectures on how to use Excel from scratch
-Learn functions, lookups, pivot tables, sorting, filtering and more


"Master of Project Academy allows professionals to advance their training at a schedule that fits their busy life. No set dates, no set number of hours. No need to take time off to accommodate a course schedule in a physical classroom. And with 24 hour assistance, professionals have access to help whenever they need it."

Microsoft Excel Training

Microsoft Excel Training is ideal for you if you’re looking to learn MS Excel from the ground.

See Pricing


100+ Lectures


8+ Hours


Lifetime Access option


30 day money back guarantee!


100% Online & Self-Paced


Course Completion Certificate


  • Enroll in a Microsoft Appreciated Training
  • Learn how to create workbooks, working with rows, columns and cells in MS Excel step-by-step
  • Learn entering text, numbers and working with dates
  • See how you can do formatting in Excel, including formatting cells and numbers in MS Excel
  • Learn how to create charts and graphs, sorting and filtering
  • Introduction to PivotTables, Logical and Lookup formulas
  • Start from scratch and learn the fundamentals of Microsoft Excel
  • Get prompt answers & support from the instructor within 24 hours!
  • Test yourself with quizzes at the end of the sections
  • Earn 10 PDUs if you are a PMP already
  • Get downloadable handouts and materials during the course

Microsoft Excel is used by hundreds of millions of people around the world. Students, Accountants, Engineers, Managers, Architects, Doctors and many other professions are using MS Excel as their primary tool for keeping, organizing, analyzing and managing records and data.

This training is most suited for:

  • Students
  • Engineers
  • Project Managers
  • Accountants
  • Anyone using Microsoft Excel®
  • Anyone who wants to learn how to use MS Excel®

What is Microsoft Excel®?

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Microsoft Excel is used by several small to large organizations as the primary tool for keeping, analyzing, and managing data. Learning how to use Microsoft Excel will earn you a must-to-have skill in today's competitive world.

What is in this Microsoft Excel Training Program?

Microsoft Excel course program includes 20 different sections.

Microsoft Excel Training Section #1 includes...

Introduction to MS Excel. You will see a brief introduction about the MS Excel course, what's new in Excel 2019, course overview, overview of the Excel window, mouse features and back stage view.

Microsoft Excel Course Section #2 includes...

Creating Workbooks. You will learn creating basic formulas, relative references, order of operations and working with ranges.

MS Excel Training Section #3 includes...

Saving Workbooks. You will see working with the save and save as commands, file extensions, share, export and publish features.

MS Excel Course Section #4 includes...

Navigating workbooks. You will learn opening a file, working with larger files, freeze panes option, and split screen option.

Microsoft Excel Training Section #5 covers...

Page setup and print options. You will see headers and footers, print titles, comments, page setup options, fit-to-print-on-one-page and printing workbooks.

Microsoft Excel Course Section #6 covers...

Working with rows, columns and cells. You will learn adding and deleting rows, columns and cells. Besides, you will see changing column and row widths.

Microsoft Excel Training Section #7 includes...

Moving data. You will learn cut, copy and paste features as well as copying formulas.

Microsoft Excel Course Section #8 includes...

Formulas and functions. You will learn how to create formulas using functions and absolute values features.

MS Excel Training Section #9 includes...

Working with Sheets. You will see how to add and rename sheets, additional sheet tab options and dimensional formulas.

MS Excel Training Section #10 includes...

Formatting worksheets. You will learn formatting cells, formatting numbers, borders and shading, formatting as table, using styles, using format painter, protecting sheets, fill handle and custom lists.

Microsoft Excel Course Section #11 covers...

Charts.You will see how to create charts, editing charts, using graphics to enhance charts, and linking chart titles.

Microsoft Excel Training Section #12 includes...

Working with Names. You will learn creating range names, managing names, and using names in formulas.

MS Excel Course Section #13 covers...

Sorting and Filtering. You will see how to remove duplicates, sort data, filter data, and advanced filters.

Microsoft Excel Course Section #14 covers...

Outlining and Subtotaling. You will learn creating an outline and subtotals.

MS Excel Training Section #15 includes...

Working with Views. You will see arranging files, new window option and custom views.

MS Excel Course Section #16 includes...

Linking Files. You will learn creating formulas between files, working with links and consolidating data.

MS Excel Training Section #17 includes...

Advanced Formula Creation. You will see if statements, VLookup function, data validation, and formula auditing.

Microsoft Excel Course Section #18 includes...

Pivot Tables. You will learn the pivot tables and pivot charts.

Microsoft Excel Training Section #19 includes...

Additional Excel Features. You will see slicers, goal seeker, text to columns, watch window and customizing ribbons and tabs features.

MS Excel Course Section #20 includes...

Shortcuts. You will learn Excel shortcuts that every user should know.

Do I need Microsoft Excel Program?

Our Microsoft Excel Course is 100% online and self-paced. Lectures do not require you to have a MS Excel on your PC. However, we recommend you to practice what you learned during the MS Excel Training. Therefore, we advise you to obtain a MS Excel license and try to apply what you learn throughout the MS Excel course.


Earn Microsoft Excel® Course Completion Certificate


Curriculum


  Chapter 1: Introduction
Available in days
days after you enroll
  Tip #1 - Join LinkedIn Community & Check out MoPA Blog
Available in days
days after you enroll
  • Start
    Join LinkedIn Community & Follow Latest Updates
  • Start
    Supercharge your Project Game with FREE tips and insights on becoming a project management pro with our Blog. (0:25)
  Chapter 2: Creating Workbooks
Available in days
days after you enroll
  • Start
    Entering Text and Numbers (4:31)
  • Start
    Creating Basic Formulas (6:49)
  • Start
    Relative References (3:01)
  • Start
    Order of Operations (4:48)
  • Start
    Working with Ranges (4:14)
  • Start
    Chapter 2 - Practice Exercise (1:35)
  Chapter 3: Saving Workbooks
Available in days
days after you enroll
  • Start
    Working with the Save and Save As Commands (4:34)
  • Start
    New Lecture (3:44)
  • Start
    Chapter 3 - Practice Exercise (0:58)
  Chapter 4: Navigating Workbooks
Available in days
days after you enroll
  • Start
    Opening a File (5:32)
  • Start
    Working with Larger Files (5:34)
  • Start
    Freeze Panes Option (3:16)
  • Start
    Split Screen Option (3:21)
  • Start
    Chapter 4 - Practice Exercise (2:49)
  Chapter 5: Page Setup & Print Options
Available in days
days after you enroll
  • Start
    Headers and Footers (7:23)
  • Start
    Print Titles (2:52)
  • Start
    Comments (5:23)
  • Start
    Page Setup Options (7:29)
  • Start
    Fit to Print on One Page (3:58)
  • Start
    Printing Workbooks (3:55)
  • Start
    Chapter 5 - Practice Exercise (1:53)
  Chapter 6: Working with Rows, Columns and Cells
Available in days
days after you enroll
  • Start
    Adding and deleting rows columns and cells (6:12)
  • Start
    Changing Column and-Row Widths (3:45)
  • Start
    Chapter 6 - Practice Exercise (1:11)
  Chapter 7: Moving Data
Available in days
days after you enroll
  • Start
    Cut Copy and Paste (7:07)
  • Start
    Copying Formulas (5:09)
  • Start
    Chapter 7 - Practice Exercise (1:20)
  Chapter 8: Formulas & Functions
Available in days
days after you enroll
  • Start
    Overview of Formulas (2:47)
  • Start
    Create Formulas Using Functions part1 (10:03)
  • Start
    Create Formulas Using Functions part-2 (5:24)
  • Start
    Absolute Values (5:16)
  • Start
    Chapter 8 - Practice Exercise (1:20)
  Chapter 9: Working with Sheets
Available in days
days after you enroll
  • Start
    Adding Deleting and Renaming Sheets (4:09)
  • Start
    Additional Sheet Tab Options (5:19)
  • Start
    3 Dimensional Formulas (5:28)
  • Start
    Chapter 9 - Practice Exercise (1:31)
  Chapter 10: Formatting Worksheets
Available in days
days after you enroll
  • Start
    Formatting Cells part 1 (10:04)
  • Start
    Formatting Cells part 2 (3:38)
  • Start
    Formatting Numbers (9:24)
  • Start
    Borders and Shading (7:08)
  • Start
    Format as Table (6:07)
  • Start
    Using Styles (3:49)
  • Start
    Using Format Painter (4:29)
  • Start
    Protecting Sheets (9:00)
  • Start
    Fill Handle and Custom Lists (7:17)
  • Start
    Chapter 10 - Practice Exercise (1:10)
  Chapter 11: Charts
Available in days
days after you enroll
  • Start
    Creating Charts (9:48)
  • Start
    Types of Charts (5:58)
  • Start
    Editing Charts Part 1 (11:00)
  • Start
    Editing Charts Part 2 (3:16)
  • Start
    Using Graphics to Enhance Charts (5:05)
  • Start
    Linking Chart Titles (2:51)
  • Start
    Chapter 11 - Practice Exercise (0:53)
  Chapter 12: Working with Names
Available in days
days after you enroll
  • Start
    Creating Range Names (0:35)
  • Start
    Managing Names (3:17)
  • Start
    Using Names in Formulas (5:58)
  • Start
    Chapter 12 - Practice Exercise (1:20)
  Chapter 13: Sorting and Filtering
Available in days
days after you enroll
  • Start
    Remove Duplicates (7:45)
  • Start
    Sort Data (10:28)
  • Start
    Filter Data (7:38)
  • Start
    Advanced Filters (4:46)
  • Start
    Chapter 13 - Practice Exercise (0:57)
  Chapter 14: Outlining and Subtotaling
Available in days
days after you enroll
  • Start
    Creating an Outline (6:01)
  • Start
    Subtotals (8:00)
  • Start
    Chapter 14 - Practice Exercise (1:07)
  Chapter 15: Working with Views
Available in days
days after you enroll
  • Start
    Arranging Files (3:14)
  • Start
    New Window Option (2:45)
  • Start
    Custom Views (5:32)
  • Start
    Chapter 15 - Practice Exercise (1:07)
  Chapter 16: Linking Files
Available in days
days after you enroll
  • Start
    Creating Formulas Between Files (6:35)
  • Start
    Working with Links (4:01)
  • Start
    Consolidating Data (5:16)
  • Start
    Chapter 16 - Practice Exercise (1:30)
  Chapter 17: Advanced Formula Creation
Available in days
days after you enroll
  • Start
    If Statements (7:49)
  • Start
    VLookups (7:39)
  • Start
    Data Validation (8:13)
  • Start
    Formula Auditing (5:29)
  • Start
    Chapter 17 - Practice Exercise (1:19)
  Chapter 18: Pivot Tables
Available in days
days after you enroll
  • Start
    Pivot Tables (9:36)
  • Start
    Pivot Charts (3:16)
  • Start
    Chapter 18 - Practice Exercise (0:56)
  Chapter 19: Additional Excel Features
Available in days
days after you enroll
  • Start
    Slicers (4:39)
  • Start
    Goal Seeker (2:56)
  • Start
    Text to Columns (2:50)
  • Start
    Watch Window (2:32)
  • Start
    Customizing Ribbons and Tabs (3:25)
  • Start
    Chapter 19 - Practice Exercise (1:23)
  Chapter 20: Shortcuts
Available in days
days after you enroll
  • Start
    Excel Shortcuts That Every User Should Know (12:00)
  Chapter 21: Closing
Available in days
days after you enroll
  • Start
    Closing Video (0:37)
  End of Course Quiz
Available in days
days after you enroll
  • Start
    End of Course Quiz
  How to Submit a PDU Claim (For Retaining PMP Certificate)
Available in days
days after you enroll
  • Start
    How to Submit PDUs
  Bonus Lecture - Discount for our paid courses
Available in days
days after you enroll
  • Start
    Bonus Lecture - Discount for our paid courses
  Important Notice About Certificate of Completion
Available in days
days after you enroll
  • Start
    Important Notice About Certificate of Completion

What Successful Students Are Saying

Microsoft Excel Training

Charlotte Rodriguez

Microsoft Excel Course

Victor Jacobs

MS Excel Training

Alice Newman

MS Excel Course

Victor Jacobs

"I am working as a Technical Project Manager in a Construction Company. We keep all project data in MS Excel. This Microsoft Excel Training helped me to understand the basics of MS Excel and how to manage and analyze data in Excel."

"I am a senior undergrad student at North Carolina State University. I had to work with several mathematical research data to complete my thesis. Without this MS Excel course's help, I could not succeed. Thanks!"

"I have a secondary degree and I could not secure a job until I learn MS Excel. It was like a prerequisite in all of my applications. I attended this MS Excel course, got my certificate and now, I am working as a Customer Support Rep and Front Desk in a car dealer!"

"I am a senior undergrad student at North Carolina State University. I had to work with several mathematical research data to complete my thesis. Without this MS Excel course's help, I could not succeed. Thanks!"

300,000+ professionals enrolled from 100+ organizations including these reputable organizations


Master of Project Academy Clients



Master of Project Academy is an Accredited Business by Better Business Bureau®


What does this mean? This means all figures, claims, and reviews of Master of Project Academy are audited and backed up. BBB® reviews the pass rate, student reviews, and all claims of our website, and make sure that they are genuine, authentic and made by real students enrolled in our courses.



You can see several authentic and genuine reviews on our BBB, Google, and TrustPilot Pages.

Microsoft Excel Training is brought to you by Master of Project Academy.
So far we’ve helped over 300,000 professionals from 180 countries to advance their career.

Will you be our next success story?


Enroll Now

Everything you need to train for Microsoft Excel®

Ready to get serious about learning MS Excel? Your new career opportunities depend on it.
Enroll today and give yourself the best chance to create the best in Excel…
100% online training, learn at your own pace from wherever you want


In-person, virtual, and hybrid group training formats are available for this program.

For group and corporate training solutions, please

Request a Quote

Monthly

$47

per month

Benefits of a monthly subscription:

The faster you complete the course, the less you pay

Get continuous access to the course - auto-billing means no manual payment hassles.
Cancel anytime

Enroll

Annual

$97

1-year duration

Benefits of an annual subscription:

Learn at your own pace - take your time to complete the training and fully prepare for the certification exam

Revisit key lectures and highlights to give yourself the best chance of passing

Enroll

Lifetime

$147

lifetime access

Benefits of lifetime course access:

Pay once, get forever access to course materials and all future updates at no additional cost

Revisit key lectures and highlights to give yourself the best chance of passing

Enroll

30 Day Money Back Guarantee - Our Overall Full Refund Rate is < 1%

Master of Project Academy Featured In The Media

online pmp certification training

Forbes

online pmp certification training

Wall Street Journal

online pmp training

Capterra

PMP online course

Project-Management.com

online PMP training

ThoughtCo.

PMP training online

Yahoo Finance

"Master of Project Academy’s free PMP training course is 100% online and self-paced, containing three sections of learning material. The course includes over 25 lectures, plus an assortment of resources for those wanting more information."

"Master of Project Academy offers the best solution, with flexible online courses at a fraction of the cost of other certification training courses. Courses can be taken from anywhere, anytime, with just an Internet connection."

"Master of Project Academy courses cover everything you need in a direct, accessible manner. All the reviews of Master of Project Academy are overwhelmingly positive. Students call out their favorite teachers and rave about how easy passing the exam is following Master of Project Academy’s instruction."

"Master of Project Academy delivers 100% online, self-paced and 30-day money back guaranteed on certification courses. High quality premium certification courses are offered at low prices in comparison to other certification institutions."

"Master of Project Academy has a surprising pass rate of 99.6 percent; more than 125,000 of its students have passed the certification. But if that figure still doesn’t inspire total confidence in you, rest easy knowing that the program offers all of its students a money-back guarantee."

"Courses are offered to students and professionals worldwide who seek to expand their knowledge base or need help preparing for a variety of professional certification exams. Courses are self-paced and conducted entirely online, with access to 24 hour support."

Frequently Asked Questions


When does the course start and finish?
Master of Project Academy courses are designed to be flexible and affordable, so you can learn how you choose.

You can begin the course from the moment you enroll. Get instant access to all the lectures, videos and materials and train for certification at your own pace.

There’s no deadline to complete the course – you can watch and re­‐watch as many times as you like, giving yourself the best chance at passing your certification exam at the first attempt.
What if I am unhappy with the course?
All our courses come with a full 30-­day guarantee for your protection. Our overall refund rate is less than 1% from 300,000+ students who have used our course to train for Microsoft Excel.

But if for any reason you decide to cancel, just email [email protected] within 30 days of enrollment, and we’ll refund your payment in full.
Any further questions?
We’re happy to answer them! Please visit our FAQ page for more details or email [email protected].
How long can I access the course for?
For however long you need it. You can choose from monthly access, one‐year access or lifetime access below. If you select monthly access you will be auto-­billed on the same day each month, and can access the full course at any time until you cancel.

If you want to take longer to study the course, you can select annual or lifetime access to give yourself more time to watch and re-­‐ watch the lectures. Lifetime access is exactly that – you will never lose access and will receive free course content updates forever.
Who teaches the course?
Master of Project Academy instructors has several years of experience in their fields and each has major industry experience including but not limited to IT, banking, telecommunications, consultancy, non-profit organizations, military, energy, and more.

Read more about Master of Project Academy Instructors.

Other Courses You Might Be Interested In



Microsoft Excel® Training (Foundation & Advanced) Bundle
Our Online Microsoft Excel® Training Bundle helps you to learn MS Excel from the ground and helps you become a Pro – even if you’re working full­‐time
2 Course Bundle
$77/mo
Free Microsoft Excel® Training
Our online Free Microsoft Excel® training helps you learn the basics of MS Excel, provide free MS Excel study materials, tips & tricks and more.
FREE

Company

Engage with Us

Contact Us

For any kind of queries please email us.