Hunter Jiang's Consulting Blog

Interview, Resume , Promotion , Excel , Power BI, DAX, Power Pivot and TM1

Menu

Act vs Bud OLAP Modelling

This course is designed for financial professionals who need to explore the practical usage of advanced excel functions in a financial processing. By creating your own user-friendly financial model, you will learn to translate financial data s into a structured information to identify weaknesses and predict future performance.

Hunter has designed and delivered many practical hands-on step by step training courses to accelerate the acquisition of financial management skills. As well as identifying key financial concepts in budgeting, reporting and analysis, he supports this knowledge with many simple and sophisticated Excel models. He also has the ability to access complex BI and reporting tools and make them come alive in common sense ways which can be replicated by the learner back in the office environment.

This course is part of the Financial Closing Package:

  • GL Standing Journals
  • Month End Procedures
  • Balance Sheet Reconciliation
  • Year End Closing
  • Excel Data Modelling
  • Power BI Data Manipulation

This course is part of the Financial Closing Package:

  • Graduate Accountant
  • Accounts Payable
  • Accounts Receivable
  • Payroll Officer
  • Accounts Clerk/Office
  • Accounts Al-rounder
  • Small Firm Accountant
  • Small Company Accountants

Public courses are run in our training room without workstations provided. Participants need bring their own laptops.   The course is demonstrated using Microsoft Excel 2016, but participants can use Excel 2007, 2010 or 2013 if they prefer.  Course materials contain instructions for different versions, and Excel 2011 for Mac users are also catered for. But window system will be needed if you attending SAP-ERP tutorials.

一对一免费咨询登记表

  • This field is for validation purposes and should be left unchanged.

Scan the QR code to book your first face to face Free Trial Now !!!

Our Solutions
Weixin Linkedin Facebook Youtube
  1. Appending Tables through an indirect method
  2. Dynamic Control MTD and YTD
  3. Dynamic Control over trend analysis
  1. Appending Actual and Budget from worksheets
  2. Appending Actual and Budget from folders
  3. Merge Actual and BudgetCOA with account group category
  1. Automate Act vs Bud with cubevalue in OLAP environment
  2. Apply cubevalue with Slicer in OLAP environment
  3. Apply cubevalue with DAX YTD calculation  in OLAP environment
  1. How to create set based view in power pivot
  2. Apply  Cubeset Formula with using slicers
  3. Apply  Cubeset when grouping and Summarizing Data
  1. Redirect Cubemember  to hard coded cell
  2. Use CUBERANKEDMEMBER to extract the set items
  3. Use CUBERANKEDMEMBER to rank the set items

Comments from past students

The course was very practical with many Excel models and examples. Each of the key concepts was explained and then quickly applied in the classroom. The presenter was accomplished and I now feel confident in this area. Data Manipulation Using Excel Course
MARTIN C.
MARTIN C.BUSINESS ANALYST
“The course was very practical and will help me in into a new role I have just been promoted to. The presenter was enthusiastic and kept the class engaged. I feel confident that I can improve my work when perform the next month’s work..” P&L Review Course
Rain Wan
Rain WanBUSINESS ANALYST
“I have never had the main accounting concepts explained in such a simple way. The 2 days of demystification have opened up my mind as to how to bring the financial dimensions to managing the business. I was particularly informed by the session on monitoring the actual v budget reports.”
Roxie Ni
Roxie NiFINANCIAL ACCOUNTANT
“The course had a fresh approach and was very interesting. The case studies and readings were excellent. The presenter was engaging.” Financial Forecasting Course
Michele Meng
Michele MengBUSINESS ANALYST
“The course was very practical with task ready Excel spreadsheet models. The classroom presentation exercise was very relevant and I used this the following week at work and gained a promotion.” Cash Flow Forecasting Course
Wenny Guo
Wenny GuoFinance Manager
“ The presenter did a great job of presenting the material in a clear and understandable way. The practical exercises were well chosen. The presenter demonstrated his expertise over and over again. I cant wait to apply the new knowledge at work.”
JOYCE CAI
JOYCE CAICommercial analyst
Previous
Next
Medium to Advanced Level Excel Modelling Skills:
90%
Installation of SAP-ERP in your PC :
85%
Best Practice of Australia listed companies :
80%
Entry Level Power BI Modelling Skills:
67%
All year round 24 hours CPD Certification:
50%

In This Class You’ll Get to…

Free Consulting

Our experienced consultant’s will help you identify the skill gaps for your next move.

CPD Certificate

A formal company letter will be issued to you after class to help you claim your CPD hours.

Resume Edit

Our experienced consultant’s will help you edit your resume before you apply for the target role.

Contact Us

  • This field is for validation purposes and should be left unchanged.

Get in touch!

Opening Hours

Feel free to call us at any time. We can be reached during normal business hours at: 0499 180 115.

Tue - Fri: 10AM - 6PM
Saturday: 9:30AM - 5:30PM
Sunday: 9:30AM - 5:30PM
Monday:Closed

IFA Australia

IFA Australia is committed to transform the lives of the accounting professional by accelerating their skills and knowledge acquisition.

IFA Austrlia is a practical guide for accountants to transform themselves into valued business partners.