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