Introduction to Excel Spreadsheets Course ( 3 Courses ) See Dates/Register  

Excel Basics

• Introducing the Ribbons
• Workbooks, Worksheets, Rows, Columns, Cells
• Selection Techniques & Mouse Shapes
• Saving, File Types, Compatability
• The File Tab
• Page Layout View
• Getting Help
• Inserting Files

Entering, Selecting & Editing Data

• Entering, Editing, Deleting Data in Cells
• Using the Fill Handle
• Inserting/Deleting Rows, Columns & Cells
• Insert/Deleting/Moving/Renaming/Copying Sheets
• Creating Custom Lists

Creating Formulas and Functions

• Creating/Editing/Copying Formulas
• Using AutoSum
• Common Basic Functions
• Using the Formula Tab
• Relative and Absolute Cell References

Formatting Cells, Rows, Columns & Sheets

• Formatting Cells Options
• Applying Borders and Shading
• Changing Column Widths
• Changing Row Heights
• Clearing Formats
• Using Format Painter

Charts, Graphs and Data Sort

• Create Simple Charts
• Editing Charts
• Formatting Charts
• Sorting Data
• Auto Filter

Printing

• Print Preview & Page Orientation
• Adding Headers and Footers
• Printing a Selection & Setting a Print Area
• Adjusting Page Breaks using Page Break Preview
• Changing Margins
• Centre on Page