|
Big Data Analysis and Dashboards with Microsoft Excel for Business Analysis Course
NGN 125,000
|
Venue: 5/7 Alade Lawal Street, off Ikorodu Road, Anthony Village, Lagos
This Big Data Analysis and Dashboards with Microsoft Excel for Buisness Analysis 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
- Linking sheets
- Duplicating sheets (better than copy and paste)
- Inserting sheets, labeling and coloring the professional way
- Freezing Panes and splitting windows
- 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
- 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.
5/7 Alade Lawal Street, off Ikorodu Road, Anthony Village, Lagos | Dec 05 - 07 Dec, 2018 |
Registration: 08:30:am - 09:00:am
Class Session: 09:00:am - 04:00:am
NGN 125,000.00 | |
Mr Abiodun Toki 08033019120
3 – 4 participants: 5% discount
5 or more participants: 10% discount
Related Courses

5 days, 24 - 28 Feb, 2020
Tom Associates Training

3 days, 04 - 06 Mar, 2020
Tom Associates Training

4 days, 11 - 14 Feb, 2020
Tom Associates Training

3 days, 17 - 19 Feb, 2020
Tom Associates Training