Introduction
  • Introduction of Excel Basic of Microsoft Excel Free Excel
  • Who should learn Microsoft excel Benefits of learning excel
  • Where to find excel How to open Excel What is Excel and How to use it
  • Introduction to Microsoft Excel Interface
Understanding Basic Excel
  • How to customize ribbon in excel customize excel
  • How to Save and Open Microsoft excel file
  • Data entry in Microsoft excel
  • How to Use Quick Access Toolbar in excel
  • CELL formatting options in Excel
Formulas in Excel
  • Basic formulas in excel Basic mathematical calculation in excel
  • Cell reference in excel Excel Cell Reference Absolute, Relative or Mixed Excel
  • How to use basic excel functions LIKE SUM,AVERAGE,MIN and MAX
  • Data Sorting in Excel How to Sort data in excel
  • How to FIlter Your data in excel
  • Data Validation in Excel
  • Advance Data Validation in Excel
  • How to Dynamic Data Validation
Charting in Excel
  • How to insert chart in excel
  • Modifying the Data and Type of a Chart -Changing Chart type in excel
  • How to change chart style in excel
  • Formatting Charts in Excel
Advance Excel Formulas and Functions
  • COUNTIF & COUNTIFS Function in Excel
  • SUMIF and SUMIFS function in Excel
  • AVERAGE function in Excel
  • SUBTOTAL function in excel
  • How to use IF and IFS in Excel
Text Functions in Excel
  • UPPER,LOWER and PROPER function in Excel
  • LEFT and RIGHT function in Excel