MS Excel 2010 – Level 1
MS Excel 2010, Level 1 training.
Trainer: Nimmie Naidu - IT Certification Academy
Cost (includes vat and lunch)
Members R1,100 p/p, R1,070 p/p for three/more, R1,020 p/p for five/more
Non-members
Please note that payment is required in advance. R1 200 p/p, R1 170 p/p for three/more, R1 120 p/p for five/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.
Customise 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.
Time: 08:30 - 16:30
Venue: Chamber House, Royal Showgrounds, Pietermaritzburg
Cost: Members: R1,100 p/p, Non-members: R1,200 p/p