Short Courses

CORPORATE TRAINING

Microsoft Excel Intermediate

About this Course

This one-day Excel Intermediate Course includes developing more productive spreadsheets to match specific workplace needs. As well as covering several Excel functions, including logical & date and time functions, this course includes data set-up and management techniques, conditional formatting, advanced charting features and more streamlined methods to enhance efficient spreadsheet creation.

Who should do this course?

Designed for current users of Microsoft Excel, this course is for those interested in building on existing foundational skills to go beyond building simple workbooks. At the end of the course, students should be able to use advanced techniques to analyse, manipulate and manage complex data and in the process create effective workbooks more efficiently. Prerequisites Learners undertaking this course should have completed Excel Beginner Course (Level 1) or have equivalent skills along with foundation file managment and windows skills. BYO Device Each participants is required to attend sessions with a laptop or suitable device with Microsoft Excel installed and ready to undertake learning.  If required, a laptop can be supplied for an additional fee. Additional Learning If you are ready for more challenging Excel skills check out our Excel Advanced Course (Level 3) or take a look at our other courses.

Limited Positions Available

Objectives:

  • Work with functions and learn formula auditing
  • Protect workbooks and create a template
  • Work with lists
  • Analyze data
  • Visualize data with charts

Overview:

Businesses everywhere are using Microsoft Excel. This course aims to expand your skills by exploring some of Excels’ more advanced data manipulation techniques, implement new functions, and charting. You can build upon skills gained to eventually become an expert in data manipulation and Excel.

For more information on this course contact our trainer Mr A Thompson

PAST STUDENTS
“It was a great course that really helped me. I am much more confident.”
Andrew P
Andrew P.
“I was a real novice and the trainer help me feel very comfortable.”
Sammy A
Sammy A.
“Lovely teacher and course. I'm already planning to do the next one. Thank you."
Mi L.
Mi L.
OTHER COURSES
  • All
  • Short Course

© 2023 AST Digital Pty Ltd – ABN 35653277537 – Contact us