
NEED TO UNDERSTAND EXCEL?
Are you new to Excel or have very little or no knowledge of how to even begin?
Do your staff struggle with spreadsheets, formulas and sorting data?
Then join us for our comprehensive 4 session Excel self-study series!
SESSION 1 - Introduction to Excel: First Time User (Beginner)
Welcome to Excel! The objective of this session is to enable learners to open and create Excel workbook files, use the 2016 interface, format worksheets and data, and become comfortable with the Excel interface.
SESSION 2 - Exploring & Creating Formulas (Novice)
Excel has powerful formula functionality. The goal of formulas is to automate processes that would require manual execution. Formulas are used to save you time and give you the edge when completing daily tasks. Join us as explore basic formulas and attempt to increase your efficiency with helpful formulas that you will need daily in an office space.
The objective of this session is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a finance environment.
SESSION 3 - Data Filtering, Sorting, Searching, Editing & Extraction (Intermediate)
Need to make informed decisions but feeling overwhelmed with too much information to get through? Excel is geared towards processing large amounts of data with minimal fuss. In this session we empower your decision making by helping you organize and sift through data with efficiency, using an array of formulas, filtering functionality, data searching and extraction tools.
The objective of this session is to enable delegates to become comfortable with working with populated Excel sheets and sifting through copious amounts of data, turning data into logical information and performing search queries and only returning desired information.
SESSION 4 - Pivot Tables, Tables, Graphs & Creating Visual Reports (Advanced)
Sometimes it is easier to understand something when it is represented in pictures or some other visual medium. This also helps when making decisions, analysing trends and reviewing results. Excel is bursting at its seams with all kinds of techniques to visually represent data in a way that is organised and easier to digest. Numbers can be a bit overwhelming sometimes, so join us as we explore various ways numbers/data can be organised and simplified by converting them into graphs, tables and other visual reports to help with decisions.
The objective of this session is to enable delegates to become comfortable with using visual aids within Excel and turn copious amounts of data into a visual expression, to perform better decision making.
All Included:
Use this section to build trust and create a personal connection with your customers. The more a prospective customer knows about you, the more likely they are to purchase from your store. Use this section to explain why your store is the best place to purchase the type of goods you sell. Be sure to highlight the things that make your products and services unique. For example, are your items made locally, sourced from special ingredients or customized? This is the place to tell your customers how great your products and services are. Leave a memorable impression that makes them want to tell their friends about you and come back for more. Free shipping? Do you support a charity? Let them know here!
Gary Garbutt,
Head of Operations
Biz Facility Pty Ltd
(Registration number: 2011/105349/07)
Mission Statement:
To provide value added skills and tools through superior training and engagement that enables our clients to become more financially skilled.
Our Vision:
To provide practical skills and tools to small and medium business owners and individuals, in order to effectively utilize accounting data to manage their business or area of operation, and to effectively manage their tax obligations, both personally and professionally.
Biz Facility, founded in 2010, was founded to provide practical training interventions to small and medium sized businesses, as well as individuals, to equip clients in managing their business’s and tax affairs more effectively.Biz Facility provides both training and financial services to its clients: