Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Big Data Analysis and Dashboards with Microsoft Excel for Business Analysts

By: Tom Associates Training  

Lagos State, Nigeria

11 - 13 Apr, 2017  3 days

Follow Event   

  

NGN 115,500

This Big Data Analysis and Dashboards with Microsoft Excel for Business Analysts training courses will discuss the following.

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
  • Power Pivot for Data Mining (Excel 2013 or 2010 with Power Pivot Addin)
  • Working with data of over 2 million rows
  • Connecting with multiple sources of data
  • DAX formulas
  • Most popular Power Pivot Analysis.
  • Power Query
  • Understanding what Power Query is
  • Simple practical uses
  • Using it to connect to third party data sources (your ERP or Database).
  • Power View
  • Understanding what Power View 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, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Registration: 8.30 - 9.00 a.m. Class Session: 9.00 - 4.00 p.m. Apr 11 - 13 Apr, 2017
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Registration: 8.30 - 9.00 a.m. Class Session: 9.00 - 4.00 p.m. 28 - 30 Aug, 2017
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Registration: 8.30 - 9.00 a.m. Class Session: 9.00 - 4.00 p.m. 06 - 08 Dec, 2017
NGN 115,500.00(Including VAT)
(Convert Currency)

08033019120

Discount of 5% to 3-4 participants from same organization. Discount of 10% to 5 or more participants from same organization.
Related Courses
Smarter Presentation and Persuasive Public Speaking Skills Smarter Presentation and Persuasive Public Speaking Skills

3 days, 04 - 06 Oct, 2017 

2017-10-04 12:10:00
Lagos State, Nigeria

Tom Associates Training

The Smarter Presentation and Persuasive Public Speaking Skills training addresses Sales presentation Proposals presentation Reports presentation. Participants also practice Technical lecture ...

How to Create Positive Customer Experience: Service as an Art and a Science How to Create Positive Customer Experience: Service as an Art and a Science

2 day, 21 - 22 Sep, 2017 

2017-09-21 12:09:00
Lagos State, Nigeria

Tom Associates Training

This training is to make employees psychologically ready, supported with the skills-set to deliver impeccable customer service. After the programme, employees will be able to attend to more service ...

Prosperous Retail Business: The Essential Salesmanship and Customer Service Prosperous Retail Business: The Essential Salesmanship and Customer Service

3 days, 26 - 28 Jul, 2017 

2017-07-26 12:07:00
Lagos State, Nigeria

Tom Associates Training

This course is structured to take retail sales outlet team through: How to increase their mental agility so as to perform always at the very best How to bring high energy to bear for top performance ...

Preventive Maintenance Course Preventive Maintenance Course

5 days, 04 - 08 Dec, 2017 

2017-12-04 12:12:00
Lagos State, Nigeria

Tom Associates Training

Preventive maintenance takes proactive and organized actions to ensure that the plant will continue to function optimally to effect the achievement of planned results as per production schedule and ...