Issue - November 2013
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!
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.
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.
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.
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.
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.