Skip to main content
Get a Quote
Course Enquiry
Contact Us

Microsoft Excel 2013: Basic Course Details


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,Microsoft Excel 2013 77-420

NB! Exam is charged separately

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

Duration:

1 Day

Price:

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

PC Hire:

$25   *Bring a PC

Note: information may change without notice.

Download Brochure:

Download Brochure

About Microsoft Excel 2013: Basic

You will create and edit basic Microsoft Office Excel 2013 worksheets and workbooks.

Course Outline


  • Lesson 1: Getting Started with Microsoft Excel 2013
    • Identify the Elements of Excel Interface
    • Creating Basic Worksheet
    • Use the Help System
  • Lesson 2: Performing Calculations
    • Creating Formulas in a Worksheet
    • Insert Functions in a Worksheet
    • Reuse Formula
  • Lesson 3: Modifying a Worksheet
    • Manipulate Data
    • Insert, Manupilate, and Delete Cells, Columns, and Rows
    • Search for and Replace Data
    • Spell Check a Worksheet
  • Lesson 4: Formatting a Worksheet
    • Modify Fonts
    • Add Borders and Color to Cells
    • Apply Number Formats
    • Align Cell Contents
    • Apply Cell Styles
  • Lesson 5: Printing Workbook Contents
    • Define the Basic Page Layout for a Workbook
    • Refine the Page Layout and Apply Print Options
  • Lesson 6: Managing Large Workbooks
    • Format Worksheet Tabs
    • Manage Worksheets
    • Manage the View of Worksheets and Workbooks
  • Lesson 7:Customizing Excel Environment
    • 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

 

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.

Scheduled Dates


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 Duration  
Mon 15 Jan 2018 1 Day Book Now
Mon 5 Feb 2018 1 Day Book Now
Mon 26 Mar 2018 1 Day Book Now
Mon 16 Apr 2018 1 Day Book Now
Mon 28 May 2018 1 Day Book Now
Wed 20 Jun 2018 1 Day Book Now
Mon 23 Jul 2018 1 Day Book Now
Mon 27 Aug 2018 1 Day Book Now
Mon 17 Sep 2018 1 Day Book Now
Wed 17 Oct 2018 1 Day Book Now
Mon 12 Nov 2018 1 Day Book Now
Wed 5 Dec 2018 1 Day Book Now