• Workbooks and Worksheets
• Columns, rows and Cells 
• Selecting a Cell
• Fill Handle 
• Adding and Renaming Worksheets in a Workbook. 
• The Standard Toolbar 
• Formatting toolbar
• Formula bar

 

• Moving Through Cells 
• Selecting Cells
• Resizing Rows and Columns
• Deleting Rows, Columns or Cells 
• Cutting, Copying and Pasting Cells 
• Clear Rows, Columns or Cells 
• Paste Special 

 

• Format Cells Dialog Box 
• Number tab 
• Alignment tab 
• Font tab
• Border 
• Pattern tabs 
• Protection Tab 
• Formatting Toolbar 

Formulas and Functions

• Formulas 
• Relative Functions
• Absolute Functions.
• Mixed referencing 
• Basic Functions
• Math and Trig
• Statistical
• Logical
• Conditional Formatting.
• Goal Seek 

 

• Basic Ascending and Descending sorts 
• Complex Sorts 
• Fill Down and Fill Right 
• Autofill
• Autofilling Functions

 

• Adding Clip Art
• Add An Image from a File
• Drawing in EXCEL 
• Lines, Rectangles 
• Text Box
• Autoshapes 
• Lines 
• Word Art
• Drawing Dialog Box

Charts

• The Chart Wizard
• Chart Types
• Chart Source Data; Data Series
• Chart Options
• Gridline formats
• Y-axis formats and scale
• X-axis formats and scale
• Trendlines
• Chart locations
• Copy a chart to Microsoft Word 

Page Properties and Printing

• Page Breaks 
• Page Setup 
• Page Tab 
• Margins Tab 
• Sheet Tab 
• Print Preview
• Print
• Printer 
• Print Range 
• Print What 
• Copies