Microsoft Excel 2010 ? Basic Excel
Microsoft Excel 2010
? Basic Excel
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 2010
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
Good practice when creating or editing lists
1. MANIPULATING ROWS AND COLUMNS
2. Inserting rows into a worksheet
3. Inserting columns into a worksheet
4. Deleting rows within a worksheet
5. Deleting columns within a worksheet
6. Modifying column widths
7. Modifying column widths using 'drag and drop'
8. Automatically resizing the column width to fit contents
9. Modifying row heights
10. MANIPULATING CELLS AN
11. D CELL CONTENT
12. Copying a cell or range contents within a workbook.
13. Deleting cell contents
14. Moving the contents of a cell or range within a workbook
15. Editing cell content
16. Undo and Redo
17. Copying the contents of a cell or range between worksheets (within the same
workbook)
18. Moving the contents of a cell or range between worksheets (within the same
workbook)
19. Moving the contents of a cell or range between worksheets (in different
workbooks)
20. Copying the contents of a cell or range between worksheets (in different
workbooks)
21. AutoFill
22. Copying a data range using AutoFill
23. Sorting a cell range
24. SEARCHING
25. Searching and replacing data
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
CHARTS
1. Inserting a column chart
2. Inserting a line chart
3. Inserting a bar chart
4. Inserting a pie chart
5. Resizing a chart
6. Deleting a chart
7. Chart title or labels
8. Changing the chart background color
9. Changing the column, bar, line or pie slice colors in a chart
10. Modifying the legend fill color
11. Changing the chart type
12. Modifying charts using the Layout tab
13. Copying and moving charts within a worksheet
14. Copying and moving charts between worksheets
15. Copying and moving charts between workbooks
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