Microsoft Office Excel 2008 Level 1 Macintosh

Request more details:

submit request
Description:
You followed traditional bookkeeping practices to store transaction details in ledgers. It is quite a task to glean information from these ledgers and perform calculations. You want to migrate the ledger data to an electronic format so that the task of performing complex calculations is easy. In this course, you will store data electronically, update it, and run reports . You will also learn how to create charts, sort, and filter data.
Prerequisites:
You should be familiar with personal computers. You should be comfortable with the Macintosh environment and be able to use it to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and, manage files and folders. You should have completed the following courses or possess equivalent knowledge:
Mac OS X v10.5 (Leopard): Introduction
Mac OS X v10.3: Introduction
Course Objective:
You will create and edit basic Microsoft Office Excel 2008 worksheets and workbooks.
Creating a Basic Worksheet:
Explore the User Interface
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize Toolbars and Menus
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 Colors to Cells
Change the 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