Skip to main content
Get a Quote
Course Enquiry
Contact Us
Microsoft Excel Fundamentals

RELATED COURSES


TRAINERS FOR COURSE


CUSTOMERS ON THIS COURSE

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

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Fulltime 1 Day R 2,150.00
Webinar 1 Day R 1,450.00

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure


Information may change without notice.

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.

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.

Start Date End Date Branch Status  
Mon 6 Jun 2022 Mon 6 Jun 2022 Not Applicable Scheduled

Book Webinar

Mon 20 Jun 2022 Mon 20 Jun 2022 Not Applicable Scheduled

Book Webinar

Mon 4 Jul 2022 Mon 4 Jul 2022 Not Applicable Scheduled

Book Webinar

Mon 18 Jul 2022 Mon 18 Jul 2022 Not Applicable Scheduled

Book Webinar

Mon 1 Aug 2022 Mon 1 Aug 2022 Not Applicable Provisional
Mon 15 Aug 2022 Mon 15 Aug 2022 Not Applicable Provisional
Mon 29 Aug 2022 Mon 29 Aug 2022 Not Applicable Provisional
Mon 12 Sep 2022 Mon 12 Sep 2022 Not Applicable Provisional
Mon 26 Sep 2022 Mon 26 Sep 2022 Not Applicable Provisional
Mon 10 Oct 2022 Mon 10 Oct 2022 Not Applicable Provisional
Mon 24 Oct 2022 Mon 24 Oct 2022 Not Applicable Provisional
Mon 7 Nov 2022 Mon 7 Nov 2022 Not Applicable Provisional
Mon 21 Nov 2022 Mon 21 Nov 2022 Not Applicable Provisional
Mon 5 Dec 2022 Mon 5 Dec 2022 Not Applicable Provisional