Microsoft Excel Advanced: High Level Data Analysis Tools
NOW INCLUDES OUR PROFESSIONAL EXCEL COURSE: includes What-If, Pivot, HLOOKUPs, VLOOKUPs & Intros to Macros, VBA & UDFs
4.12 (578 reviews)
7,491
students
5.5 hours
content
Feb 2025
last update
$49.99
regular price
What you will learn
Our EXCEL ADVANCED course gives you a solid understanding of the advanced data analysis tools & concepts in Excel -- now includes our PROFESSIONAL level course!
The course has its own workbooks with separate practice exercises – download from the “Introduction” module – so can reinforce what you learn
You'll acquire an impressive array of advanced data analysis skills, including What-If Scenarios, PivotTables, HLOOKUPs, VLOOKUPs & Intros to Macros, VBA & UDFs
What-If Analysis - Exploring Scenarios - Goal Seek and Data Tables - Using Solver
Grouping & Outlining and Subtotals - Outlining and Grouping Data - Using the Subtotals Tool
PivotTables - Getting Started with PivotTables - Displaying Data in a PivotTable - Formatting a PivotTable - Using the Classic PivotTable Layout - Slicers
Charting Pivoted Data - Getting Started with PivotCharts - Using the PivotChart Tools Tabs - Formatting a PivotChart
Advanced Excel Tasks - Excel and Hyperlinks - Using Custom AutoFill Lists - Sharing Workbooks
HLOOKUP and VLOOKUP Functions - Using the VLOOKUP Function - Using the LOOKUP Function
Introduction to Macros in Excel - Recording and Playing Macros - Copying and Deleting Macros - Visual Basic and Macros
Advanced Conditional Formatting - Editing Standard Formatting Rules - Using Formulas in Conditional Formatting
Using Form Controls and Templates - Using Form Controls - Creating Templates
Advanced Lookup Functions - Using the Index and Match functions - Combining Index & Match Formulas
Advanced Functions - Using Error Functions - Using Logical and IF Functions - Using Array Formulas - Using Rounding Functions
Advanced Pivot Table Tools - Importing Data From External Sources - Calculated Fields & Items - Changing Display Of Pivot Values - Creating Custom Pivot Tables
Screenshots
Related Topics
2153106
udemy ID
1/15/2019
course created date
11/20/2019
course indexed date
Bot
course submited by