MS Excel 2010 Core

MS EXCEL 2010 CORE

TRAINER: Nimmie Naidu – IT Certification Academy

Date 3 March 2016
Time 08:30 – 16:30
Venue Chamber House, Royal Showgrounds
COST (includes vat and lunch)
Members R1 180 p/p, R1 150 p/p for 3/more, R1 100 p/p for 5/more
Non-members
Please note that payment is required in advance. R1 280 p/p, R1 250 p/p for 3/more, R1 200 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

WHO SHOULD ATTEND
This course is intended for individuals who want to gain basic knowledge of working on excel.