- Microsoft Excel Introduction
- 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
- Add / Subtract/ Multiply / Divide
- Use of Cut & Paste using Cells
- Moving and Copying Data in an Excel Worksheet
- Inserting Rows and Columns
- Deleting an Excel Worksheet
- The easy way of creating chart
- Bar and Column Chart
- Formatting Charts
- Line Charts
- Area Charts
- Pie and Doughnut Charts
- Scatter or Bubble Chart
- Viewing your Document in Print Preview
- Working with Page Layout View
- Printing a Specific Range of Cells
- 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