everydayExcel Newsletter Header

New Course - Gaining Stunning Business Insights with Excel Power Pivot

In this course, you will be using Power Pivot and Pivot table as the primary functions to create a dashboard. Starting with a single source of downloaded data, the course will make use of the capability of Power Pivot to add on data created with other sources, for instance, CSV, Excel worksheet, Excel Tables, etc. These add-on data, such as budgets, customer categories, etc could be self-generated or downloaded from other systems.

Participants will also learn how to use DAX (Data Analysis Expression) formulas which work hand in hand with PowerPivot. The formulas allow users to include calculations into Pivot Tables that were not available in previous versions of Excel. These include calculations that cross over time periods such as MTD, QTD and YTD.

Participants will also master the use of slicers, a new feature in Excel 2010 and learn how to make the slicers control all the Power Pivot Tables at one go and also individual Power Pivot Tables. The ability to format the Slicers makes it easy for participants to create professional looking dashboard without using Excel's ActiveX controls.

Working around the limitations of PowerPivot and Power Pivot Table, we will share with participants how the trend line which corresponds with the user's selection can be presented. The course also incorporates advanced, powerful and yet relatively unknown formulas that will enhance the interactivity of the dashboard.

Last but not least, besides the typical chart functions in Excel, participants will also learn how to design dashboards that are easy to maintain, simple to read and how to make use of the limited space in a dashboard to create insightful and interactive reports that will be valuable to the management for tracking and/or decision making purposes.

If you are currently using Excel 2010 and have been put in charge of developing a dashboard, Power Pivot may be the answer. Sign up for this new Excel course now and enjoy this time-limit offer!

Ask us an Excel question and get your question answered by our team of Excel experts

Click on this link to post your question.

Question: How to link from Excel to PowerPoint?

I have been fending off requests from participants to show how to link Excel to PowerPoint. This is because I don‘t recommend links across workbooks, let alone across MS Office Applications. But .... 

Click on this link to read the answer.

Upcoming Courses

With the newly introduced PIC bonus, you are now paid (not paying) 60% of the course fees for sending your staff to our courses. Check out now in this IRAS PIC Link.

Hidden Secrets in Data Analysis with Excel 2007/2010 - 23 & 24 Jan 2014 

Interactive Dashboard Reporting with Excel 2007/2010 - 10 & 18 Mar 2014 

Gaining Stunning Business Insights with Excel Power Pivot - 21 & 22 Nov 2013 

Learning the Magic of Macros 2007 (Excel VBA) - 3 & 4 Apr 2014 

Breakthrough Performance for HR in Excel 2007/2010 - 13 & 14 Feb 2014 

Dynamic Real-Time Forecasting with Excel 2007/2010 - 6 & 7 Mar 2014

For the details of the courses, please refer to our Excel courses page.

Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.

Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.

Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"


Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.