Participants should be able to:
Estimate the potential returns from your investment in an AIM WA training program.
EOFY discounted rates have been applied.
Valid until 30 June 2017
*Prices Include GST
If you need to quickly and accurately make sense of your Company's raw data, this is for you. We introduce you to Key Performance Indicators (KPIs) and dashboard design processes, and help you build an interactive KPI Dashboard. You will learn how to handle raw data, use functions to create performance metrics, and build mini charts, pivot tables and pivot charts typically used in dashboards.
Are you looking for opportunities to work smarter and not harder? Perhaps strengthening your MS Excel skills using macros is the next step. We all use macros every day, but they are designed by people who have never seen how you operate. What if we can teach you to automate your spreadsheets so that the macros work for you? Macros can eliminate error, reduce repetition in work and generally just make life a lot easier for you.
These highly personalised training sessions enable you to combine your advanced skills in Excel, Word, PowerPoint or Project with the expertise of one of our Master Trainers. Together you can work on a specific task or assignment from your workpla...
During this introduction to Microsoft Excel Macros you learn how to create and edit macros by writing VBA code using the Visual Basic Editor. We teach you the concepts of object oriented programming, how to build user-defined Excel functions and how to use events to trigger VBA procedures. This program is for those who have used the macro recorder and want to extend their knowledge.
Do you need to create or modify spreadsheets using Microsoft Excel? In this program you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations. If you use computers but are new to Excel or don't have much experience with Excel, then this program is for you.
This advanced program shows how to work with databases in Microsoft Excel (using filtering, sorting and subtotals). It introduces pivot tables, macros and hyperlinks and teaches logical, lookup, reference and statistical functions. If you are experienced in designing and modifying spreadsheets, can write formulas and have worked with IF and VLOOKUP functions, this is for you. This program follows on from AIM WA's Excel Intermediate program.
This second advanced program in Microsoft Excel introduces data analysis and explains goal seeking, scenario manager and solver. You will work with advanced functions, learn about arrays and functions and create interactive spreadsheets using on-sheet controls. If you have experience in Excel, can write formulas and have worked with IF and VLOOKUP functions, this program is for you. It follows on from AIM WA's Excel Advanced A.
This program is for high-end users who want to make the most of the power of Microsoft Excel. It introduces programming techniques and concepts such as variables, scoping, importing data, passing values and debug techniques. If you have experience with the macro recorder and with programming to the level of AIM WA's Excel Macros (VBA) Introduction, you will benefit from this program.
This program introduces additional skills to develop your knowledge of Microsoft Excel by focusing on pivot tables, charts, SmartArt diagrams and conditional formatting.
To book into
please login below