Microsoft Excel

 

Getting Started with MS Excel

  • Excel rows and columns

  • Workbook & worksheet

  • Enter text and numbers in a cell

  • Edit text in a cell

  • Cell formatting

  • Font formatting

  • Merge cells

  • Save your work

 

Formulas and Functions

  • Entering formulas

  • Copying data and formulas

  • Using AutoSum

  • Understanding functions

  • Using simple aggregate functions (Sum, Count, Average, Min, Max)

  • Copying formulas

 

Editing Features

  • Using cut, copy, and paste operations

  • Using paste special with values

  • Selection techniques

  • Navigation techniques

 

Working with the Large Workbooks

  • Freezing and unfreezing panes

  • Splitting windows

  • Inserting page breaks for printing

 

Working with Charts

  • Creating charts using Chart Wizard

  • Creating different types of charts

  • Including titles and values in charts

  • Formatting of charts

 

Inserting Graphic Objects

  • Insert and modify pictures and clipart

  • Draw and modify shapes

  • Illustrate workflow using SmartArt Graphics

 

Previewing and Printing

  • Previewing worksheets

  • Page setup

  • Printing of worksheets on multiple pages

  • Repeating rows and columns for multiple pages

  • Printing multiple worksheets

 

Simple Database Operation

  • Sorting tables

  • Filtering data with auto filter

  • Referring to data from other worksheets

    • Create hyperlinks

  • Analyzing Data Using Pivot Tables and Pivot Charts

    • Create a pivot table report

    • Analyze data using pivot charts