Skip to main content
Get a Quote
Course Enquiry
Contact Us

Details

You will create and edit basic Microsoft Office Excel Worksheets and Workbooks.

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.

On completion of Basics, Intermediate and Advanced Microsoft Excel delegates may also write the Microsoft Office Specialist Exam.

NB! Exam is charged separately

Base Cost

$175.00

Calculate Discount

  I will bring my own PC (less $25.00)
  I will book and pay 10 business days before the course (less $17.50)

Total

$
If you are currently resident in South Africa you will need to pay VAT at 15%.

Duration:

1 Day

Brochure:

Download Brochure

Cost

$150.00 If you are currently resident in South Africa you will need to pay VAT at 15%.

PC Hire:

$25.00
Or bring your own PC

Duration:

1 Day

Brochure:

Download Brochure


Information may change without notice.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.

Audience

This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel  worksheets.

Pre-Requisites

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

Course Outline / Curriculum

  • Lesson 1: Getting Started with Microsoft Excel
    • Navigate the Excel User Interface
    • Use Excel Commands
    • Creating and Save a Basic Workbook
    • Enter Cell Data
    • Use Excel Help
  • Lesson 2: Performing Calculations
    • Creating Formulas in a Worksheet
    • Insert Functions in a Worksheet
    • Reuse Formula
  • Lesson 3: Modifying a Worksheet
    • Manipulate Data
    • Insert, Manipulate, and Delete Cells, Columns, and Rows
    • Search for and Replace Data
    • Use Proofing and Research Tools
  • Lesson 4: Formatting a Worksheet
    • Modify Fonts
    • Add Borders and Color to Cells
    • Apply Number Formats
    • Align Cell Contents
    • Apply Cell Styles and Themes
    • Apply Basic conditional formatting
    • Create and Use Templates
  • Lesson 5: Printing Workbook Contents
    • Preview and Print a Workbook 
    • Define the Page Layout
  • Lesson 6: Managing Large Workbooks
    • Manage Worksheets
    • Manage the View of Worksheets and Workbooks
    • Manage Workbook Properties 

Schedule Dates and Booking

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date Branch Duration  
Mon 9 Dec 2019 Woodmead 1 Day Book Now
Mon 6 Jan 2020 Woodmead 1 Day Book Now
Mon 3 Feb 2020 Woodmead 1 Day Book Now
Mon 17 Feb 2020 Woodmead 1 Day Book Now
Wed 26 Feb 2020 Woodmead 1 Day
Mon 2 Mar 2020 Woodmead 1 Day Book Now
Mon 30 Mar 2020 Woodmead 1 Day Book Now
Tue 14 Apr 2020 Woodmead 1 Day Book Now
Wed 22 Apr 2020 Woodmead 1 Day Book Now
Mon 4 May 2020 Woodmead 1 Day
Mon 1 Jun 2020 Woodmead 1 Day
Mon 22 Jun 2020 Woodmead 1 Day
Wed 1 Jul 2020 Woodmead 1 Day
Mon 6 Jul 2020 Woodmead 1 Day
Mon 3 Aug 2020 Woodmead 1 Day
Mon 17 Aug 2020 Woodmead 1 Day
Wed 26 Aug 2020 Woodmead 1 Day
Mon 31 Aug 2020 Woodmead 1 Day
Mon 5 Oct 2020 Woodmead 1 Day
Mon 19 Oct 2020 Woodmead 1 Day
Wed 28 Oct 2020 Woodmead 1 Day
Mon 2 Nov 2020 Woodmead 1 Day
Mon 30 Nov 2020 Woodmead 1 Day