Microsoft Excel Fundamentals Training Course

Details

This course offers expert training in basic skills for Microsoft Excel 365. It is perfect both for Excel beginners and for Microsoft Office veterans looking to learn about new features in the latest Microsoft 365 edition of Excel.

Learners will gain simple, essential Excel skills such as creating and naming spreadsheets, editing and formatting cells, searching and proofing Excel documents, as well as learning how to create and use basic formulas.

Learners can take this course as a 1-day class led by an expert instructor, either online or in a classroom. They can also take the course in a budget-friendly e-learning format and learn the material in as little as 6-hours, or at their own pace.

Learners who complete this course will benefit from taking our Intermediate Excel course. Excel experts who wish to learn more advanced Microsoft Excel skills such as Lookup functions or Sparkline creation will want to sign up for our Advanced Excel Training Course. All three of these courses are available as a discounted bundle in our Excel Bootcamp. Professionals who want to gain comprehensive Excel skills centered on data analysis and high-level usage of Excel Power-Query functions should sign-up for our Excel Data Analysis course

 

Objectives:

  • Learn to use Excel's interface and become familiar with how to navigate its features.
  • Learn how to organise simple data-sets into readable spreadsheets.
  • Learn how to create and name Excel workbooks, and how to add, edit and organise data within them.

Delivery Methods

Delivery Method Duration
Classroom
1 Day Get a Quote
e-Learning
6 Hours Get a Quote Book Now
Live Virtual Training
1 Day 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

Letacla

This is a great course to do for fundamental Excel experience.

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.

PEPKOR Cellular Sourcing

Mr. Lowrance will always be the king of excel, he makes it simple and easy to work on excel

South African Council for the Architectural Profession

It actually reminded me of all I had forgotten over time and I grasped additional info that i might have not know at all or fell through the crack during my initial Excel training. I'd really recommend this course to anyone without basic excel.

PEPKOR Cellular Sourcing

Learning edge gave me more knowledge on excel fundamentals and it was a great experience.

Exxaro Resources Limited

Enjoyed the course, learned a lot of new key techniques. Well demonstrated. Thank you!

Audience

  • Students and administrative professionals who want a head-start in professional data management and spreadsheet skills.
  • Business owners looking for fast, affordable and reliable training to get their employees ready to work professionally with Excel.

Pre-Requisites

Students should be familiar with using personal computers and have used a mouse and keyboard. They should be comfortable in the Windows environment and be able to use Windows to find, move and organise files.

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

You can enrol at any time for this course.

Book Now

Submit Enquiry

Name
Email
Telephone
Query