About Lesson
After completing this course, participants will have learned to:
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