Excel

Microsoft Excel combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets in our Essentials level class.

They will work with formulas and functions to calculate and return values.  Delegates will learn to change the appearance of a page, including adding headers and footers, format data and create charts.

Course Contents

Excel Essentials

• Starting Excel

• What is a Worksheet?

• What is a Workbook?

• Identifying Parts of the Screen

• Identifying the ribbon Components

• Getting Help

• Using Selection Techniques

• Selecting a Range of Cells

• Selecting Nonadjacent Cells and Ranges

• Selecting an Entire Worksheet

• Entering Data

• Entering Text Data into a Cell

• Entering Values

• Entering Data into a Range

• Quickly Adjusting a Column Width

• Finishing a Workbook

• Saving a Named Workbook

• Saving the Workbook in HTML Format

• Printing a Worksheet

• Closing a Workbook and Exiting from Excel

Formatting Text & Printing a Document

• Opening a Workbook

• Creating a New Workbook

• Opening a Recently Used Workbook

• Creating Simple Formulas

• Creating a Formula by Pointing

• Using Functions

• Using the AutoSum Button

• Using the Formula Palette

• Editing Data on the Worksheet

• Editing the Data in a Cell

• Editing a Formula

• Clearing the Contents from a Cell or Range

• Using Undo and Redo

Managing the Worksheet

• Navigating in a Worksheet

• Using the Scroll Bars and Boxes

• Changing Worksheets

• Using Go To

• Changing the Worksheet Structure

• Deleting Cells, Rows, and Columns

• Performing a Simple Sort

• Creating and Using Named 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

Formatting the Worksheet

• Moving and Copying 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 Row Height

• Applying Fonts

• Adding Enhancements

• Aligning Data in Cells

• Merging and Centering Cells

• Rotating and Indenting Text

• Adding Borders and Shading

• Using Drawing Tools

• Creating Graphic Objects

• Editing a Graphic Object

• Creating and Editing 3-D Objects 

• Using Other Drawing Tool

Printing the Worksheet/book

• Printing a Single Worksheet

• Using Print Preview 

• Creating Headers and Footers

• Removing the Grid

• Printing a Selection

• Printing a Selection

• Using Print Areas

• Using Advanced Printing Techniques

• 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