MyPhatshala

Excel for Data Analysis

Still the most used data tool in every office.

Beginner4 modules16 lessonsFree · no sign-up
0 of 16 lessons published
View syllabus

Syllabus

01 BasicsWorking with sheets. 3 lessons
  1. 1.1Excel interface and data entryComing soon
  2. 1.2Cell references: relative and absoluteComing soon
  3. 1.3Formatting and conditional formattingComing soon
02 FormulasCalculations. 5 lessons
  1. 2.1Basic functions: SUM, AVERAGE, COUNTComing soon
  2. 2.2IF, AND, ORComing soon
  3. 2.3VLOOKUP, HLOOKUP and XLOOKUPComing soon
  4. 2.4INDEX and MATCHComing soon
  5. 2.5Text and date functionsComing soon
03 AnalysisMaking sense of data. 4 lessons
  1. 3.1Sorting and filteringComing soon
  2. 3.2Pivot tablesComing soon
  3. 3.3ChartsComing soon
  4. 3.4Data validationComing soon
04 AdvancedPower tools. 4 lessons
  1. 4.1Power QueryComing soon
  2. 4.2What-if analysisComing soon
  3. 4.3Dashboards in ExcelComing soon
  4. 4.4Macros basicsComing soon