Rating 4.4 out of 5 (21 ratings in Udemy)
What you'll 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 …
Rating 4.4 out of 5 (21 ratings in Udemy)
What you'll 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
DescriptionPropel 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…
