Wedemic

Unleash the Power of Powerpivot 2010 for Data Insights

For powerful, rapid, highly visual business intelligence reporting.

5 STUDENTS ENROLLED

In-House sessions are available upon request.

 

Course Overview:

In this Excel course, you will be using Power Pivot and Pivot table as the primary functions to create a dashboard. Power Pivot is a new function in Excel 2010 that works hand in hand with the all too familiar Pivot Table. Power Pivot can analyse multi-million rows of data seamlessly, combine multiple sources of data into one. It also comes with the new Slicer features as well as DAX formulas that make insightful, professional looking Dashboard Reports creation a breeze.

 

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:

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

Course Curriculum

Section 1: Creating an Interactive Title for Management Report
Section 2: Importing Data from multiple sources using Excel Power Pivot
Section 3: Creating and linking slicers to Power Pivot Table
Section 4: Displaying selected Historical Data with Power Pivot
Section 5: Using DAX formulas and Measures in Power Pivot
Section 6: Creating an interactive line and column chart in Excel
Section 7: Auto calculate MTD and YTD Actual and Targets with Power Pivot
Section 8: Activating and using the highly interactive Excel Camera
Section 9: Automatically display the Top 5 products/customers/categories with Power Pivot
Section 10: Using Coloured Bands in charts for benchmarking
Section 11: Turning on PowerPivot auto-refresh function
Unleash the Power of Powerpivot 2010 for Data Insights (2-Day) 14:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
Clear
  • SGD 800
  • 2 days
  • 1 Units
  • 840 Minutes
  • Wishlist

Enrol With Confidence


PayPal Acceptance Mark

Registration Support

If you require further assistance on registration matters, email to registration@wedemic.com

In-House Enquiry

Achieve higher ROI with your training budget with In-House trainings, email to inhouse@wedemic.com
everydayExcel Business Lab is a training company offering Professional Microsoft® Excel Courses with a Business Perspective. We tailor-made Excel courses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resource, administration, business development, etc. Our excel course trainers are not just Masters of Excel who teach people how to use Excel. They are business analysts who can naturally appreciate the decisions made in businesses and the common business problems encountered and at the same time able to make expert use of what is available in Excel to solve analytic and reporting issues in business. Bottom-line for our client is always about how we can use Excel in a way to save a great deal of time and resources for the business. At EverydayExcel, we don't teach people how to use Excel as an end in itself. We teach people how to use it as a means to an end; that to apply the skills and techniques in solving solve their various business problems. For us, there is a huge difference in the two. We do not set out to train people to become gurus in using Excel who are unable to apply it to real-life business situations. We engage with our training participants in such a way that they are triggered to relate what they learn in Excel to their business problems that they face, and then go step by step to tell them how to approach them by creating powerful solutions in Excel. About Your Chief Trainer: Jason Khoo is the author of the two books "Excel Secrets for Highly Effective Marketers", "Hidden Secrets of Data Analysis with Excel" which are sold in all the major book stores in Singapore and in online Amazon. An expert in spreadsheets and databases, Jason also founded SynergyWorks, a consultancy firm which has helped many companies extract valuable information from databases using Microsoft® Excel. He has helped companies save significant amount of money by providing solutions using existing PC applications such as MS Excel instead of purchasing new systems. His clients include multi-nationals corporations such as Discovery Asia, 3M, NCS, Cold Storage, Nippon Paint Singapore, Heinz Asean, Tanah Merah Country Club, and etc.
More Courses by everydayExcel Business Lab