(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS MUST BRING THEIR LAPTOPS)
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
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.
Registration: 8.30 – 9.00 a.m.
Class Session: 9.00 a.m. – 4.00 p.m.