Microsoft Office Excel 2011 Level 1 Macintosh

Course 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.
1 day
Contact us for pricing
Contact us for dates
Contact us for dates

Prerequisites

Prospective participants should be familiar with the Mac OS X v10.5 (basic typing skills are recommended). They should be comfortable in the Macintosh environment and be able to use Macintosh to manage information on the computer. Specifically, they should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. Web browsing experience is also strongly recommended.

Course Objective

Upon successful completion of this course, students will be able to:
create a basic worksheet by using Microsoft Excel 2011.
perform calculations in an Excel worksheet.
modify an Excel worksheet.
modify the appearance of data within a worksheet.
manage Excel workbooks.
print the content of an Excel worksheet.

Getting Started with Excel

Identify the Elements of the Excel Interface
Navigate and Select Cells in Worksheets
Customize the Excel Interface
Create a Basic Worksheet

Performing Calculations in an Excel Worksheet

Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas

Modifying a Worksheet

Edit Worksheet Data
Find and Replace Data
Manipulate Worksheet Elements

Modifying the Appearance of a Worksheet

Apply Font Properties
Add Borders and Colors to Cells
Align Content in a Cell
Apply Number Formatting
Apply Cell Styles

Managing an Excel Workbook

Manage Worksheets
View Worksheets and Workbooks

Printing Excel Workbooks

Define the Page Layout
Print a Workbook

Excel for MacExcel 2011ExcelMS ExcelMS Excel for MacMicrosoft Excel