Basic Excel Course
  • Creating a Loan Calculator-1
  • Creating a Loan Calculator-2
  • Creating a Loan Calculator-3
  • Function Basics
  • Logical Functions
  • Mathematical Functions
  • Lookup and Reference Functions
  • LOOKUP, VLOOKUP, and HLOOKUP Functions
  • Introduction to Advanced charts
  • Line chart
  • Column chart
  • Pie chart
  • Area Chart
  • Converting area chart into line chart
  • What is regression analysis ?
  • What are chart templates
  • What are sparklines
  • Sparklines vs charts
  • Data in hidden rows and columns
  • Introduction to Pivot chart and tables
  • Creating pivot charts
  • Creating pivot table
  • Multiple fields in row, column or data section
  • Creating pivot charts
  • Creating and using calculated fields