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 in multiple pages
• Repeating rows and columns for multiple pages
• Printing multiple worksheets

Simple Database Operation

• Sorting tables
• Filtering data with auto filter
• Referring data from other worksheets
• Create hyperlinks