Skip to main content
University of Adelaide homepage
University of Adelaide homepage
  • Current Students
  • Staff
  • Alumni
  • Quicklinks
  • Study at Adelaide
  • Research & Innovation
  • Engage
  • About the Uni

PACE

Your session is about to expire.

For your protection, your online session will time out in  seconds.

Press OK now to continue your session.

  • Home
  • Short Courses
  • Online Short Courses
  • Micro-credentials
  • Executive Education
    • Accelerated Leader Program
    • Professional Management Program
    • Foundations of Transformative Leadership Program
    • Transformative Leadership Program
  • Industry Specific Courses
    • Family Business Accreditation Advisor Program
    • Family Law Arbitration
    • Fundamentals of Spirit Production – A Boutique Perspective
      • About the program
    • Fundamentals of Brewing Science
      • About the program
      • Dates and fees
    • Professional Certificate in Defence Industry Leadership
      • Registration
        • Scholarship Application
  • Language Courses
    • Arabic Language Courses
    • Chinese Language Courses
    • French Language Courses
    • German Language Courses
    • Italian Language Courses
    • Japanese Language Courses
    • Korean Language Courses
    • Russian Language Courses
    • Spanish Language Courses
  • Custom Learning Solutions
  • Contact Us
    • Amendment to enrolment
    • Enquire Online
    • Register your interest
    • Request a call back
    • Subscribe To Our Mailing List
  • Sign In
  • View Course Cart

Getting the Most Out of Excel Formulas and Functions

  • home
  • pace
  • Short Courses
  • Current: Getting the Most Out of Excel Formulas and Functions

Learn to use Excel more effectively to collate and organise data for easy and insightful interpretation.

  • Understand how to create a formula to solve a problem.
  • Know how and when to use essential functions that help to automate calculations.
  • Add criteria to be able to compare data using LOGICAL functions such as the IF function.
  • Know how and when to use a VLOOKUP function to easily find and display data from other spreadsheets.
  • Solve common problems using a variety of Excel tools.
  • Use tips and tricks to enhance accuracy and save time.
    Expand

  • What is covered in the course?
    • Creating usable formulas.
    • The top 5 functions and why you’d use them.
    • Using logical functions.
    • Working with lookup functions.
    • Using error functions.
    • Tips and tricks for improving your spreadsheet functionality.

  • Should I attend?

    This course is pitched for professionals at any level looking to improve their knowledge and skill of Excel – specifically formulas and functions.

  • How will I benefit?

    This interactive face-to-face workshop provides you with specific skills to build or refine spreadsheets that you use in your job. Go beyond storing important information, like budgets, human resource data or client information in Excel, and move into creating complex formulae and using advanced functions.

  • How will my organisation benefit?

    Better analysis of data using Excel.

    Need customised training for your organisation?

    Contact our team to discuss customising this course to meet your needs.

    CONTACT US GET A QUOTE FIND OUT MORE

  • AQF Equivalence, Articulation Pathways CPD Points and Certification
    • You will receive a soft copy University of Adelaide Certificate of Completion.
    • This PACE course may contribute to earning Continuing Professional Development (CPD) points or credit. Many professional associations accredit CPD at a standard rate of 1 hour of professional development / learning = 1 CPD point. This should be used as a guide only and confirmation should be sought from your accrediting body prior to registration in any PACE course or program.
Improving my knowledge and skills of the functions and formulas of Excel.past participant

What will I receive as part of this course?

  • Printed course book and materials (PDF copy for tablet on request)
  • Certificate of Completion and training record
  • Refreshments during the day, including a light lunch on full day courses

What should I bring to the course?

Our courses are designed to be work-related and interactive. Please bring current workplace examples related to this topic for use on the day.

What further development can I do?

We recommend Getting the Most Out of Excel Pivot Tables or Get Organised Using Outlook.

Available course dates:

  • Thursday 12 May, 2022 (9.30am - 1.00pm)

    Course Start Date: Thursday 12 May, 2022 (9.30am - 1.00pm)
    Location: L 7, 10 Pulteney St. Adelaide
    Instructor(s):
    Christina Mourtzios BMa&CompSc, Dip (Training and Assessment), Cert IV in TAE, Grad Dip LLN

    Christina has a strong background in learning and development with over 12 years’ experience in the industry. She is passionate about developing people and her philosophy is based on a proven ability to enhance the productivity of organisations by helping them develop the most effective and efficient people. Christina brings a creative flair to her training sessions and makes complex sounding concepts simple to understand. She is able to draw on her experiences and share her knowledge with participants so they can build confidence and find value in her training.

    Schedule number: 7992
    Required fees: Price
    Registration (GST Free)$450.00
    Register yourself and pay online Register yourself and request an invoice Register others or a group Register UOA Staff

  • Tuesday 27 September, 2022 (9.30am - 1.00pm)

    Course Start Date: Tuesday 27 September, 2022 (9.30am - 1.00pm)
    Location: L 7, 10 Pulteney St. Adelaide
    Instructor(s):
    Christina Mourtzios BMa&CompSc, Dip (Training and Assessment), Cert IV in TAE, Grad Dip LLN

    Christina has a strong background in learning and development with over 12 years’ experience in the industry. She is passionate about developing people and her philosophy is based on a proven ability to enhance the productivity of organisations by helping them develop the most effective and efficient people. Christina brings a creative flair to her training sessions and makes complex sounding concepts simple to understand. She is able to draw on her experiences and share her knowledge with participants so they can build confidence and find value in her training.

    Schedule number: 7993
    Required fees: Price
    Registration (GST Free)$450.00
    Register yourself and pay online Register yourself and request an invoice Register others or a group Register UOA Staff

PACE

Professional and Continuing Education

Address

Level 7, 10 Pulteney Street
The University Of Adelaide
South Australia 5005
Australia

Call us

+61 8 8313 3268

Contact us

Sign in & enrol online

  • Authorised by: General Manager, PACE
  • Maintained by: Web Maintainer, PACE
  • Last updated: 7 Dec 2021