Introduction
  • Microsoft Excel Introduction
Microsoft Excel Fundamentals
  • Launching Excel
  • Introduction to the Excel interface
  • Saving Excel File
  • Important File Types
  • Opening an existing excel document
  • Adding, Modifying and deleting data in cells
  • Creating and naming of new worksheet
  • Common Excel Short Cut Keys
Editing Text and Formulas
  • Add / Subtract/ Multiply / Divide
  • Use of Cut & Paste using Cells
Modify of Excel Worksheet
  • Moving and Copying Data in an Excel Worksheet
  • Inserting Rows and Columns
  • Deleting an Excel Worksheet
Introduction to Charts
  • The easy way of creating chart
Important charts and Best Practices
  • Bar and Column Chart
  • Formatting Charts
  • Line Charts
  • Area Charts
  • Pie and Doughnut Charts
  • Scatter or Bubble Chart
Printing an excel Worksheet
  • Viewing your Document in Print Preview
  • Working with Page Layout View
  • Printing a Specific Range of Cells
PIVOT Tables from Basic To Pro
  • Lets Jump into this
  • Some More on Pivot tables
  • Common Mistake - Mistake 1
  • Auto Refresh and Common Mistakes - Mistake 2
  • About Number Format - All At Once
  • Use of FIlters and Column box
  • Removing Grand Totals
  • Extract of report details in to separate table
  • Adding Percentage summary
  • Displaying null rows
  • Best Top 10 option and Sorting
  • Some More features part - 1
  • Playing with dates - Grouping and Ungrouping
  • More features - part - 2
  • Bonus Lesson