Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Big Data Analysis and Dashboards with Microsoft Excel for Business Analysis Course

By: Tom Associates Training  

Lagos State, Nigeria

19 - 22 Mar, 2019  4 days

Follow Event

  

NGN 150,000

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.

DAY TWO

  • 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
  • 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

DAY THREE

  • E-mails and Excel reports.
  • Excel to PowerPoint
    • Linking PowerPoint Charts to Excel
    • Embedding Excel sheets in PowerPoint
    • Making a Powerful PowerPoint Presentation.

Day Four

  • 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 Mar 19 - 22 Mar, 2019

Registration: 08:30:am - 09:00:am

Class Session: 09:00:am - 04:00:am

NGN 150,000.00(VAT Inclusive)
(Convert Currency)

Mr Abiodun Toki 08033019120

3 – 4 participants: 5% discount 5 or more participants: 10% discount
NST PPC Advert
Related Courses
Building Trust and Inspiring Followers Course - Small Behaviours that Create Positive Change Building Trust and Inspiring Followers Course - Small Behaviours that Create Positive Change

3 days, 28 - 30 Oct, 2019 

2019-10-28 12:10:00
Lagos State, Nigeria

Tom Associates Training

This course is relevant mostly when the leadership faces among the followers problems of: Change resistance Lower morale Lack of real effort. Then it's the time the leader must tap into the ...

How to Set Key Performance Indicators (KPI) for Objective Performance Management Course How to Set Key Performance Indicators (KPI) for Objective Performance Management Course

2 day, 30 - 31 May, 2019 

2019-05-30 12:05:00
Lagos State, Nigeria

Tom Associates Training

The process of setting performance standards which can support appraising your employees’ performances against predefined sets of criteria that support the organization’s goals and ...

Public Finance Refresher and Appropriation Programme Public Finance Refresher and Appropriation Programme

5 days, 20 - 24 May, 2019 

2019-05-20 12:05:00
Lagos State, Nigeria

Tom Associates Training

The way public finances are organized in the country forms the basis for how government offices and authorities run their activities. This course will support delegates with much of the ...

Administrative Functions and Office Management Course Administrative Functions and Office Management Course

5 days, 26 - 30 Aug, 2019 

2019-08-26 12:08:00
Lagos State, Nigeria

Tom Associates Training

A training to deliver the requirements of Administrative Officers, so they are brought up-to-date with what is expected of them at all times. The contents will make administrative staff to be highly ...