Topic 1

Getting started

• Workshop Objectives Explained
• Pre-Assignment

Topic 2

Excel Essentials

• Objectives
• Starting Excel
  • Starting Excel
  • Starting Excel in Windows 8 Only
• What is a Worksheet?
• What is a Workbook?
• Identifying Parts of the Screen
• The Ribbon
• Using Selection Techniques
  • Selecting a Cell
• Selecting a Range of Cells
• Selecting Nonadjacent Cells and Ranges
• Selecting an Entire Worksheet
• Entering Data
  • Identifying Types of Data
• Entering Text Data into a Cell
• Entering Values
• Entering Data into a Range
• Quickly Adjusting a Column Width
• Finishing a Workbook
  • Saving a New Workbook
• Saving a Named Workbook
• Printing a Worksheet
• Closing a Workbook and Exiting from Excel
• Assignment

Topic 3

Modifying a Workbook

• Opening a Workbook
  • Opening an Existing Workbook
• Creating a New Workbook
• Opening a Recently Used Workbook
• Creating Simple Formulas
  • Creating a Formula by Typing
• Creating a Formula by Pointing
• Using Functions
• Using the SUM Function
• Using the AutoSum Button

• Using AutoSum
• Using the Formula Palette
• Editing Data on the Worksheet

• Replacing the Data in a Cell
• Editing the Data in a Cell
• Editing a Formula
• Clearing the Contents from a Cell or Range
• Using Undo and Redo
• Assignment

Topic 4

Managing the Worksheet

• Navigating in a Worksheet
  • Using Special Navigation Keys
• Using the Scroll Bars and Boxes
• Moving One Screen
  • Moving to the End of the Worksheet
• Changing Worksheets
• Using Go To
• Changing the Worksheet Structure
  • Inserting Cells, Rows and Columns
• Deleting Cells, Rows, and Columns
• Performing a Simple Sort
• Creating and Using Named Ranges
  • Naming Ranges
• Automatically Naming Ranges
• Navigating with Named Ranges
• Using Range Names in Formulas
• Pasting a List of Named Ranges
• Deleting and Editing Range Names
• Creating Named Constants
• Assignment

Topic 5

Formatting the Worksheet

• Moving and Copying Data
  • Moving Data
• Copying Data
• Copying Data with AutoFill
• Creating a Series with AutoFill
• Defining Relative, Mixed, and Absolute References
• Copying Formulas
• Changing the Appearance of Data
  • Changing Column Width
• Changing Row Height
• Formatting Numbers
• Fonts
• Adding Enhancements
  • Using Font Style Attributes
• Aligning Data in Cells
• Merging and Centre Cells
• Rotating and Indenting Text
• Adding Borders and Shading
• Assignment

Topic 6

Printing the Worksheet

• Printing a Single Worksheet
  • Using the Print Dialog Box
• Using Print Preview
• Creating Headers and Footers
• Removing the Grid
• Printing a Workbook
  • Printing a Whole Workbook
• Printing a Selection
• Using Print Areas
• Using Advanced Printing Techniques
  • Changing Page Layout
• Aligning the Printout
• Fitting a Document onto a Desired Number of Pages
• Working with Page Breaks
• Working with Page Breaks in Normal View
• Setting Print Titles
• Removing Print Titles
• Assignment

Topic 7

Course Wrap Up

• Words from the Wise
• Lessons Learned