It’s a given in today’s office environment that a basic knowledge of spreadsheets will be required at some time or another. This course is designed to help first time users of excel. We put great effort in taking it slow to ensure that after completion you will be able to prepare your own spreadsheets without assistance.
You also get free access to our online E-Learning platform which includes videos, questions, examples and exams. This is the exact same content as the course. This access is valid for 12 months.
This course is normally 6 hours in total. These 6 hours can be delivered in different ways:
Anyone in any business can attend, first time users, students, financial and administrative personnel, secretaries and job seekers.
We do not have workshops currently, but only provide on site training customized to your needs.
If you are not sure of your level, click here to do our excel assessment.
The cost for on-site training is R10,000 per day. Maximum 15 delegates for computer training and 30 delegates for soft skills training.
You can also do the course online for $50. Our elearning platform is one of the best in the world and includes videos, simulations, assessments, examples and examinitions. You can print your own certificate on completion of the examination.. Contact us for a free demo.
Unit 1: Getting Started with Excel
Topic A: Identifying the Elements of the Excel Interface
Topic B: Navigate and Select Cells in Worksheets
Topic C: Customize the Excel Interface
Topic D: Create a basic Worksheet
Unit 2: Performing Calculations in an Excel Worksheet
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Topic C: Reuse Formulas
Unit 3: Modifying an Excel Worksheet
Topic A: Edit Worksheet Data
Topic B: Find and Replace Data
Topic C: Manipulate Worksheet Elements
Unit 4: Modifying the Appearance of a Worksheet
Topic A: Apply Font Properties
Topic B: Add Borders and Colors to Cells
Topic C: Align Content in a Cell
Topic D: Apply Number Formatting
Topic E: Apply Cell Styles
Unit 5: Managing an Excel Workbook
Topic A: Manage Worksheets
Topic B: View Worksheets and Workbooks
Unit 6: Printing Excel Workbooks
Topic A: Define the Page Layout
Topic B: Print a Workbook