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


  Tip #1 - Join LinkedIn Community
Available in days
days after you enroll
  • Start
    Join LinkedIn Community & Follow Latest Updates
  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

We can send you full course catalog


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 125,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?
Your expert instructor is Cindy McGuckin, who has over 15 years of instructing and industry experience.

Read more about Cindy in her Instructor Bio below.

Meet Your Instructor


Cindy McGuckin
Cindy McGuckin

Cindy McGuckin is ACHE (Association for Continuing Higher Education) Instructor of the Year for the entire Southeast region.

Cindy is teaching software classes for more than 15 years. She has middle-level management experience in educational institutions.

Cindy is a qualified Microsoft Excel instructor.


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


For corporate training solutions please email us

Monthly

$27

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

Annual

$67

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

Lifetime

$97

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

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