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
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 InterfaceNavigate and Select Cells in Worksheets
Customize the Excel Interface
Create a Basic Worksheet
Performing Calculations in an Excel Worksheet
Create Formulas in a WorksheetInsert Functions in a Worksheet
Reuse Formulas
Modifying a Worksheet
Edit Worksheet DataFind and Replace Data
Manipulate Worksheet Elements
Modifying the Appearance of a Worksheet
Apply Font PropertiesAdd Borders and Colors to Cells
Align Content in a Cell
Apply Number Formatting
Apply Cell Styles
Managing an Excel Workbook
Manage WorksheetsView Worksheets and Workbooks
Printing Excel Workbooks
Define the Page LayoutPrint a Workbook
Excel for MacExcel 2011ExcelMS ExcelMS Excel for MacMicrosoft Excel