Unleash The Power of PowerPivot 2010 For Data Insights
Details
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 ObjectivesThrough 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.
- Creating an Interactive Title for Management Report
- Importing Data from multiple sources using Excel Power Pivot
- Creating and linking slicers to Power Pivot Table
- Displaying selected Historical Data with Power Pivot
- Using DAX formulas and Measures in Power Pivot
- Creating an interactive line and column chart in Excel
- Auto calculate MTD and YTD Actual and Targets with Power Pivot
- Activating and using the highly interactive Excel Camera
- Automatically display the Top 5 products/customers/categories with Power Pivot
- Using Coloured Bands in charts for benchmarking
- Turning on PowerPivot auto-refresh function
Price and Duration
S$800 per pax for this 2 days course.
In a typical Excel course, participants are just taught the A to Z on the formulas and functions, for the purpose of passing the certification tests. After attending these courses, the participants are left on their own to figure out how to apply the formulas and functions effectively in their unique work situations. Some took months and years to accomplish this, but many never ever discovered how. We decided to fill the gap by offering our courses tapping on our Excel experiences, from our Excel-related work experience accumulated over the years (since Lotus 1-2-3 days) and regular consulting work done with companies such as Discovery Asia, Johnson and Johnson, EQ Insurance, DP Architect, etc.
WHY SHOULD YOU CONSIDER OUR COURSES?Unlike the gamut of basic, intermediate and advanced Excel courses geared towards achieving high score for the test given at the end of the training, our solution-based Excel courses work through real-life business situations and problems that business users encounter daily in their jobs and share with them quality solutions aimed to improve their work productivity and efficiency. ...
Related Courses
