Excel 2007 - Beginning Level Seminar

Full Day: In this course you will learn how to create a basic worksheet, perform calculations, modify a worksheet and print workbook contents.

Creating a Basic Worksheet
•    Explore the user Interface and the Ribbon
•    Navigate and Select in Excel
•    Obtain Help
•    Enter Data and Save a Workbook
•    Customize the Quick Access Toolbar

Performing Calculations
•    Create Basic Formulas
•    Calculate with Functions
•    Copy Formulas and Functions

Modifying a Worksheet
•    Manipulate Data
•    Insert and Delete Cells, Columns, and Rows
•    Search for Data in a Worksheet
•    Spell Check a Worksheet

Formatting a Worksheet
•    Modify Fonts
•    Add Borders and Color to Cells
•    Change Column Width and Row Height
•    Apply Number Formats
•    Position Cell Contents
•    Apply Cell Styles

Printing Workbook Contents
•    Print Workbook Contents Using Default Print Options
•    Set Print Options
•    Set Page Breaks

Managing Large Workbooks
•    Format Worksheet Tabs
•    Manage Worksheets in a Workbook
•    Manage the View of Large Worksheets

Download this outline as a PDF.