Programs

Course Content

A FIRST LOOK AT EXCEL 2010

1. Starting the Excel program
2. What is the Active Cell?
3. The Excel cell referencing system
4. Entering numbers and text
5. Default text and number alignment
6. Summing a column of numbers
7. Entering a date
8. Worksheets and Workbooks
9. Saving a workbook
10. Closing a workbook
11. Creating a new workbook
12. Opening a workbook
13. Switching between workbooks
14. Saving a workbook using another name
15. Saving a workbook using a different file type

HELP

1. Getting help
2. Searching for Help
3. The Help 'Table of Contents'
4. Printing a Help topic
5. Alt key help

USING EXCEL 2016

1. SELECTION TECHNIQUES
2. Why are selection techniques important?
3. Selecting a cell
4. Selecting a range of connecting cells
5. Selecting a range of non-connecting cells
6. Selecting the entire worksheet
7. Selecting a row
8. Selecting a range of connecting rows
9. Selecting a range of non-connected rows
10. Selecting a column
11. Selecting a range of connecting columns
12. Selecting a range of non-connecting columns

WORKSHEETS

1. Switching between worksheets
2. Renaming a worksheet
3. Good practice with naming worksheets
4. Inserting a new worksheet
5. Deleting a worksheet
6. Copying a worksheet within a workbook
7. Moving a worksheet within a workbook
8. Copying or moving worksheets between workbooks

FORMATTING

1. FONT FORMAT
2. Font type
3. Font size
4. Bold, italic, underline formatting
5. Cell border formatting
6. Formatting the background color
7. Formatting the font color
8. ALIGNMENT FORMATTING
9. Aligning contents in a cell range
10. Centering a title over a cell range
11. Cell orientation
12. Text wrapping
13. Aligning cell contents vertically
14. Format Painter
15. NUMBER FORMATTING
16. Number formatting
17. Decimal point display
18. Applying and removing comma style formatting (to indicate

thousands)

19. Currency symbol
20. Date styles
21. Percentages
22. Applying Percentage formatting to a cell or range

FREEZING ROW AND COLU

1. MN TITLES
2. Freezing row and column titles

FORMULAS AND FUNCTIONS

1. FORMULAS
2. Creating formulas
3. Good Practice: The easy way to create formulas
4. Copying formulas
5. Operators
6. Using operators in formulas
7. Formula error messages

RELATIVE &ABSOLUTE CELL REFERENCING

1. Relative cell referencing within formulas
2. Absolute cell referencing within formulas

FUNCTIONS

1. What is a function?
2. Common functions
3. Sum function
4. Average function
5. Max function
6. Min function
7. Count function
8. The COUNTA function
9. The COUNTBLANK function
10. The Round function
11. What are 'IF functions'?
12. Using the IF function

CUSTOMISING EXCEL

1. Modifying basic Excel options
2. Minimizing the Ribbon
3. AutoCorrect options

PRINTING

1. WORKSHEET
2. SE T U P
3. Worksheet margins
4. Worksheet orientation
5. Worksheet page size
6. Headers and footers
7. Header and footer fields
8. Scaling your worksheet to fit a page(s)
9. PREPARING TO PRINT A WORKSHEET

Visually check your calculations

1. Displaying gridlines when printing
2. Printing titles on every page when printing
3. Printing the Excel row and column headings
4. Spell checking
5. Previewing a worksheet
6. Comparing workbooks side by side
7. Zooming the view
8. Printing options