Microsoft Office Training Materials – Excel 2010 Foundation Training Manuals
Microsoft Office 365 Training Materials, plus Office 2013 & Windows 10 Manuals Free SamplesMicrosoft 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
Other Microsoft Office Training Materials
Word 2010 Foundation
Word 2010 Intermediate
Word 2010 Advanced
Excel 2010 Foundation
Excel 2010 Intermediate
Excel 2010 Advanced
Access 2010 Foundation
Access 2010 Intermediate
Access 2010 Advanced
Outlook 2010 Foundation
PowerPoint 2010 Foundation
PowerPoint 2010 Intermediate
PowerPoint 2010 Advanced