Advanced Excel: Data Analysis and Visualization Techniques
Use advanced formulas, functions, charts, pivot tables, macros, and more to create powerful and efficient spreadsheets
3.88 (4 reviews)
19
students
7 hours
content
Sep 2023
last update
$19.99
regular price
What you will learn
Advanced Excel Course. Apply data validation, conditional formatting, and advanced filtering techniques to manage and analyze data.
Understand how Power Pivot works, create relationships between data sets
Use the What IF analysis tools, Goal Seek, Scenario Manager, Data Tables and Solver
Create and modify pivot tables and pivot charts to summarize and visualize data.
Create multi-level data validation lists
Use formulas and functions such as VLOOKUP, INDEX, MATCH, IF, and SUMIFS to perform complex calculations and data analysis.
Record and edit macros to automate repetitive tasks and customize the Excel interface.
Create date related rolling averages and totals
Screenshots
Related Topics
3571247
udemy ID
10/15/2020
course created date
10/23/2020
course indexed date
Bot
course submited by