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

By: Tom Associates Training  

Lagos State, Nigeria

19 - 22 Apr, 2022  4 days

Follow Event

  

NGN 175,000

Venue: 5/7 Alade Lawal Street, Opposite Anthony Police Station, Idi-iroko Bus-Stop, Ikorodu Road, Anthony Village - Lagos, Nigeria

Other Dates

Venue Date Fee  
5/7 Alade Lawal Street, Opposite Anthony Police Station, Idi-iroko Bus-Stop, Ikorodu Road, Anthony Village - Lagos, Nigeria, Lagos State, Nigeria 02 - 05 Aug, 2022 NGN175000

This programme can run as an online or classroom training (Available also for Customised Training by Duration, Venue and Fee) (Participants must be with their Computers)

Course Contents

Day One

• Subtotal Application

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

Day Two

 Advanced Pivot Table tricks.

• PowerPivot for Data Mining (Excel 2013 and above 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 Three

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

• E-mails and Excel reports

• 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 Anthony Police Station, Idi-iroko Bus-Stop, Ikorodu Road, Anthony Village - Lagos, Nigeria Apr 19 - 22 Apr, 2022
5/7 Alade Lawal Street, Opposite Anthony Police Station, Idi-iroko Bus-Stop, Ikorodu Road, Anthony Village - Lagos, Nigeria, Lagos State, Nigeria 02 - 05 Aug, 2022
NGN 175,000.00(VAT Inclusive)
(Convert Currency)

Tolu Jegede 08178591654

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

Related Courses

Guides to Setting up a New HR Department Course Guides to Setting up a New HR Department Course

5 days, 19 - 23 Sep, 2022 

2022-09-19 12:09:00 2022-09-19 12:09:00
Lagos State, Nigeria

Tom Associates Training

This course provides the information HR officers need to establish a human resource function in new, small and medium size companies or companies opening an HR department for the first time. It ...

Inventory, Logistics and Distribution Management Course Inventory, Logistics and Distribution Management Course

3 days, 16 - 18 Feb, 2022 

2022-02-16 12:02:00 2022-02-16 12:02:00
Lagos State, Nigeria

Tom Associates Training

Logistics has become a quintessential factor in modern-day organisations. This course examines the core issues and skills required to promote production and distribution efficiency, reduce waste and ...

Management of Contract Risks for Successful Contract Closure Management of Contract Risks for Successful Contract Closure

3 days, 02 - 04 Mar, 2022 

2022-03-02 12:03:00 2022-03-02 12:03:00
Lagos State, Nigeria

Tom Associates Training

This programme can run as an online or classroom training (Available also for Customised Training by Duration, Venue and Fee) Contract risks in business relationships are any uncertainties about the ...

Aggressive Market Penetration Training: Battles for Market Share Aggressive Market Penetration Training: Battles for Market Share

5 days, 18 - 22 Jul, 2022 

2022-07-18 12:07:00 2022-07-18 12:07:00
Lagos State, Nigeria

Tom Associates Training

A five-day sales and marketing training on intense and offensive market drive.  With speed, the sales and marketing persons must: generate awareness for the company’s products achieve ...