Nigerian Seminars and Trainings

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

business logo

Virtual Training on Big Data Analysis and Dashboard with Microsoft Excel for Business Analysts

By: Tom Associates Training  

Lagos State, Nigeria

03 - 06 Aug, 2021  4 days

Follow Event

  

NGN 139,750

Venue: Online

The Course Contents for Big Data Analysis and Dashboard with Microsoft Excel for Business Analysts is as follows:

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.
Online Aug 03 - 06 Aug, 2021

Registration: 09:00:am - 02:30:am

NGN 139,750.00(VAT Inclusive)
(Convert Currency)

MR ABIODUN TOKI 08033019120

3 – 4 Candidates: 5% 5 or more Candidates: 10%.

Related Courses

Making your Business Blossom in a Suppressive Market: Groundbreaking Action Plans for Cutting-Edge Companies Course Making your Business Blossom in a Suppressive Market: Groundbreaking Action Plans for Cutting-Edge Companies Course

4 days, 21 - 24 Sep, 2021 

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

Tom Associates Training

This courses teaches pungent lessons to any business that will successfully wade through a period when its counterparts are experiencing comatose: How much time managers spend on problem definition, ...

Understanding Business Models Course: Innovations to Deliver Strategic Goals Understanding Business Models Course: Innovations to Deliver Strategic Goals

2 day, 29 - 30 Jun, 2021 

2021-06-29 12:06:00 2021-06-29 12:06:00
Lagos State, Nigeria

Tom Associates Training

Understanding Business Models: Innovations to Deliver Strategic Goals is a robust opportunity to plan for the future of the business. Course Contents Day One Creating New Models Central focus of ...

Virtual Training on Building and Sustsaining a Succesful Enterprise Virtual Training on Building and Sustsaining a Succesful Enterprise

4 days, 22 - 25 Jun, 2021 

2021-06-22 12:06:00 2021-06-22 12:06:00
Lagos State, Nigeria

Tom Associates Training

What this course presents: Set right strategy Beat powerful competitors Get funding for new growth initiatives Be relentlessly innovative. Course Contents Day One Foundation for a Successful ...

Current Good Manufacturing Practices (cGMP) Course Current Good Manufacturing Practices (cGMP) Course

4 days, 24 - 27 Aug, 2021 

2021-08-24 12:08:00 2021-08-24 12:08:00
Lagos State, Nigeria

Tom Associates Training

Current Good Manufacturing Practices are, in some countries, enforced regulations for systems that assure proper design, monitoring, and control of manufacturing processes and facilities. Even where ...