Microsoft Office Training Materials – Excel 2010 Foundation Training Manuals

Microsoft Excel 2010 Foundation Training Materials

Training Course Outline

 Using Excel 2010

•     The Excel Cell Referencing System
•     Entering Numbers and Text
•     Summing a Column of Numbers
•     Entering a Date
•     Worksheets and Workbooks
•     Saving a Workbook
•     Creating a New Workbook
•     Opening a Workbook
•     Switching between Workbooks
•     Help

Excel 2010 Selection Techniques

•     Selecting a Cell, cell range, row & column.

Manipulating Rows and Columns within Excel 2010

•     Inserting Rows & Columns
•     Deleting Rows& Columns
•     Column Widths
•     Row Heights

Manipulating Excel 2010 Cells and Cell Content

•     Copying a Cell or Range Contents
•     Deleting Cell Contents
•     Moving the Contents of a Cell or Range.
•     Editing Cell Content
•     Undo and Redo
•     AutoFill
•     Sorting
•     Searching and Replacing

Excel 2010 Worksheets

•     Renaming a Worksheet
•     Inserting a New Worksheet
•     Deleting a Worksheet
•     Copying and moving a Worksheet

Font Formatting

•     Font Type
•     Font Size
•     Bold, Italic, Underline
•     Cell Border Formatting
•     Background Colour
•     Font Colour

Alignment Formatting

•     Aligning cell contents
•     Centring a Title Over a Cell Range
•     Cell Orientation
•     Text Wrapping
•     Format Painter

Number Formatting

•     Decimal Point Display
•     Comma Style Formatting
•     Currency Symbol
•     Date Styles
•     Percentages

Freezing Row and Column Titles

•     Freezing Row and Column Titles

Formulas

•     Creating Formulas
•     Copying Formulas
•     Operators
•     Using Operators In Formulas
•     Formula Error Messages
•     Relative Cell Referencing
•     Absolute Cell Referencing

Functions

•     Sum Function
•     Average Function
•     Max Function
•     Min Function
•     Count Function
•     The Counta Function
•     The Countblank Function
•     Using the If Function

Charts

•     Inserting different chart types.
•     Resizing and deleting a Chart
•     Chart Title or Labels
•     Chart Background Colour
•     Column, Bar, Line or Pie Slice Colours
•     Copying and Moving Charts

Customising Excel

•     Modifying Excel Options
•     Minimising the Ribbon
•     Autocorrect Options