|
|
 Microsoft Excel 2010 Basics
Courseware Training Materials
Foundation
/ Intermediate level computer training materials for delivering training to your
students, staff or clients. A courseware site licence allows you to train
an unlimited number of people, at your training center using these teaching resources.
 Training Course Outlines
USING EXCEL 2010
-
Starting the Excel program
-
What is the Active Cell?
-
The Excel cell referencing system
-
Entering numbers and text
-
Default text and number alignment
-
Summing a column of numbers
-
Entering a date
-
Worksheets and Workbooks
-
Saving a workbook
-
Closing a workbook and exiting the Excel program
-
Creating a new workbook
-
Opening a workbook
-
Switching between workbooks
-
Saving a workbook using another name
-
Saving a workbook using a different file type
-
Getting help within Excel 2010
-
Searching for Help
-
The Help 'Table of Contents'
-
Printing a Help topic
-
Alt key help
SELECTION TECHNIQUES
-
Why are selection techniques important?
-
Selecting a cell
-
Selecting a range of connecting cells
-
Selecting a range of non-connecting cells
-
Selecting the entire worksheet
-
Selecting a row
-
Selecting a range of connecting rows
-
Selecting a range of non-connected rows
-
Selecting a column
-
Selecting a range of connecting columns
-
Selecting a range of non-connecting columns
-
Recommended techniques when creating or editing lists
MANIPULATING ROWS AND COLUMNS
-
Inserting rows into a worksheet
-
Inserting columns into a worksheet
-
Deleting rows within a worksheet
-
Deleting columns within a worksheet
-
Modifying column widths
-
Modifying column widths using 'drag and drop'
-
Automatically resizing the column width to fit contents
-
Modifying row heights
MANIPULATING CELLS AND CELL CONTENT
-
Copying a cell or range contents within a workbook
-
Deleting cell contents
-
Moving the contents of a cell or range within a workbook
-
Editing cell content
-
Undo and Redo
-
Copying data between worksheets (within the same workbook)
-
Moving data between worksheets (within the same workbook)
-
Moving data worksheets (in different workbooks)
-
Copying data between worksheets (in different workbooks)
-
AutoFill
-
Copying a data range using AutoFill
-
Sorting a cell range
-
Searching and replacing data
WORKSHEETS
-
Switching between worksheets
-
Renaming a worksheet
-
Recommended techniques with naming worksheets
-
Inserting a new worksheet
-
Deleting a worksheet
-
Copying a worksheet within a workbook
-
Moving a worksheet within a workbook
-
Copying or moving worksheets between workbooks
FONT FORMATTING
-
Font formatting options
-
Font type
-
Font size
-
Bold, italic, underline formatting
-
Cell border formatting
-
Formatting the background color
-
Formatting the font color
ALIGNMENT FORMATTING
-
Horizontally aligning contents in a cell range
- Centering a title over a cell range
-
Cell orientation
-
Text wrapping within a cell
-
Aligning cell contents vertically
-
Format Painter
NUMBER FORMATTING
-
Number formatting
-
Decimal point display
-
Applying and removing comma style formatting (to indicate thousands)
-
Currency symbol
-
Date styles
-
Percentages
-
Applying Percentage formatting to a cell or range
FREEZING ROW AND COLUMN TITLES
-
Freezing row and column titles
FORMULAS
-
Creating formulas
-
The easy way to create formulas
-
Copying formulas
-
Operators
-
Using operators in formulas
-
Formula error messages
-
Relative cell referencing within formulas
-
Absolute cell referencing within formulas
FUNCTIONS
-
What are functions?
-
Common functions
-
Sum function
-
Average function
-
Max function
-
Min function
-
Count function
-
The COUNTA function
-
The COUNTBLANK function
-
What are 'IF functions'?
-
Using the IF function
CHARTS
-
Inserting a column chart
-
Inserting a line chart
-
Inserting a bar chart
-
Inserting a pie chart
-
Resizing a chart
-
Deleting a chart
-
Chart title or labels
-
Changing the chart background color
-
Changing the column, bar, line or pie slice colors in a chart
-
Modifying the legend fill color
-
Changing the chart type
-
Modifying charts using the Layout tab
-
Copying and moving charts within a worksheet
-
Copying and moving charts between worksheets
-
Copying and moving charts between workbooks
CUSTOMIZING EXCEL
-
Modifying basic Excel options
- Minimizing the Ribbon
-
AutoCorrect options
SETUP & PRINTING ISSUES
-
Worksheet margins
-
Worksheet orientation
-
Worksheet page size
-
Headers and footers
-
Header and footer fields
-
Scaling your worksheet to fit a page(s)
-
Visually checking your calculations
-
Displaying gridlines when printing
-
Printing titles on every page when printing
-
Printing the Excel row and column headings
-
Spell checking
-
Previewing a worksheet
-
Viewing workbooks side by side
-
Zooming the view
-
Printing options
-
Setting the number of copies to print
-
Selecting a printer
-
Selecting individual worksheets or the entire workbook
-
Selecting which pages to print
-
Single or double sided printing
-
Collation options
-
Page orientation
-
Paper size
-
Margins
-
Scaling
-
Printing
|
Customisable
Courseware
