Seminar Overview
Microsoft Excel is a crucial tool in modern day business and a powerhouse in terms of what it can do. Unfortunately, the complexity of the program can make it daunting for new users to navigate.
​
Our EXCE101 program demystifies Excel and provides practical hands-on training in the fundamentals of excel. Seminar participants will be guided to developing a workbook with basic functionality including simple formulas and using data tables to develop graphs.
​
If that sounds daunting, you can be assured that our experienced trainers will work with you to build your confidence and skills in Microsoft Excel.
Course Outline
Open and navigate within workbooks and worksheets.
Understand and work with ranges in a worksheet.
Understand, create and work with formulas and functions used to perform calculations.
Understand and use font formatting techniques to enhance the look of a worksheet.
Understand and use the number formatting features.
Filter and sort data on a table.
Copy and Paste data in Excel.
Move contents of cells and ranges within and between workbooks.
Understand and use formula cell referencing.
Format rows and columns in a worksheet.
Arrange data in a list in a worksheet.
Create effective charts
Suggested Participants
Seminar participants will be required to bring a laptop to the session with Microsoft Excel installed.
The presenter will be using 2019 version, if you are using an older version, the functionality may not be available during the session.
Upcoming Dates
Webinar Scheduled Dates:
Thursday, 21 March - 1pm - 4pm AEDT
Thursday, 30 July - 1pm - 4pm AEST
