Microsoft Office Excel 2011 Level 1 Macintosh
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.
Contact us for pricing
PrerequisitesProspective 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 ObjectiveUpon 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 ExcelIdentify 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 WorksheetCreate Formulas in a Worksheet
Insert Functions in a Worksheet
Modifying a WorksheetEdit Worksheet Data
Find and Replace Data
Manipulate Worksheet Elements
Modifying the Appearance of a WorksheetApply Font Properties
Add Borders and Colors to Cells
Align Content in a Cell
Apply Number Formatting
Apply Cell Styles
Managing an Excel WorkbookManage Worksheets
View Worksheets and Workbooks
Printing Excel WorkbooksDefine the Page Layout
Print a Workbook
Excel for MacExcel 2011ExcelMS ExcelMS Excel for MacMicrosoft Excel