Excel - Essentials

Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.

Location
Date
Duration

1 Day

Time (AWST)
Address
Participants
Total

Overview

This course introduces you to the most important features of Microsoft Excel. You will learn how to design, format and print spreadsheets, how to create charts and how to develop formulas and functions.

If you use computers but are new to Excel, or don't have much experience with Excel, then this course is for you.

Content

  • Enter and edit data
  • Move around the Excel screen
  • Copy and move data
  • Write and apply formulas
  • Insert commonly used functions
    • SUM and AVERAGE
    • MAX and MIN
    • COUNT
  • Format the spreadsheet
  • Print the spreadsheet
  • Create and print charts.

Learning Outcomes

Participants should be able to:

  • Use the most important Excel commands
  • Design and construct spreadsheets
  • Use simple functions and formulas
  • Format and print spreadsheets
  • Create and print charts.
Related Results

Level - Intermediate
If you have used Microsoft Excel for some time and need to learn more, this Perth based training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.

Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.

Level - Advanced
This course is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. This course is for you, if you are a confident Word user.

Level - Fundamental
This course provides you with the skills needed to create highly professional slides and presentations with Microsoft PowerPoint.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs