Excel Advanced (A)    (941)

Advanced Functions and Productivity Tools

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.

Overview

This program introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.

Program Content

  • Advanced functions
    • Logical, lookup and reference, statistical, date and time
  • Outlining
    • Creating and using outlines to summarise worksheet data
  • Database operations
    • AutoFilter and advanced filter
    • Sorting data
    • Subtotal command and subtotal function
  • Creating and manipulating PivotTables and PivotCharts
  • Macros
    • Recording and running macros
    • Adding toolbar buttons
    • Viewing the VBA code
  • Consolidating worksheet data
    • Combining data from different worksheets
  • Hyperlinks
    • Creating Hyperlinks to files, web pages or to locations in the workbook.

Learning Outcomes

Participants should be able to:
  • Use advanced functions and productivity tools to assist in developing worksheets
  • Manipulate data lists using outline, autofilter and PivotTables
  • Use consolidation to summarise and report results from multiple worksheets
  • Record repetitive tasks by creating macros
  • Use Hyperlinks to move around worksheets.

Assessment

Additional fee applies for assessment (1 unit of competency).

$210 Non Member

$175 Corporate/Professional Member

Relationship to Competency Standards

BSB41015
Certificate IV in Human Resources
  • BSBITU402 Develop and use complex spreadsheets
BSB40215
Certificate IV in Business
  • BSBITU402 Develop and use complex spreadsheets

Please click on the qualification link above for Qualification information and total fees.

  • Program code 941
  • Duration 2 days
    Residential:No
  • Time 9:00 AM - 4:30 PM
  • Dates
    • 28 - 29 August, 2017
    • 14 - 15 September, 2017
    • 05 - 06 October, 2017
    • 26 - 27 October, 2017
    • 09 - 10 November, 2017
    • 13 - 14 December, 2017
  • Location AIM WA Floreat
* Minimum numbers are required for program to proceed
Calculate your ROI

Estimate the potential returns from your investment in an AIM WA training program.

Go Calculate

Make a Booking

Non Member
$995
Professional Member
$846
Corporate Bronze
$846
Corporate Silver
$796
Corporate Gold
$746
Waitlist only
Limited spaces
Please contact AIM WA Client Services on (08) 9383 8000 for booking information.

*Prices Include GST

More Excel Programs

  • Excel KPI Dashboards

    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.

     
  • Excel Macros - Making life easier with macros

    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.

     
  • Masterclass Excel

    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...

     
  • Excel Intermediate

    If you have used Microsoft Excel for some time and need to learn more, this program provides you with additional skills. Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work with functions such as IF and VLOOKUP. To benefit from this program you should be a confident user of Excel.

     
  • Excel Macros (VBA) Introduction

    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.

     
  • Excel Essentials

    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.

     
  • Excel Advanced (B)

    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.

     
  • Excel Macros (VBA) Advanced

    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.

     
  • Excel Visual Tools

    This program introduces additional skills to develop your knowledge of Microsoft Excel by focusing on pivot tables, charts, SmartArt diagrams and conditional formatting.

     
Make an Enquiry