Create Event
Search results for:
No result found! Try with different keywords!
Advertisement
In-depth Excel Training Executive Dashboards & Business Data Analysis

In-depth Excel Training, Executive Dashboards & Business Data Analysis

May 21, 2021 - May 22, 2021

In-depth Excel Training, Executive Dashboards & Business Data Analysis

Time Fri May 21 2021 at 09:00 am to Sat May 22 2021 at 05:00 pm

(add to calendar)

Hotel Rosebud, 33 Port Harcourt Crescent, Abuja, Nigeria

Find Tickets on eventbrite.com
Advertisement

In-depth Excel Training, Executive Dashboards & Business Data Analysis, 21 May | Event in Abuja | AllEvents.in In-depth Excel Training, Executive Dashboards & Business Data Analysis
In-depth Excel Training, Executive Dashboards & Business Data Analysis

About this Event

Below are the details of our next training to take place in Abuja. Thanks for your interest!


I have also attached the PPT of the training learning outcomes and our 2021 training calendar.


This is a special opportunity for you to be trained at a specially discounted cost by professionals who have done Microsoft Excel training and consulting for MTN Nigeria, Airtel Nigeria, Vodacom, Globacom, Guinness, Nigerian Breweries, Total E&P and many other local and international companies.


You will get to learn all you need to boost your productivity at work and your career/entrepreneurial prospects. So this is an opportunity you shouldn't miss.


The training details are as follows:




Date: Friday 21st– Saturday 22nd May 2021.


Cost: N70,000 (special 30% discount from N100,000 standard cost)


The cost covers your training materials, after training support, video learning materials, certificate and lunch. Try to pay early to secure your spot and send us your name as you would like it to appear on your certificate.


Payment Details


Account Name: URBIZEDGE LIMITED


Bank: FCMB


Account No: 2888666014


Branch: Onipanu




Title: Business Data Analysis, Dashboards and In-depth Excel Training


Training Outline


Data Manipulation in Excel

How Excel handles different data types

Data consistency, starting with the end in view

Building Datasheets that can easily scale

Sorting

i. Cascaded sorting


ii. Sorting across rows (left to right sorting, not the usual up to down sorting)


iii. Sorting and Conditional Formatting to identify trends


Filtering

Data cleaning

i. Removing duplicates


ii. Text-to-column


iii. Grouping


iv. Data Validation


Data formatting

i. Using Tables (and when to convert to tables)


ii. Formatting for printing


iii. Formatting for email


iv. Data Review and formatting for 3rd party use


Named Ranges



Charts

Chart types

i. Line chart and when to use it


ii. Column chart and when to use it


iii. Bar chart and when to use it


iv. Pie chart and it’s dangers


Combining charts; when and how.

Dynamic Charts, using filter.

Best practices when making charts

Sparklines



Pivot Table, Pivot Chart and PowerPivot

Pivot Table

i. Default Pivot Table


ii. Tabular Pivot Table


iii. Pivot Table Filtering


iv. Making a very dynamic regular table from Pivot Table


v. Calculations and Formula use with Pivot Table


vi. Advanced Pivot Table tricks


Pivot Chart

i. Pivot Chart and its limitations


ii. Dynamic Pivot Charts




Business Data Analysis

Linking sheets

Duplicating sheets (better than copy and paste)

Inserting sheets, labeling and coloring the professional way

Freezing Panes and splitting windows

Conditional formatting

i. To identify patterns


ii. Using formulae


iii. To make extremely intelligent reports


Lookup functions – VLOOKUP and others

IF, IFERROR, AND, OR, ISBLANK, and others in the same family

COUNTIF, SUMIF and others, to make dynamic summary tables

Math Functions

Text Functions

Date Functions

Formula Auditing

Goal Seek, Scenario Manager and Data Table

Most useful Excel keyboard shortcuts



Executive Dashboards and Reporting

Best Practices

Executive Dashboards

i. What are Dasboards


ii. Dynamic Reports


iii. Determining the KPIs and tracking them


iv. Strategic Insights & Analysis


v. Data Visualization


vi. Having the audience/recipient in mind




Excel to PowerPoint and Word

Linking PowerPoint/Word Charts to Excel

Embedding Excel sheets in PowerPoint/Word

Making a Powerful PowerPoint Presentation



Introduction to Excel Macros (VBA)

What is Excel Macro?

Its value propositions

Creating a macro from scratch

Practice Session




Also check out other Workshops in Abuja, Entertainment Events in Abuja, Music Events in Abuja.

Tickets

Tickets for In-depth Excel Training, Executive Dashboards & Business Data Analysis can be booked here.

Get Tickets

Ticket Information Ticket Price
General Admission Free
Event Photos
Hosted by
UrBizEdge is a registered business data analysis and consulting firm in Nigeria. We specialise in helping companies be on top of their business data. We focus exclusively on the world’s most used and most flexible business intelligence tool: Microsoft Excel. We have the only Microsoft Excel Most Valuable Professional in Africa. And there are just about 125 in the whole world. It’s the highest recognition Microsoft gives an independent industry expert. MISSION: To give our clients the business intelligence edge they need using tools they already have.
Are you the host?
Nearby Hotels Hotel Rosebud, 33 Port Harcourt Crescent, Abuja, Nigeria
Event details from Report a problem ?

Event Information

Date & Time

Fri May 21 2021 at 09:00 am to Sat May 22 2021 at 05:00 pm
Add to Calendar

Location

Hotel Rosebud, 33 Port Harcourt Crescent, Abuja, Nigeria

Advertisement
Advertisement
Make Your Events Easy to Discover

Create an online presence of your events and make them easy to discover & share with the relevant audience.

Create Events