Microsoft Excel® Training Advanced - 9 Hours Online MS Excel Advanced Course

9+ Hours Microsoft Excel Advanced Course. 50+ Lectures, Advanced Features of MS Excel, Financial and Statistical Functions, Advanced Charts, Graphs and more.


 

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

-9+ 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 advanced and expert features of MS Excel
-Sample step-by-step guidance on real-life scenarios
-Learn how to create advanced and customized reports, financial and statistical functions, advanced charts, graphs, visualizations 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 Advanced Training

Microsoft Excel Advanced Training is ideal for you if you’re looking to learn Advanced Features of MS Excel.

See Pricing


50+ Lectures


9+ Hours


Lifetime Access option


30 day money back guarantee!


100% Online & Self-Paced


Course Completion Certificate


  • Enroll in Microsoft Excel Advanced Training and earn a competitive skill.
  • Learn how to use detailed formatting tools
  • See lookup and advanced lookup functions
  • How to use financial functions including calculating interest and depreciation
  • Learn how to use statistical functions
  • See connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
  • How to create awesome visualizations using sparklines and data bars
  • Mastery of Pivot Tables and Pivot Charts
  • Scenario Manager, Goal Seek, and Solver
  • Advanced charts such as Surface, Radar, Bubble and Stock Charts
  • 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
  • Finance Professionals
  • Accountants
  • Anyone using Microsoft Excel®
  • Anyone who wants to learn how to use MS Excel®

What is in this Advanced Microsoft Excel Training Program?

Microsoft Excel Advanced course program includes 15 different chapters.


Microsoft Excel Advanced Training Chapter #1: Introduction

You will learn the outline of the MS Excel Advanced course. You will see what to expect and restrictions. Instructor will introduce herself and you will familiarize yourself for the rest of the course.


Microsoft Excel Advanced Course Chapter #2: Functions

You will learn advanced features of functions. Functions are used to make mathematical calculations and analysis in Excel. You will see autosum feature as well.


Microsoft Excel Advanced Course Chapter #3: Date and Time Functions

You will see how date and time works in Microsoft Excel. You will be learning basic date and time functions. There will be a further lecture describing complex date and time functions as well.


Microsoft Excel Advanced Course Chapter #4: Text Functions

You will learn how to use text functions in MS Excel.


Microsoft Excel Advanced Course Chapter #5: Logical Functions

You will learn how to use logical functions.


Microsoft Excel Advanced Course Chapter #6: Lookup Functions

Lookup function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range. LOOKUP's default behavior makes it useful for solving certain problems in Excel. You will learn HLOOKUP and VLOOKUP functions.


Microsoft Excel Advanced Course Chapter #7: Financial Functions

The excel financial functions have been made available to execute a variety of financial calculations, including calculations of yield, investment valuations, interest rates, internal rate of return, asset depreciation, and payments. You will learn the financial functions and terminology. Besides, you will see Personal Financial Functions and Professional Financial Functionsfinancial functions in Microsoft Excel.


Microsoft Excel Advanced Course Chapter #8: Statistical Functions

Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells. Functions are more efficient than formulas when you are applying a mathematical process to a group of cells. You will learn how to use statistical functions in MS Excel.


Microsoft Excel Advanced Course Chapter #9: Connecting to External Data

You can fetch data from other resources to Microsoft Excel and use these data in calculations and functions. You will see

  • Connecting MS Excel to Other Workbooks
  • Connecting Micrsoft Excel to Access Databases
  • Connecting Excel to Web Data Sources

Besides, you will learn Get and Transform feature of MS Excel.


Microsoft Excel Advanced Training Chapter #10: Tables

Tables are one of the main components of MS Excel. You will see an introduction to tables. Besides, you will learn working with tables, table references and table styles.


Microsoft Excel Advanced Training Chapter #11: Pivot Tables

A pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns. It allows grouping by any data field. You will learn how to use, create and manage Pivot Tables in Microsoft Excel.


Microsoft Excel Advanced Course Chapter #12: Data Analysis

Data analysis is a process of inspecting, cleansing, transforming and modeling data with the goal of discovering useful information, informing conclusion and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, and is used in different business, science, and social science domains. You will learn

  • What If Analysis
  • Scenario Manager
  • Goal Seek
  • Solver


MS Excel Advanced Course Chapter #13: Graphs and Charts

A chart is a graphical representation of data, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart". A chart can represent tabular numeric data, functions or some kinds of qualitative structure and provides different info. You will learn:

  • Area Charts
  • Surface Charts
  • Radar Charts
  • Bubble Charts
  • Sparklines
  • Stock Charts


Microsoft Excel Advanced Training Chapter #14: Excel Web App

Excel for the web (formerly Excel Web App) extends your Microsoft Excel experience to the web browser, where you can work with workbooks directly on the website where the workbook is stored. All customers can view and lightly edit Office files using Office for the web. You will see an introduction to Excel Web App and how to use the Excel Web App


Microsoft Excel Advanced Training Chapter #15: Conclusion

We will summarize what we learned and close the Microsoft Excel Advanced Course.


Earn Microsoft Excel® Advanced Course Completion Certificate


Curriculum


  Chapter 2: Functions
Available in days
days after you enroll
  Tip #1 - Join LinkedIn Community
Available in days
days after you enroll
  • Start
    Join LinkedIn Community & Follow Latest Updates
  Chapter 3: Date and Time Functions
Available in days
days after you enroll
  • Start
    How Date and Time Works (9:59)
  • Start
    Basic Date and Time Functions (9:43)
  • Start
    Complex Date and Time Functions (10:38)
  • Start
    Quiz
  Chapter 4: Text Functions
Available in days
days after you enroll
  • Start
    Using Text Functions - Part 1 (10:12)
  • Start
    Using Text Functions - Part 2 (12:12)
  • Start
    Quiz
  Chapter 5: Logical Functions
Available in days
days after you enroll
  • Start
    Using Logical Functions (9:44)
  • Start
    Exercise 01 (1:58)
  • Start
    Quiz
  Chapter 6: Lookup Functions
Available in days
days after you enroll
  • Start
    HLOOKUP Function (14:02)
  • Start
    VLOOKUP Function (7:56)
  • Start
    Exercise 02 (5:37)
  • Start
    Quiz
  Chapter 7: Financial Functions
Available in days
days after you enroll
  • Start
    Financial Functions and Terminology (8:51)
  • Start
    Personal Financial Functions (9:18)
  • Start
    Professional Financial Functions (7:23)
  • Start
    Depreciation (5:04)
  • Start
    Exercise 03 (1:37)
  • Start
    Quiz
  Chapter 8: Statistical Functions
Available in days
days after you enroll
  • Start
    Statistical Functions for Description - Part 1 (13:31)
  • Start
    Statistical Functions for Description - Part 2 (13:43)
  • Start
    Statistical Functions for Forecasting - Part 1 (11:54)
  • Start
    Statistical Functions for Forecasting - Part 2 (11:45)
  • Start
    Exercise 04 (1:45)
  • Start
    One Click Forecasting (8:56)
  • Start
    Statistical Functions for Inference (11:09)
  • Start
    Quiz
  Chapter 9: Connecting to External Data
Available in days
days after you enroll
  • Start
    Connecting to Other Workbooks (13:12)
  • Start
    Connecting to Access Databases (12:50)
  • Start
    Connecting to Web Data Sources (7:52)
  • Start
    Get and Transform (14:37)
  • Start
    Exercise 05 (5:06)
  • Start
    Quiz
  Chapter 10: Tables
Available in days
days after you enroll
  • Start
    Introduction to Tables (12:13)
  • Start
    Working with Tables (10:40)
  • Start
    Table References (8:31)
  • Start
    Table Styles (5:33)
  • Start
    Exercise 06 (1:21)
  • Start
    Quiz
  Chapter 11: Pivot Tables
Available in days
days after you enroll
  • Start
    Introduction to Pivot Tables (9:50)
  • Start
    Working with Pivot Tables (12:43)
  • Start
    Filters and Slicers (12:25)
  • Start
    Pivot Charts (8:30)
  • Start
    Exercise 07 (2:28)
  • Start
    Quiz
  Chapter 12: Data Analysis
Available in days
days after you enroll
  • Start
    What If Analysis (10:15)
  • Start
    Scenario Manager (11:21)
  • Start
    Goal Seek (7:25)
  • Start
    Solver (12:00)
  • Start
    Exercise 08 (1:43)
  • Start
    Quiz
  Chapter 13: Graphs and Charts
Available in days
days after you enroll
  • Start
    Area Charts (6:40)
  • Start
    Surface Charts (4:40)
  • Start
    Radar Charts (5:21)
  • Start
    Bubble Charts (7:19)
  • Start
    Sparklines (9:33)
  • Start
    Stock Charts (9:06)
  • Start
    Exercise 09 (3:33)
  • Start
    Quiz
  Chapter 14: Excel Web App
Available in days
days after you enroll
  • Start
    Introduction to Excel Web App (10:07)
  • Start
    Using the Excel Web App (9:52)
  • Start
    Quiz
  Chapter 15: Course Conclusion
Available in days
days after you enroll
  • Start
    Closing Message (0:49)
  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 Deborah Ashby, who has over 20 years of instructing and industry experience.

Read more about Deborah in her Instructor Bio below.

Meet Your Instructor


Deborah Ashby
Deborah Ashby

Deborah Ashby is a 5 x TAP Accredited IT Trainer, specializing in the design, delivery and facilitation of Microsoft courses both online and in the classroom.

Deborah has over 11 years IT Training Experience and 24 years in the IT Industry. To date, she's trained over 10,000 people in the UK and oversees at companies such as HMRC, the Metropolitan Police, Parliament, SKY, Microsoft, Kew Gardens, Norton Rose Fulbright LLP.

Deborah is a qualified MOS Master for 2010, 2013 and 2016 editions of Microsoft Office and is COLF and TAP Accredited and a member of The British Learning Institute.


Everything you need to train for Microsoft Excel® - Advanced

Ready to get serious about advancing in 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

$37

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

$77

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

$107

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%