PCB MENU
PCB MENU
Loading Events

« All Events

  • This event has passed.

MS Excel 2013 – Core

May 15 @ 8:30 am - 4:30 pm

R1271.05 - R1371.93

MS EXCEL 2013 – CORE

TRAINER: Malusi Zungu – IT Certification Academy

Date 15 May 2018
Time 08:30 – 16:30
Venue Chamber House, Royal Showgrounds
COST (includes vat)
Members R1 271-05 p/p, R1 240-79 p/p for 3/more, R1 180-27 p/p for 5/more
Non-members R1 371-93 p/p, R1 341-67 p/p for 3/more, R1 281-15 p/p for 5/more

OVERVIEW
Module 1: Getting Started with Microsoft Excel
The following topics are covered in this module:
• Identify the Elements of the Excel Interface
• Create a Basic Worksheet
• Use the Help System
Module 2: Performing calculations
The following topics are covered in this module:
• Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Reuse Formulas
Module 3: Modifying a worksheet
The following topics are covered in this module:
• Manipulate data
• Insert and delete cells, columns and rows
• Search for data in a worksheet
• Spell check a worksheet
Module 4: Formatting a worksheet
The following topics are covered in this module:
• Modify Fonts
• Add Borders and Colour to Cells
• Apply Number Formats
• Align Cell Contents
• Apply Cell Styles
Module 5: Printing workbook contents
The following topics are covered in this module:
• Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options
Module 6: Managing large workbooks
The following topics are covered in this module:
• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks
Lesson 7: Customizing the Excel Environment
The following topics are covered in this module:
• Customize General and Language Options
• Customize Formula Options
• Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Customize the Functionality of Excel by Enabling Add-Ins
• Customize Advanced and Trust Center Options
WHO SHOULD ATTEND
This course is intended for individuals who want to gain basic knowledge of working on excel.

Attendees will receive a certificate of attendance.

Details

Date:
May 15
Time:
8:30 am - 4:30 pm
Cost:
R1271.05 - R1371.93
Event Category:
Website:
http://www.pcb.org.za

Organiser

Lorna Jones
Phone:
+27 33 345 2747
Email:
function@pcb.org.za
Website:
http://www.pcb.org.za

Venue

Chamber House
Royal Showgrounds, Chief Albert Luthuli Road
Pietermaritzburg , KwaZulu Natal 3201 South Africa
+ Google Map
Phone:
+27 33 345 2747
Website:
http://www.pcb.org.za