Summary
The Excel 2007 series provides a basic introduction to Excel 2007 including key skills such as entering cell data, editing and formatting cells/ worksheets, and selecting cell ranges. The series also covers printing worksheets, adding comments, creating charts and completing basic calculations and formulas. A particular emphasis is the new Ribbon interface used in Microsoft Excel 2007.
Audience
The Excel 2007 course is for anyone wanting to learn about Excel or requiring a refresher Excel course.
Excel 2007: Getting Started- 2 hrs
- What can Excel 2007 do?
- Finding your place
- Using the new Excel Ribbon
- Using the formula and status bars
- Navigating your worksheet
- Adding / renaming worksheets
Excel 2007: Creating a Worksheet- 3 hrs
- Entering data as text
- Entering cell values
- Entering formulas into cells
- Correcting spreadsheet errors
- Using AutoFill, AutoComplete, and Formula AutoComplete
- Using the AutoSum and SUM function
- Editing cells
Excel 2007: Formatting Data- 1 hr
- Choosing cells
- Formatting the layout of a cell
- Formatting the size of a cell
- Formatting data in a cell
Excel 2007: Editing and Printing Worksheets- 1 hr
- Different Worksheet views
- Editing and Formula tools
- Hiding, Inserting and Deleting
- Printing and Page Layout
Excel 2007: Managing Worksheets- 2 hrs
- Setting the Panes
- Ranges and Naming cells
- Finding Data in a Worksheet
- Multiple Workbooks
- Adding Web Links
- Protecting and Sharing Workbooks
- Commenting in cells
Excel 2007: Using Charts and Objects- 2hrs
- Creating Excel 2007 charts
- Formatting and Modifying Excel charts
- Shapes and text boxes
- Smartart
- Pictures and clip art
Purchase this course from our e commerce site at www.AuditExcel.com
|
Downloads and Free Trial
See how it
works with our
free Excel 2003
beginner course.
OR
Convince you manager to pay for your education
OR
More about the training material and how it works
Looking for something else? Search the site
|