Microsoft Excel Course Plan:

 

4hrs

• Purpose of Excel

• Navigate and Select Cells in Worksheets 

• Create a Basic Worksheet 

• Inputting data

• Fixed-Width Fonts

• Inserting, Renaming, Deleting Rows and Columns 

 

• Add Borders and Colours to Cells 

• Change column width and row height

• Merge Cells and Wrap Text

• Apply Number Formatting 

• Apply Font Properties 

 

• Edit Worksheet Data 

• Find and Replace Data 

• Autofill Data

• Data Segregation using Text to Column

• Working with Lists - Sorting and Filtering (> versus >=, <  versus <=, AND versus OR).

• Sort and Filter by Color

• Deleting Every Other Row

 

4hrs

• Create Formulas in a Worksheet 

• Understand commonly used Functions like SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, ROUND, ROUNDUP, ROUNDDOWN.

• Insert Functions in a Worksheet 

• Reuse Formulas

• Create Formulas using $ sign 

• IF, SUMIF and COUNTIF

• Insert Text to Column

• Transposing Data 

 

• Inserting Header and Footer 

• Align Content in a Cell 

• Apply Page Break, Split and Freeze Panes

 

• Creating 2D and 3D Charts

• Showing Data Labels, Legend, Titles, Format

• Moving and copying Worksheet 

• Inserting, Renaming, Deleting, Hiding Worksheet 

• Save and Print a Worksheet