MS Excel 2010 - Level 1

TRAINER: Nimmie Naidu - IT Certification Academy

COST (includes vat)
Members R1 100 p/p, R1 070 p/p for 3/more, R1 020 p/p for 5/more
Non-members R1 200 p/p, R1 170 p/p for 3/more, R1 120 p/p for 5/more

OVERVIEW

Module 1: Creating a basic worksheet
Explore the User Interface and the Ribbon.
Navigate and select in Excel.
Obtain help.
Enter data and save a workbook.
Customize the quick access toolbar.

Module 2: Performing calculations
Create basic formulas.
Calculate with functions.
Copy formulas and functions.

Module 3: Modifying a worksheet
Manipulate data.
Insert and delete cells, columns and rows.
Search for data in a worksheet.
Spell check a worksheet.

Module 4: Formatting a worksheet
Modify fonts.
Add borders and colour to cells.
Change column width and row height.
Apply number formats.
Position cell contents.
Apply cell styles.

Module 5: Printing workbook contents
Print workbook contents using default print options.
Set print options.
Set page breaks.

Module 6: Managing large workbooks
Format worksheet tabs.
Manage worksheets in a workbook.
Manage the view of large worksheets.

Date: 12 June 2013
Time: 08:30 - 16:30
Venue: Chamber House, Royal Showgrounds, Pietermaritzburg
Cost: Members: R1 100 p/p, Non-members: R1 200 p/p