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

05 - 07 Dec, 2018  3 days

Follow Event

  

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
(Convert Currency)

Mr Abiodun Toki 08033019120

3 – 4 participants: 5% discount 5 or more participants: 10% discount
NST PPC Advert
Related Courses
Financial Modeling and Forecasting Techniques using Advanced Excel Tools Course Financial Modeling and Forecasting Techniques using Advanced Excel Tools Course

5 days, 24 - 28 Feb, 2020 

2020-02-24 12:02:00
Lagos State, Nigeria

Tom Associates Training

Modeling techniques that this course teaches are used in investment appraisal, capital planning, budgeting, valuation, financial analysis, and forecasting to make accurate financial and business ...

Critical Thinking Skills For Decision Making Course Critical Thinking Skills For Decision Making Course

3 days, 04 - 06 Mar, 2020 

2020-03-04 12:03:00
Lagos State, Nigeria

Tom Associates Training

This programme delivers Problem Solving Techniques, one of the unique competencies all managers, whether budding or experienced, must possess. The ability of a manager to solve problems will be ...

Mastering Tax Administration Course Mastering Tax Administration Course

4 days, 11 - 14 Feb, 2020 

2020-02-11 12:02:00
Lagos State, Nigeria

Tom Associates Training

In recognition of the difficulty accounting officers often encounter when dealing with and preparing tax computations and returns, this course has been specially designed to assist candidates to ...

Business Process Improvement Programme Business Process Improvement Programme

3 days, 17 - 19 Feb, 2020 

2020-02-17 12:02:00
Lagos State, Nigeria

Tom Associates Training

The common analogy for ease in understanding Business Process Improvement is the fine-tuning of a car's engine. The outcomes are: Quality of output Elimination of waste of efforts and resources ...