(08) 9383 8000
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.
1 Day
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.
Level – Intermediate.
If you want your documents to look more polished and professional, this course helps you build the skills to manage layouts, visuals and formatting with confidence.
You will learn how to work with tables, images and diagrams to create clearer, more engaging documents.
Level – Advanced.
If you want to save time and standardise your documents, this course builds the skills to create templates, forms and simple macros that streamline everyday work.
You will learn practical tools that improve consistency and reduce repetitive tasks.
Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.
Ready to lift your Excel capability?
This course helps you use advanced functions with confidence so you can clean data, match information and create reliable results.
You’ll learn to structure, nest and troubleshoot formulas that simplify complex tasks and improve the quality of your analysis.