Get a Quote
Course Enquiry
Contact US
Leading Edge Training

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%.   *Discount available

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. Light finger meals are supplied for part time courses.

Scheduled Dates


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

Start DateDuration 
Mon 3 Apr 20171 daysBook Here
Tue 2 May 20171 daysBook Here
Mon 5 Jun 20171 daysBook Here
Mon 3 Jul 20171 daysBook Here
Mon 7 Aug 20171 daysBook Here
Mon 4 Sep 20171 daysBook Here
Mon 2 Oct 20171 daysBook Here
Mon 6 Nov 20171 daysBook Here
Mon 4 Dec 20171 daysBook Here

Gautrain

For clients who want to enjoy the convenience of public transport, consider the Gautrain. Our training premises in Woodmead is located near the Morning Glenn Mall Bus Stop. If organised by prior arrangement we will collect delegates from the afore mentioned bus stop at no extra charge. Direction to the bus stop are as follows:

Take the Gautrain to the Sandton station.
Take the S2 Bus to Morning Glenn Mall.
We will collect you at 8:30 directly from the bus stop.

Accommodation

Please submit a query on the course page and we will be able to advise you on hotels and guest houses close to the training facility.