Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 45 Minute(s)
Language
English
Taught by
Kirt Kershaw
Rating
Course Overview
Become an Excel Expert by Mastering Advanced Excel Functions, Power View, Power Pivot, 3D Map and More!
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…
Course Content
- 1 section(s)
- 48 lecture(s)
- Section 1 Workbook Properties Introduction
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
Skills covered in this course
Reviews
-
JJacob Prichard
Great class. Learned a lot.
