Excel Fundamentals
Fundmentals of data analysis using Excel
Analyzing Data:
Sort and Filter Data
Conditional Formatting
Excel Functions
Create Functions
IF() and SWITCH()
IF() and IFS()
SUMPRODUCT()
LET()
Name Manager
LAMBDA()
Transforming Data:
Import and Duplicate
Transform Text and Date Values
Fix Errors and NA values
Lookup Data
Excel Tables:
Excel Tables
Structured Referring
Calculated Columns
Power Query
Linked Data Table
Dynamic Arrays
Formulas
Functions
XLOOKU
Pivot Tables:
Summarizing Data
Update and Sort
Analyze
Design
Filtering with Slicers and Timeline
Pivot Charts
Data Visualization in Excel
Scatter Chart and Clustered Column Chart
Waterfall and Combo Chart
Bullet Chart
Excel Fundamentals - Case Study
Lookup Data
Conditional Formula
Conditional Formatting
SUMPRODUCT
Dynamic Arrays
Visualizing Data