In our Excel Introduction class you will learn how to design financial spreadsheets, create formulas to total rows and columns, do averages and percentages, copy and move information, apply formatting to your spreadsheets, use the format painter, print, insert and remove columns and rows, do margins and set print ranges, and work on multiple spreadsheets at the same time.

Chapter One: The Fundamentals

• Starting Excel
• What’s New in Excel 2007?
• Understanding the Excel Program Screen
• Using Menus
• Using Toolbars and Creating a New Workbook
• Filling Out Dialog Boxes
• Keystroke and Right Mouse Button Shortcuts
• Opening a Workbook
• Saving a Workbook
• Moving the Cell Pointer
• Navigating a Worksheet
• Entering Labels in a Worksheet
• Entering Values in a Worksheet and Selecting a Cell Range
• Calculating Value Totals with AutoSum
• Entering Formulas
• Using AutoFill
• Previewing and Printing a Worksheet
• Getting Help
• Changing the Office Assistant and Using the “What’s This” Button
• Closing a Workbook and Exiting Excel

Chapter Two: Editing a Worksheet

• Entering Date Values and using AutoComplete
• Editing, Clearing, and Replacing Cell Contents
• Cutting, Copying, and Pasting Cells
• Moving and Copying Cells with Drag and Drop
• Collecting and Pasting Multiple Items
• Working with Absolute and Relative Cell References
• Using the Paste Special Command
• Inserting and Deleting Cells, Rows, and Columns
• Using Undo, Redo, and Repeat
• Checking Your Spelling
• Finding and Replacing Information
• Advanced Printing Options
• File Management
• Inserting Cell Comments
• Understanding Smart Tags
• Recovering Your Workbooks

Chapter Three: Formatting a Worksheet

• Formatting Fonts with the Formatting Toolbar
• Formatting Values
• Adjusting Row Height and Column Width
• Changing Cell Alignment
• Adding Borders
• Applying Colors and Patterns
• Using the Format Painter
• Using AutoFormat
• Creating a Custom Number Format
• Creating, Applying, and Modifying a Style
• Formatting Cells with Conditional Formatting
• Merging Cells, Rotating Text, and using AutoFit
• Finding and Replacing Formatting

Chapter Four: Managing Your Workbooks

• Switching Between Sheets in a Workbook
• Inserting and Deleting Worksheets
• Renaming and Moving Worksheets
• Working with Several Workbooks and Windows
• Splitting and Freezing a Window
• Referencing External Data
• Creating Headers, Footers, and Page Numbers
• Specifying a Print Area and Controlling Page Breaks
• Adjusting Page Margins and Orientation
• Adding Print Titles and Gridlines
• Changing the Paper Size and Print Scale
• Protecting a Worksheet
• Hiding Columns, Rows and Sheets
• Viewing a Worksheet and Comparing Workbooks Side by Side
• Saving a Custom View
• Working with Templates
• Consolidating Worksheets

Inquire about the Excel course now
Chicago: (312) 920-8822
Oak Brook: (630) 705-9999