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.
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