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.
Cost: Price on application
Duration: 1 day
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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.
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
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