April 19th, 2024
- Basics
- Interm
- Adv
- Basics (Onl)
- Interm (Onl)
- Adv (Onl)
- LOOKUPs (Onl)
- PivotTables Ess (Onl)
- PivotTables Adv (Onl)
- Macros (Onl)
Excel- Basics (face-to-face)
Detailed Content
This course is a 1-day hands-on, face-to-face session and participants will learn how to:
- Describe Excel’s screen layout and navigate the screen easily.
- Make it easier to find and use Excel’s buttons and functions.
- Enter data and simple formulas.
- Navigate spreadsheets with mouse and keyboard shortcuts.
- Edit a spreadsheet: add and remove rows and columns, adjust widths, etc.
- Cut, paste and copy formulas.
- Create patterns of data: dates, months, days, etc.
- Format a spreadsheet to make it look presentable.
- Create and edit simple charts and graphs.
- Change displays and freeze parts of spreadsheets.
- Print, email spreadsheets and charts, and output to PDF.
- Use shortcuts and quick-entry techniques.
- Save and open spreadsheets to correct drive/folder locations.
- Apply sorting and filtering techniques to view the data you want.
Flexible Options
Courses are delivered in our training rooms in Albury, Shepparton and Wagga. OR, sessions can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.
See Benefits to the right for a list of services provided to all participants (depending on the course).
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
No experience in using Excel is required nor assumed. Participants are expected to have some knowledge of and experience with a Windows PC.
Upcoming Dates
-
ALBURYMay022024
-
ALBURYJun182024
Excel – Intermediate (face-to-face)
Detailed Content
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Revise the important basics and shortcuts.
- Format charts better with simple dashboards to improve presentation.
- Work with data linked to graphs/charts better.
- Sort and manipulate data more easily: change data, split and combine data, etc.
- Make formulas update automatically when adding new data.
- Use cell name ranges to create formulas more easily.
- Group and outline large data to summarise it easily.
- Manage and copy sheets using shortcuts, calculate totals across sheets and link to files.
- Create, edit and format powerful reports with PivotTables.
- Add new data and make PivotTables reports update automatically.
- Find duplicate data, view documents side-by-side.
Flexible Options
Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.
See Benefits to the right for a list of services provided to all participants (depending on the course).
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training Excel Basics course or experience with Excel.
Upcoming Dates
-
ALBURYApr302024
-
ALBURYJun192024
Excel – Advanced (face-to-face)
Detailed Content
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Revise some important Excel shortcuts.
- Create and work with IF functions (IF, COUNTIF, SUMIF, multiple IFs).
- Create and troubleshoot LOOKUP functions (V/H LOOKUP, the newer XLOOKUP).
- Create complex ‘nested’ formulas to extract data better.
- Add new data and have powerful formulas update automatically.
- Use automated database features and SUBTOTAL functions.
- Massage data automatically: convert text to numbers, change case, combine columns, etc.
- Automate processes by creating and working with macros.
- Edit macros and work with Visual Basic (VBA) code.
- Use data validation to prevent data-entry errors.
- Use conditional formatting for ‘dashboard’ reporting.
- Apply data-entry protection to data correctly.
- Share workbooks and work with templates.
- Integrate data more efficiently and create live links.
Flexible Options
Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.
See Benefits to the right for a list of services provided to all participants (depending on the course).
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training Excel Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).
Upcoming Dates
-
ALBURYMay012024
-
ALBURYJun202024
Excel – Basics (live online)
Detailed Content
This is a 3-hour live, online session and participants will learn how to:
- Describe Excel’s screen layout and navigate the screen easily.
- Make it easier to find and use Excel’s buttons and functions.
- Enter data and simple formulas.
- Navigate spreadsheets with mouse and keyboard shortcuts.
- Edit a spreadsheet: add and remove rows and columns, adjust widths, etc.
- Format a spreadsheet to make it look presentable.
- Create and edit simple charts and graphs.
- Change displays and freeze parts of spreadsheets.
- Print, email spreadsheets and charts, and output to PDF.
- Apply sorting and filtering techniques to view the data you want.
What You Receive During Online Session
All participants receive:
- PDF workbook of step-by-step instructions.
- Interactivity – you can ask and answer questions.
- Recording of the session for on-demand reviewing later.
- Support for your questions after the session.
- Copies of all example files for your own work.
What You Require For Online Session
- Your PC/laptop, with internet, sound enabled and speakers.
- A headset with microphone is recommended.
- Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
No experience with Excel is assumed. Attendees should have previous experience with a Windows PC.
Upcoming Dates
-
OnlineMay202024
Excel – Intermediate (live online)
Detailed Content
This is a 3-hour live, online session and participants will learn how to:
- Revise the important basics and shortcuts.
- Work better with data linked to graphs/charts.
- Sort and manipulate data more easily: change data, split and combine data, etc.
- Make formulas update automatically when adding new data.
- Use cell name ranges to create formulas more easily.
- Group and outline large data to summarise it easily.
- Manage and copy sheets using shortcuts, calculate totals across sheets and link to files.
- Format charts better to improve presentation.
- Introduction to and working with pivottables to analyze and report data.
What You Receive During Online Session
All participants receive:
- PDF workbook of step-by-step instructions.
- Interactivity – you can ask and answer questions.
- Recording of the session for on-demand reviewing later.
- Support for your questions after the session.
- Copies of all example files for your own work.
What You Require For Online Session
- Your PC/laptop, with internet, sound enabled and speakers.
- A headset with microphone is recommended.
- Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training Excel Basics course or experience with Excel.
Upcoming Dates
No courses or sessions scheduled. Inquire via phone (02) 6041 2711 or use our Contact Us page.
Excel – Advanced (live online)
Detailed Content
This is a 3-hour live, online session and participants will learn how to:
- Create and work with IF functions (IF, COUNTIF, SUMIF, multiple IFs).
- Create complex ‘nested’ formulas to extract data better.
- Add new data and have powerful formulas update automatically.
- Use automated database features and SUBTOTAL functions.
- Massage data automatically: convert text to numbers, change case, combine columns, etc.
- Use data validation to prevent data-entry errors.
- Use conditional formatting for ‘dashboard’ reporting.
- Apply data-entry protection to data correctly.
What You Receive During Online Session
All participants receive:
- PDF workbook of step-by-step instructions.
- Interactivity – you can ask and answer questions.
- Recording of the session for on-demand reviewing later.
- Support for your questions after the session.
- Copies of all example files for your own work.
What You Require For Online Session
- Your PC/laptop, with internet, sound enabled and speakers.
- A headset with microphone is recommended.
- Double-screen or wide-screen if you wish to follow the trainer, otherwise you just watch.
Bookings for this session can be made online via the ‘Book now’ links top-right (scroll up).
NOTE: Payment is required before the session to connect.
To inquire about a closed corporate program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
Some experience in using Excel is recommended.
Upcoming Dates
-
OnlineMay172024
Excel – LOOKUP Formulas (live online)
Detailed Content
This is a 2-hour live, online session and participants will learn how to:
- Create simple and complex LOOKUP formulas.
- Use the newer XLOOKUP formula and why it’s better.
- Use LOOKUPs to integrate and combine data.
- Fix errors/issues when LOOKUP formulas don’t work.
- Add new data and make LOOKUPs update automatically.
- Use LOOKUP formulas to compare lists of data.
- Apply LOOKUP formulas to your work.
- Answer your questions.
What You Receive During Online Session
All participants receive:
- PDF workbook of step-by-step instructions.
- Interactivity – you can ask and answer questions.
- Recording of the session for on-demand reviewing later.
- Support for your questions after the session.
- Copies of all example files for your own work.
What You Require For Online Session
- Your PC/laptop, with internet, sound enabled and speakers.
- A headset with microphone is recommended.
- Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training Excel Basics or Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).
Upcoming Dates
No courses or sessions scheduled. Inquire via phone (02) 6041 2711 or use our Contact Us page.
Excel – PivotTables Essentials (live online)
Detailed Content
This is a 3-hour live, online session and participants will learn how to:
- State what types of data can be reported with pivottables.
- Create and edit pivottables, build better reports, etc.
- Create pivottable report dashboards.
- Filter pivottable data with drop-downs and slicers.
- Format pivottable data quickly and create graphs/charts from reported data easily.
- Drill down into pivottables to see details.
- Use advanced reporting (change calculations, include KPIs, etc).
- Change, add new data and update pivottables to include new data automatically.
- Apply features to your work to save time and build better reports.
What You Receive During Online Session
All participants receive:
- PDF workbook of step-by-step instructions.
- Interactivity – you can ask and answer questions.
- Recording of the session for on-demand reviewing later.
- Support for your questions after the session.
- Copies of all example files for your own work.
What You Require For Online Session
- Your PC/laptop, with internet, sound enabled and speakers.
- A headset with microphone is recommended.
- Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training Excel Basics or Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).
Upcoming Dates
No courses or sessions scheduled. Inquire via phone (02) 6041 2711 or use our Contact Us page.
Excel – PivotTables Advanced (live online)
Detailed Content
This is a 3-hour live, online session and builds on the PivotTables Essentials session. Participants will learn how to:
- Revise the PivotTables Essentials session.
- Report raw text data (surveys, etc) with pivottables.
- Add extra calculated fields automatically to a pivottable.
- Use macro ‘buttons’ to auto-update PivotTables.
- Report data from multiple sheets using links, relationships and data-modelling pivottable reports.
- Reporting data from multiple sheets where duplicate data exists, remove duplicates, etc.
- Create a full dashboard using pivottables, filters, slicers, etc.
- Apply features to your work to save time and build better reports.
What You Receive During Online Session
All participants receive:
- PDF workbook of step-by-step instructions.
- Interactivity – you can ask and answer questions.
- Recording of the session for on-demand reviewing later.
- Support for your questions after the session.
- Copies of all example files for your own work.
What You Require For Online Session
- Your PC/laptop, with internet, sound enabled and speakers.
- A headset with microphone is recommended.
- Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training Excel Basics or Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).
Upcoming Dates
-
OnlineMay032024
Excel – Macros (live online)
Detailed Content
This is a 2-hour live, online session and participants will learn how to:
- Describe a what a macro is.
- Create simple and complex macros.
- Make macros run with buttons and keyboard shortcuts.
- Make macros run automatically with special macro names and by activating sheet tabs.
- Edit macros, with introduction to VBA coding.
- Hard-code macro commands with message boxes and more.
- Trouble-shoot and debug macros.
- Apply macros to your work to save time.
- Manage macros – rename/delete macros, etc.
What You Receive During Online Session
All participants receive:
- PDF workbook of step-by-step instructions.
- Interactivity – you can ask and answer questions.
- Recording of the session for on-demand reviewing later.
- Support for your questions after the session.
- Copies of all example files for your own work.
What You Require For Online Session
- Your PC/laptop, with internet, sound enabled and speakers.
- A headset with microphone is recommended.
- Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training Excel Basics or Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).
Upcoming Dates
No courses or sessions scheduled. Inquire via phone (02) 6041 2711 or use our Contact Us page.
Recent Reviews – All Excel Courses
Informative and enjoyable (Excel Basics)
Francis’ delivery and knowledge of the course and the pacing was great; was an efficient use of time.
Really Relevant (Excel Intermediate)
How simple it was to learn the three take aways for myself, and the level of detail the instructor went into while keeping it easy to understand.
Kept My Attention (Excel Basics)
Very infomative, kept my attention, teacher was good and the workbook has a great breakdown on how to do everything we learnt today so that we have something to refer back to when we need.
Easy and Understandable (Excel Basics)
The steady pace allowed me to complete so much.
Very enjoyable (Excel Basics)
I really enjoyed Mark’s teaching style. I found him both informative and entertaining.