When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel Level 3 - Advanced Excel
Become an Excel Expert by Mastering Advanced Excel Functions, Power View, Power Pivot, 3D Map and More!
This Course Includes
udemy
4.4 (27 reviews )
4h 45m 
english
Online - Self Paced
professional certificate
Udemy
About Microsoft Excel Level 3 - Advanced Excel
Propel Your Microsoft Excel Skills to an Advanced Level
Take your Microsoft Excel skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Excel at an advanced level. You will learn how to work with additional Excel features including: macros, advanced conditional formatting, digital signatures, power view and consolidating data. Using my
18+ years of Microsoft Excel training
and Certification
I will guide you through these advanced Excel features and become an Excel Expert. Below are just a few of the topics that you will master:
Advanced Conditional Formatting using functions, or formulas
Get more accurate data entry using Data Validation
View another part of your worksheet simultaneously with Watch Window
Easily manage various levels of data in a hierarchical structure using Group and Outline
Summarize larges amounts of data using Excel’s Consolidating Data feature
Set criteria to color, add text and, or symbols to your cells with Advanced Custom Number Formats
and much, much, more…
What You Will Learn?
- Create Custom Database Views .
- Eliminate repetitive tasks instantly using Macros .
- Create many scenarios with varying groups of data .
- Password protect cells and workbooks .
- Share your Excel files and access anywhere there’s internet with Microsoft’s OneDrive .
- Track any changes made and accept or reject those changes .
- Control any argument of function to get the results you want using Goal Seek .
- More tips, tricks and shortcuts by a Multi-Certified Microsoft Trainer with over 17 years of Excel training.