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