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 Dashboard with Microsoft Excel for Business Analysts Course

By: Tom Associates Training  

Lagos State, Nigeria

21 - 24 Jan, 2020  4 days

Follow Event

  

NGN 150,000

Venue: 5/7 Alade Lawal Street, Opposite Anthony Police, Off Ikorodu Road, Anthony Village

Other Dates

Venue Date Fee  
5/7 Alade Lawal Street, Opposite Anthony Police, Off Ikorodu Road, Anthony Village, Lagos State, Nigeria 27 - 30 Apr, 2020 NGN155000
5/7 Alade Lawal Street, Opposite Anthony Police, Off Ikorodu Road, Anthony Village, Lagos State, Nigeria 11 - 14 Aug, 2020 NGN155000
5/7 Alade Lawal Street, Opposite Anthony Police, Off Ikorodu Road, Anthony Village, Lagos State, Nigeria 01 - 04 Dec, 2020 NGN155001

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

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 Adin)
  • Working with data of over 2 million rows
  • Connecting with multiple sources of data
  • DAX formulas
  • Most popular PowerPivot 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.

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, labelling and colouring 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, Opposite Anthony Police, Off Ikorodu Road, Anthony Village Jan 21 - 24 Jan, 2020
5/7 Alade Lawal Street, Opposite Anthony Police, Off Ikorodu Road, Anthony Village, Lagos State, Nigeria 27 - 30 Apr, 2020
5/7 Alade Lawal Street, Opposite Anthony Police, Off Ikorodu Road, Anthony Village, Lagos State, Nigeria 11 - 14 Aug, 2020
5/7 Alade Lawal Street, Opposite Anthony Police, Off Ikorodu Road, Anthony Village, Lagos State, Nigeria 01 - 04 Dec, 2020

Registration: 09:00:am - 04:00:am

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

MR ABIODUN TOKI 08033019120

3 – 4 Candidates: 5% 5 or more Candidates: 10%.
NST PPC Advert
Related Courses
Budgeting, Forecasting and Budgetary Control Course Budgeting, Forecasting and Budgetary Control Course

4 days, 03 - 06 Dec, 2019 

2019-12-03 12:12:00
Lagos State, Nigeria

Tom Associates Training

The programme is designed to equip Managers and Heads of departments entrusted with departmental or organisational budgets with knowledge and skills necessary to enable them effectively manage and ...

Foundation Excel for Financial and Business Analysis Course Foundation Excel for Financial and Business Analysis Course

4 days, 28 - 31 Jan, 2020 

2020-01-28 12:01:00
Lagos State, Nigeria

Tom Associates Training

This course is designed as an introduction to basic spreadsheet tools and formulas. Candidates will be able to map data to predict the future. Major corporations and small businesses alike use ...

Frontline Leadership: Emerging Leadership Course Frontline Leadership: Emerging Leadership Course

3 days, 27 - 29 Jan, 2020 

2020-01-27 12:01:00
Lagos State, Nigeria

Tom Associates Training

The  course presents the basic principles that are the foundation of all the leadership activities and central to senior level effectiveness: Building and maintaining a positive, ...

Account Reconciliation and Management of Suspense Account Course Account Reconciliation and Management of Suspense Account Course

3 days, 20 - 22 Jan, 2020 

2020-01-20 12:01:00
Lagos State, Nigeria

Tom Associates Training

Course Contents Day One Significance of Account Reconciliation Correction of transaction mistakes     Tracking fraudulent activities Problems with requisite accounting skills The ...