(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS MUST BE WITH THEIR COMPUTERS)
Course Contents
DAY ONE
• Pivot Table
 Default Pivot Table
 Tabular Pivot Table
 Pivot Table Filtering
 Making a very dynamic regular table from Pivot Table
 Calculations and Formula use with Pivot Table
 Advanced Pivot Table tricks.
• PowerPivot for Data Mining (Excel 2013 or 2010 with PowerPivot Addin)
 Working with data of over 2 million rows
 Connecting with multiple sources of data
 DAX formulas
 Most popular PowerPivot Analysis.
• PowerQuery
 Understanding what PowerQuery is
 Simple practical uses
 Using it to connect to third party data sources (your ERP or Database).
• PowerView
 Understanding what PowerView is
 Simple practical uses.
• Power Map
 Plotting your data on a live map that can be zoomed and rotated
 Special amazing use of the Power Map.
• Charting Large Data
 Understanding the principles that guide visualizing large data
 Making charts that bring insights to a large data
 Building a large data dashboard.
DAY TWO
• Making Professional Reports in Excel and Dashboards
o Linking sheets
o Duplicating sheets (better than copy and paste)
o Inserting sheets, labeling and coloring the professional way
o Freezing Panes and splitting windows
o Conditional formatting
To identify patterns
Using formulae
To make extremely intelligent reports
Absolute and Relative Cell addressing to make effective formulas
Dashboards
Having the audience/recipient in mind
E-mails and Excel reports.
DAY THREE
• Excel to PowerPoint
o Linking PowerPoint Charts to Excel
o Embedding Excel sheets in PowerPoint
o Making a Powerful PowerPoint Presentation.
• Excel to Word
o Mail Merge: Sending a personalized mail to a list of people
o Linking PowerPoint Charts to Excel
o Embedding Excel sheets in Word
o Copying tables and content from Excel to Word, the right way.
