Unleashing the Power of Powerpivot for Data Insights

Who Should Attend

This course is specially tailored for business managers and executives who are responsible for preparing management reports and are seeking new perspectives to enhance and add value to their presentation. Participants must have attended everydayExcel.'s Hidden Secrets in Data Analysis with Excel Course or possess advanced knowledge about Excel. Advanced Excel users are defined as regular users of VLOOKUP worksheet function, complex functions (formulas within formula), Pivot Table, etc.

Learning Objectives

Through the development of a Monthly Performance Report, you will learn how to:

  1. Establish and connect data from multiple sources such as SQL, SharePoint, Excel workbooks, CSV files and Excel Tables.
  2. Apply the new DAX formulas in Power Pivot.
  3. Create Slicers and enhance the report's interactivity.
  4. Prepare Impressive charts and tables for reporting.

Course Outline

  1. Creating an Interactive Title for Management Report
  2. Importing Data from multiple sources using Excel Power Pivot
  3. Creating and linking slicers to Power Pivot Table
  4. Displaying selected Historical Data with Power Pivot
  5. Using DAX formulas and Measures in Power Pivot
  6. Creating an interactive line and column chart in Excel
  7. Auto calculate MTD and YTD Actual and Targets with Power Pivot
  8. Activating and using the highly interactive Excel Camera
  9. Automatically display the Top 5 products/customers/categories with Power Pivot
  10. Using Coloured Bands in charts for benchmarking
  11. Turning on PowerPivot auto-refresh function
04 & 05 Apr 2019Confirmed
15 & 16 Aug 2019Confirmed
17 & 18 Oct 2019Confirmed

Time: 9am - 5pm
Duration: 14 Hours (2 days)

Venue: International Plaza
10 Anson Road #26-02A

Course Fees: S$800 per pax

Price and Duration

S$800 per pax for this 2 days course.

Our Trainers

EverydayExcel' trainers are all experts in spreadsheets and databases. They are specially hand-picked by the Chief Trainer, Jason Khoo, based on their experiences in training and the business knowledge they possess. Jason has worked in local listed companies and foreign MNCs managing the companies' budgeting process and developed business models for forecasting. He was also a financial counsel for a Fortune 500 company's business unit which generated a total revenue of more than S$100 million per annum.

EverydayExcel has helped many companies save thousands of dollars by providing simple and yet powerful business solutions through the use of Microsoft® Excel. Examples of such solutions include budget planning and forecasting, customer segmentation program, personalized email broadcast to targeted customers, and sales lead generation program (mini CRM), etc.

Download Excel PowerPivot Course Registration Form

« Back to Excel courses