This is a special opportunity for
you to be trained at a specially discounted cost by an official Microsoft Most
Valuable Professional who has done Microsoft Excel consulting for MTN Nigeria,
Airtel Nigeria, Vodacom, Globacom, Guinness, Nigerian Breweries, Total E&P
and many other local and international companies. He comes with a wealth of
experience that is second to none in Nigeria and he is globally recognized.
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: 21st Friday and 22nd Saturday,
July 2017
(9:00am to 5:00pm daily)
Venue: Kristina Jade Learning Center, 70b Olorunlogbon street,
off Alade Lawal street, Anthony Village, Lagos state.
Cost: N60,000
(Discounted by 40% from the standard fee of N100,000)
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
Reach Michael on 0700ANALYTICS, 08089382423, 08063125227 and mike@urbizedge.com or Hannah on 08021180874 and hannah@urbizedge.com to register.
Title: Business Data Analysis,
Dashboards and In-depth Excel Training
Training Outline
1)
Data Manipulation in Excel
a.
How Excel handles different data types
b.
Data consistency, starting with the end in
view
c.
Building Datasheets that can easily scale
d.
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
e.
Filtering
f.
Data cleaning
i. Removing
duplicates
ii. Text-to-column
iii. Grouping
iv. Data
Validation
v. Conditional
Formatting
g.
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
h.
Named Ranges
2)
Charts
a.
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 when to use it
b.
Combining charts; when and how.
c.
Dynamic Charts, using filter.
d.
Best practices when making charts
e.
Sparklines
3)
Pivot Table, Pivot Chart and PowerPivot
a.
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
b.
Pivot Chart
i. Pivot
Chart and its limitations
ii. Dynamic
Pivot Charts
c.
PowerPivot (for Excel 2010 and 2013) only
4)
Business Data Analysis
a.
Linking sheets
b.
Duplicating sheets (better than copy and
paste)
c.
Inserting sheets, labeling and coloring the
professional way
d.
Freezing Panes and splitting windows
e.
Conditional formatting
i. To
identify patterns
ii. Using
formulae
iii. To
make extremely intelligent reports
f.
Lookup functions
i. Vlookup
ii. Hlookup
iii. Looking
up the last data or pattern in a particular row or column
iv. Overcoming
the limitations of Vlookup and Hlookup using index and match functions
g.
Power Functions
i. IF,
IFERROR, AND, OR, ISBLANK, and others in the same family
ii. TEXT
manipulative functions to make a completely automated Dashboard
iii. COUNTIFS,
SUMIFS, AVERAGEIFS and others, to make dynamic summary tables
iv. MATCH
and INDEX to do the impossible
h.
Other Functions
i. Math
Functions
ii. Text
Functions
iii. Logical
iv. Others
i.
Formula Auditing
5)
Dashboards and Reporting
a.
Best Practices
b.
Excel Dashboards
c.
Data Visualization
d.
Having the audience/recipient in mind
e.
E-mails and Excel reports
6)
Excel to PowerPoint
a.
Linking PowerPoint Charts to Excel
b.
Embedding Excel sheets in PowerPoint
c.
Making a Powerful PowerPoint Presentation
7)
Introduction to Excel VBA
a.
Recording Excel macros