Microsoft Excel Fundamentals

TRAINING COURSE

Microsoft Excel Fundamentals

RELATED COURSES

Microsoft PowerPoint Level 1
Microsoft Word Level 1
Windows 10 Basic Computer 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.

 

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 six delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Classroom 1 Day ZAR 1,895.00 Get a Quote
Live Virtual Training 1 Day ZAR 1,650.00 Get a Quote

Discounts Available

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

Brochure:

Download Brochure


Information may change without notice.

Customer Testimonials

Gauteng Provincial Treasury

Leading Edge gave me a better and in depth understanding of what Microsoft Excel is and what it can do.

Gauteng Provincial Treasury

What I liked was that it taught me things I didn't pay attention to and they are things that are helpful.

Pact World

Lawrence is a wonderful trainer with the greatest patience. I would gladly recommend this course and company to anyone who needs a refresher training or new training in Excel.

Pact World

Not yet, but will defiantly check it out

Solidariteit

from the moment I arrived I was welcomed, made familiar with my surroundings and the staff went out of their way in helping me in my need of personal travel arrangements, I really appreciate their overall helpful spirits.

SA Business Counsel

We'll be in contact for Business Skills Training.

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

There are currently no scheduled dates.

Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.

Add me to the waiting list

Should you need this course urgently, the following options are available:

  1. Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
  2. If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.
Submit Enquiry