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