ECARE Software Up-skill Workshop

Excel Advanced Course

Course Overview

Excel is considered the No.1 software used in the workplace and has a wide range of applications. As a result, it cannot be ignored. The Assistant Accountant, Financial Accountant, Management Accountant, Business Analyst, Finance Manager and Financial Controller work closely with Excel every day. How quickly and efficiently you can get your work done depends largely on your Excel skills. According to feedback from several industry professionals, proficiency in Excel skills allows for recognition by colleagues and supervisors and can also lead to promotion opportunities.

Ecare offers exclusive Excel courses with varying degrees of difficulty: intermediate and advanced. In the Ecare Advanced course, we will be building on the basics we covered during the intermediate courses so our students will be able to read more high-level functions and formulas. We will teach you to use the PivotTable, to analyze financial data, to perform efficient data entry and output work, and to master Macro’s to enhance working efficiency. Our instructors have several years of experience working for some of the biggest companies in their industries – they combine their theoretical and practical knowledge to provide the best education for our students.


4 Hours * 2 Sessions

Sydney | Melbourne | Online

Corporate Intermediate Position (Large Company) Package:

Fundamental+AA+Excel Intermediate+SAP for All-rounder (Bonus:One-to-one Service + Workshop Voucher)

Save $800

Corporate Intermediate Position (Small&Medium-sized Company) Package:

Fundamental+AA+Excel Intermediate (Bonus:One-to-one Service + Workshop Voucher)

Save $400

Summer Career Preparation Package:

Fundamental+AA+Excel Intermediate (Bonus:One-to-one Service + Workshop Voucher)

Save $400

Course Structure

Session 1 – Pivot tables and more advanced functions

• Review of prerequisite knowledge for this course
• Pivot Tables & Charts: Create, edit, report and format Pivot Tables/Charts.
• Advanced Functions: Logical Functions, SUMIF, COUNTIF, VLOOKUP, HLOOKUP, etc.
• Workgroup Tools: Resolving conflicts, merging changes from a shared workbook
• Names, Views, Scenarios & Reports: storing data displays, Report Manager

Session 2 – Macro’s, basic VBA programming and MS Query

• “Macros”: Recording and running a Macro, visual basic editor, basic VBA programming
• What-if Analysis: Goal Seeker, The Solver, Data Tables
• Efficiency tools: Using Outlining to hide columns and rows, create and modify styles
• MS Query and importing text: Extracting data using MS Query, importing data from Text files
• Excel and web use: Save workbooks as web pages, web queries

Course Cycle

2-weekend study, 8-hour study in total

More Success Stories

For more course information

Please call +61 3 9939 4134

      Suite 601, Level 6, 303 Pitt St, Sydney, NSW, 2000
        (1 minute walk from Town Hall Railway Station)
       +61 4 1226 9477
     +61 2 8018 4717
     +61 2 8458 5328
      Suite 204, Level 2, 546 Collins St, Melbourne, VIC, 3000
        (1 minute walk from Southern Cross Railway Station)
        +61 4 2366 1292
      +61 3 9939 4134
     +61 3 4206 7751