Menu
Home / Workshops & Seminars
Introduction to Process Automation for Accountants with Power Query and Power Pivot - 2nd Run
LIMITED SEATS

Microsoft Excel is one of the most important computer applications for accountants and finance professionals at all levels.

Power Query (Get & Transform in Excel 2016 and newer versions) and Power Pivot within Microsoft Excel let you connect, gather, transform and combine data very efficiently, which will enable any finance, accounting or tax professional to automate processes that are very manual and repetitive.

This introductory workshop will help you develop the basic skills to start transforming and analysing data with Microsfot Excel Power Query and Power Pivot. Upon completing this workshop, you will be able to get data from various sources, prepare and analyse large amounts of data efficiently using Power Query and Power Pivot. The trainer will be using Profit & Loss, Balance Sheet and POS data in the examples and hands-on exercises to facilitate learning and allow you to directly apply your knowledge gained in the workplace.

Pre-requisites:

  • Basic knowledge of Microsoft Windows operating system and its core functionality
  • Basic knowledge of Excel functions such as IF, SUMIF, VLOOKUP, HLOOKUP
  • Basic knowledge of Excel pivot tables and pivot charts
  • Basic knowledge of relational database
  • Basic knowledge of Power BI

Requirements:

  • Please bring your own laptop (PC only - Power Pivot is not available in Microsoft Excel for Mac)
  • You must have Excel 2013 or newer versions (Power Query has been renamed and became part of Get & Transform in Excel 2016 and newer versions. Instructions to download and install Power Query for Excel 2013 users will be sent in advance)
  • Download and install Microsoft Power BI Desktop prior to the workshop. Instructions will be sent to you in advance.

 Key Topics

Connecting and Transforming Data Using Power Query

  • What is Power Query (M)?
  • Excel workbook
  • CSV
  • Database
  • Folder
  • Web
  • API
  • How do I edit a query?
  • How do I format data?

Advanced Data Transformation Techniques (M)

  • Merge vs append
  • Merge vs data modelling
  • Cardinality
  • Pivot and unpivot
  • Parameter
  • Custom function

Data Modelling and DAX

  • What is data modelling?
  • What are related tables?
  • What is DAX?
  • Traditional Pivot vs Power Pivot
  • Importing a data model to Power BI

Analysing and Visualising Data Using Power Pivot

  • PivotTables
  • PivotCharts
  • PowerView
DATE Tue, 21 April 2020
TIME 09:00:00 AM - 05:00:00 PM
CPE HOURS 7
LOCATION Carlton Hotel Singapore, 76 Bras Basah Road, S(189558)
COST $398 nett per participant (inclusive of course materials, certificate of participation, buffet lunch, tea breaks & refreshments)
PAYMENT METHODS Cheque, bank transfer or cash
SPEAKER
Register Online or Download Registration Form and email/fax to enquiries@takx.com.sg/62939069

Complete registration form below and submit.

Look out for confirmation email with soft copy invoice.

Remit payment by cheque, bank transfer or cash to TAKX Solutions Pte Ltd.

Look out for reminder email closer to workshop date.
PARTICIPANT DETAILS
CONTACT PERSON
Same as above    I have a different contact
* Upon receipt of registration, any cancellation must be confirmed in writing, and will be subject to a 10% administrative charge. If notice of cancellation is received less than 5 working days before the course date, or if participant fails to show, participants will be invoiced for the full fee. However, substitutes will be allowed. TAKX Solutions Pte Ltd reserves the right to cancel/postpone the event or change the venue/date/time of the workshop in view of unforeseen circumstances.