Automation is the buzz word in today’s corporate world. Whether it is manufacturing industry or the service industry, all businesses are aiming to reduce the human element for critical processes and tasks to improve efficiency and output.

As a finance aspirant, you will see this trend in finance companies as well. Calculators are replaced by laptops, ledgers are replaced by spreadsheets and hard bound documented financial models are replaced by dashboards.

Excel comes with the most astonishing tools when it comes to financial modeling. Explore the options in order to fully utilize the potential offering in excel. There are so many commands and functions which, not many people know, but are embedded in Excel and can yield excellent results if utilized properly.

This course offers quick tips to improve functionality, spreadsheet formatting, data searching and calculations amongst large data sets within Excel. The training will provide an introduction to data analysis, reporting tools, data manipulation and searching, plus an insight into simple automation of tasks using macros and VBA programming.

Certification by PEAK SUCCESS ABUNDANCE – Graduates Your Colleagues

Certification by PEAK SUCCESS ABUNDANCE – With Thanks

Congratulations on Completing the Training by PEAK SUCCESS ABUNDANCE

At the end of this course, you will learn to:

  • Initiate the new add-in tab for better interaction of enormous data base
  • Acquire skills to link external data sources
  • Create relationships between different tables so as to generate one pivot table report easily
  • Use the features in Power Pivot to analyze periodic reports easily
  • Interact with different data sources effectively

Executives, Managers

1. INTRODUCTION

  • Why Power Pivot?
  • How it works?
  • Installing Power Pivot

2. DATA LOADING TO POWER PIVOT

  • Preparing data
  • Import data from:
    •  Excel Tables
    •  Excel data sources
    •  Text files

3. DATA LOADING TO POWER PIVOT

  • Data formats
  • Sheets and Columns
  • Editing and Adding data
  • Table Properties
  • Filtering and Sorting

4. WORKING WITH MULTIPLE TABLES
Understand and define the rules of relationships:

  • Auto detect and edit the relationships
  • Work with multiple relationships
  • Working in Diagram View

5. CREATE POWER PIVOT TABLES

  • How to begin with?
  • Formatting the tables
  • Filter and sorting options
  • Grouping dates
  • Arranging and Formatting Slicers

6. INTRODUCTION TO FORMULA AND DATA ANALYSIS EXPRESSION

  • Calculated Columns, similar to Excel Table
  • Use Functions in Power Pivot
  • RELATED Function
  • Aggregation Functions
  • Recap Formulas Rules
  • Introduction of DAX and how to measure the data:
    • „CALCULATE
    • COUNTROWS
    • „FILTER
    • „DISTINCTCOUNT
    • „ALL
    • ALLEXCEPT

7. TIME INTELLIGENCE FUNCTIONS

  • Date / Calendar Tables
  • Explore time intelligence functions:
    • „PREVIOUSYEAR
    • „DATEADD
    • „DATEDSYTD & TOTALYTD
    • „% Year on Year & Error Handling

COURSE METHODOLOGY

Please bring your laptop, hands-on practical sessions. Highly practical, easy to understand/apply with demonstrations, question & answer session, discussion, presentation, relevant exercise, revision sessions for total complete understanding

JOANNA KOK YEE LAN

Joanna Kok Yee Lan is a certified PSMB Trainer & certified MIM Trainer. She is also a Certified Accountant. She has conducted many trainings on various areas & aspects of finance including topics on Finance For Non Financial Executives, Budget Planning & Control, Financial Planning & Control, Evaluating Financial Statements, Financial Analysis, Preparing Full Set Of Accounts.

Joanna who graduated as a certified accountant (FCCA) from United Kingdom, also has 8 years experience in audit, manufacturing & investment holding businesses. She has accumulated vast, hands-on working experiences in strategic, organizational analysis & planning. The role as Financial Controller has best utilized her managerial, operational experience & financial analysis skills. She stepped up the controls in the area of credit, inventory & business processes that had generated millions of cash inflow and cost savings to the businesses. Her 3 years experience in China of setting up the joint venture business has added her strengths on business & financial controlling skills.

Currently, Joanna is a freelance technical & training consultant. She speaks on MASB standards & accounting and audit issues regularly and extensively throughout Malaysia for both MIA (Malaysian Institute of Accountants), ACCA and CPA Australia. In addition, she also conducts technical in-house training on accounting issues for commercial companies and training institutions.

Her exposure & passion in people development enhance the quality of training & making each one of them unique and experiential. Her fun & energetic personality has made her training sessions practical, high learning spirit & performance orientated. Along with that she has completed the Train the Trainer Program conducted by PSMB & MIM.

Her assertiveness & resourcefulness has driven her venturing into training and consultancy fields. She has conducted many trainings on financial for non-finance executives, project management, inventory management & finance related topics. Her financial, analytical and controlling experiences have actually contributed greatly to making the training sessions very practical & performance orientated.

Her exposure & passion in people development enhance the quality of training and making each one of them unique and experiential.

Joanna always receives excellent ratings & comments from the participants she trained in. This is because she is able to take a complex subject like finance & accounting and is able to make it easy for participants to understand. She is able to make the training enjoyable, captivating & interesting while imparting her extensive knowledge on finance & financial matters. She uses lots of case examples, case studies, exercises, activities, group discussions & brainstorming sessions to make sure participants understand what is being taught.

Her Training Topics include:

  • Finance Analysis & Planning
  • Finance for Non Financial Executives
  • Inventory Management
  • Financial Wisdom in Interpreting KPIs
  • Working Smart with Excel
  • Effective Budget Planning & Control Using Excel
  • Application of Microsoft Project
  • Basic Project Management
  • Credit Management
  • Targeted Selection

Her List of Clientele includes:

  • ASMC (MBA Program)
  • Telekom Bhd
  • Padibernas Nasional Bhd (Bernas)
  • IBM China
  • Logistik Konsortium Bhd
  • PJ Bumi Bhd
  • Sime Darby Bhd
  • Malaysia Airports Holdings Bhd
  • University of International Agama Malaysia
  • Hualon Group
  • Selangor Human Resource Development Centre (SHRDC)
  • Iverson
  • Syncoates Sdn Bhd
  • Infineon Technologies (Kulim) Sdn Bhd
  • Utusan Malaysia