5.00
(1 Rating)

Excel Foundations

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

This online workshop equips attendees with the fundamentals of using Excel. These sessions are available on-demand, which means you can learn at your own pace. You get direct access to the trainer, with exercises and a test of competence at the end of the course.

What Will You Learn?

  • Understand the layout of the Excel window
  • Effectively navigate the spreadsheet
  • Understand the clipboard
  • Analyse data effectively
  • Use basic functions & formulas
  • Understand absolute and relative references

Course Content

An Introduction to Excel
What we'll be covering in this Excel Foundations course. Start here!

  • Meet your Host
    00:50
  • What you can expect!
    02:40
  • Workbook: Introduction
  • An Introduction to Excel
    05:01

Creating your first workbook
In this section we talk basics around creating your first workbook, including the Excel window, formatting and navigating effectively through Excel

Getting ready to print
We talk about print options and the best ways to change your page layout

Working with Data
Copy / paste, autofill, conditional formatting and more, we learn about how to work with data well!

Using Functions and Formulas
We look at important concepts like absolute and relative references as well as basic functions including SUM, COUNT and even ROUND

Smart Charts
Let's create some basic charts! Includes a column and pie chart

Conclusion
Check out the completed workbook, as well as preparation for your test of competence

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
MM
Mapitsi Makoni
4 years ago
The training was very beneficial , I have really learned a lot.