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.