Tutorial 1: Using Excel to Manage Financial Data

Creating an Income statement

SESSION 1.1

  1. Introducing Excel
  2. Understanding Spreadsheets
  3. Parts of Excel window
  4. Navigating in a workbook
  5. Navigating within a worksheet
  6. Navigating between worksheets
  7. Opening and saving a Workbook
  8. Working with Ranges
  9. Selecting Ranges
  10. Other Selection Techniques
  11. Moving a selection of cells

SESSION 1.2

  1. Entering information into Worksheet
  2. Entering text
  3. Entering values
  4. Entering Formulas
  5. Entering Functions
  6. Working with Rows ands Columns
  7. Inserting a row or column
  8. Clearing or deleting a row or column
  9. Increasing the width of a column or the height of a row
  10. Editing your Worksheet
  11. Working in Edit Mode
  12. Undoing an action
  13. Working with Worksheet
  14. Adding or removing Worksheet
  15. Renaming a Worksheet
  16. Moving a Worksheet
  17. Printing a Worksheet

Tutorial 2: Creating a Worksheet

SESSION 2.1

  1. Developing Worksheets
  2. Planning the worksheet
  3. Building the worksheet
  4. Entering Labels
  5. Entering Data
  6. Using the AutoSum button
  7. Entering Formulas
  8. Copying a formula using the Fill handle
  9. Copying a formula Using Relative References

(Relative cell reference: cell references that change when copied)

  1. Copying a formula using absolute references (Absolute cell reference: cell reference in a formula that does not change when copied to another cell)
  2. Absolute versus Relative cell references
  3. Copying cell contents using the copy and paste method
  4. Renaming the worksheet

(#div is an error value)

Mixed cell reference (f4 key or dollar sign)

SESSION 2.2

  1. Excel Functions
  2. AVERAGE Function
  3. MAX Function
  4. MIN Function
  5. Testing the Worksheet
  6. Spell Checking the Worksheet
  7. Improving the Worksheet Layout
  8. Changing the column width and row height
  9. Inserting a row or column into a Worksheet
  10. Using the Undo Button
  11. Moving a range using the Mouse
  12. Using AutoFormat
  13. Previewing the Worksheet Using the Print Preview
  14. Centering the Printout
  15. Adding Headers and Footers
  16. Setting the Print Area
  17. Documenting the Workbook
  18. Adding Cell Comments
  19. Displaying and Printing Worksheet Formulas
  20. Adjust Print setups

Tutorial 3: Developing a professional-looking worksheet

Formatting a Sales Report

Session3.1

  1. Formatting Worksheet Data
  2. Using the Formatting toolbar
  3. Copying Formulas
  4. Using the Format Cells Dialog Box
  5. Working with Fonts and Colors
  6. Aligning cell contents
  7. Indenting and wrapping text
  8. Other Formatting Options
  9. Working with Cell Borders and backgrounds
  10. Adding a cell border
  11. Setting the background Color and pattern

Session 3.2

  1. Formatting the Worksheet
  2. Merging Cells into one cells
  3. Hiding Rows and columns
  4. Formatting the sheet background
  5. Formatting the sheet tabs
  6. Clearing and replacing formats
  7. Using Styles
  8. Creating a Style
  9. Applying a Style
  10. Using AutoFormat
  11. Formatting the printed worksheet alignment, page orientation,
  12. Opening the Print Preview window
  13. Defining the Page Setup
  14. Working with headers and footers
  15. Working with the Print Area and Page Breaks

Tutorial 4: Working with Charts and Graphics

Charting Sales Data for Vega Telescopes

Session 4.1

  1. Excel Charts
  2. Creating a Chart with the Chart Wizard
  3. Choosing a Chart Type
  4. Choosing a Data Source
  5. Choosing a Chart Options
  6. Choosing the Chart Location
  7. Moving and resizing an embedded Chart
  8. Updating a Chart
  9. Creating a Pie Chart
  10. Rotating the Pie Chart
  11. Exploding a Slice of Pie Chart