Excel for Business – Formulas and Functions
Working with data is part of everyone’s role and learning how to harness the power of Excel to improve your productivity and efficiency is the becoming increasingly important for individuals, teams and companies to succeed.
This one-day course builds on your existing knowledge of simple formulas and enables you to use advanced formulas and functions to extract rich management information for business decision-making in diverse areas such as sales, projects, budgets, forecasts, and human resources.
Using a real-world scenario, you will learn how to construct formulas and use Excel’s inbuilt advanced functions in large data sets to extract business information. Then you will apply your learning to real data from your workplace.
Is this course right for you?
This course is designed for those with foundational knowledge of Excel functions who want to learn advanced formulas, enhance their skills, and harness the full power of Excel.
Learning Outcomes
Upon completion of this course, you will be able to use:
- Prepare data - Use Power Query to clean and transform data
- Logical functions - Automate tasks by testing values in other cells and performing actions dependent upon the result of the tests
- Nest functions - Use one or more functions within another function to create more complex and powerful formulas to perform calculations, manipulate data, or make logical evaluations
- Conditional functions - Create logical calculations to automate “If (this), then (that)”
- Essential functions - Use essential array functions to make unique list and sort, filter, and transpose data; create geographical maps
- Lookup and reference functions - Work with ranges of data and cross reference between different data sets
- Date and time functions - Extract information from, and perform operations on dates and times
- Text functions – Manipulate strings to help work with names, addresses, customer lists, or any other text-based data
> See the full agenda for Excel for Business – Formulas and Functions in our expanded Course Guide
Upcoming Courses
Learn it. Earn it. Share it.
By completing AIM’s Excel for Business – Formulas and Functions course, you will receive a certificate to recognise the high standard of learning and skill development you have attained. Print your certificate or share it electronically to demonstrate your ever-growing value to employers and peers.
Delivery mode
On-Campus Workshop – 1 day face-to-face workshops
Our Excel for Business – Formulas and Functions course is set in interactive classrooms at one of our five campuses across Australia: Sydney, Melbourne, Brisbane, Caberra, and Adelaide. The benefits of studying in a classroom setting include being able to share first-hand experiences, ideas and questions with peers and our expert facilitators. You’ll study alongside like-minded people and strengthen your network.
Unless otherwise noted, AIM's On-Campus Short Courses begin promptly at 9:00 am and finish no later than 5:00 pm (Local Time).
Additional Information
Requirements
Students must bring their own:
- PC or Mac
- A working version of Excel (2016 or later). If your version of excel doesn’t have a feature, you can use the free web-version of Excel Online
- Access to a personal or workplace Microsoft account (an email address and password that you use with Outlook.com, Hotmail, Office, OneDrive, Skype, Xbox, and Windows)
Pre-work
- Explore the 6 provided EFB-DHA practice file (in myAIM) before attending the course
- Bring real workplace examples to implement what you have learnt
What's Included?
- Comprehensive course notes
- Morning tea, lunch and afternoon tea
- Internet Access
Please advise AIM when booking if you have any dietary or accessibility requests.
Payment Options
We require full payment to be made upfront prior to attending the training. Payment options we offer include:
- Credit Card (Visa/MasterCard/Amex)
- Direct Deposit (EFT)
- Purchase Order
- Payment Plan - zipMoney
Our Facilitators
AIM facilitators are experienced practitioners with a robust mix of academic and practical expertise. We believe the education of the future managers of Australia to be a highly important task. Who is better placed to teach the art and science of management than those with current, daily real-world experience?
Our motto: By managers, for managers.
In-House Training Solutions
Contextualising training engagements for your industry or organisation maximises relevance and increases the transfer of learning into the workplace. Develop team cohesion and achieve your specific business objectives through a shared, in-house learning solution.
AIM’s experienced learning designers develop both accredited and unaccredited learning engagements to build the critical competencies you need for success. Join over 500 organisations creating compelling and engaging AIM tailored learning solutions for industries including Government, Health, Financial Services, Mining, Manufacturing, Construction and more.
> Find out more about AIM's Training Solutions for Organisations
Featured Experts
Vinay Nigam’s refreshing mindfulness-based approach to facilitation relies on invoking each participant’s emotional intelligence, establishing and maintaining a high energy level by engaging the group, gaining their interest, and keeping it fun. Vinay uses a simple, plain-English communication style to lead discussions in complex concepts built around real-life experiences of diverse participants in the group.
