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 is ideal for you if you’re looking to learn Advanced Features of MS Excel.
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.
MoreMicrosoft 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
What Successful Students Are Saying
Scott Lee
Stacy Scott
Wayne Smith
Stacy Scott
300,000+ professionals enrolled from 100+ organizations including these reputable organizations
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 Advanced 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?
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
In-person, virtual, and hybrid group training formats are available for this program.
For group and corporate training solutions, please
Monthly
$57
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
$117
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
$177
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%
Master of Project Academy Featured In The Media
Forbes
Wall Street Journal
Capterra
Project-Management.com
ThoughtCo.
Yahoo Finance
Frequently Asked Questions
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.
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.
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.
Read more about Master of Project Academy Instructors.
