(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS MUST BE WITH THEIR COMPUTERS)
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.
ï‚§ Understanding what PowerQuery is
ï‚§ Simple practical uses
ï‚§ Using it to connect to third party data sources (your ERP or Database).
ï‚§ 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.
• 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
To make extremely intelligent reports
Absolute and Relative Cell addressing to make effective formulas
Having the audience/recipient in mind
E-mails and Excel reports.
• Excel to PowerPoint
o Linking PowerPoint Charts to Excel
o Embedding Excel sheets in PowerPoint
o Making a Powerful PowerPoint Presentation.
Excel to Word
Mail Merge: Sending a personalized mail to a list of people
Linking PowerPoint Charts to Excel
Embedding Excel sheets in Word
Copying tables and content from Excel to Word, the right way.