This programme can run as an online or classroom training
(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS MUST BE WITH THEIR COMPUTERS)
Course Contents
DAY ONE
• Subtotal Application
• 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
- Sensitivity Analysis
DAY TWO
Advanced Pivot Table tricks.
• PowerPivot for Data Mining (Excel 2013 and above 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.
DAY THREE
• 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
- Linking sheets
- Duplicating sheets (better than copy and paste)
- Inserting sheets, labeling and coloring the professional way
- Freezing Panes and splitting windows
- Conditional formatting
o To identify patterns
o Using formulae
o To make extremely intelligent reports
• Absolute and Relative Cell addressing to make effective formulas
• Dashboards
• Having the audience/recipient in mind.
DAY FOUR
• E-mails and Excel reports
• Excel to PowerPoint
- Linking PowerPoint Charts to Excel
- Embedding Excel sheets in PowerPoint
- 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.