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

, , No Comments


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

0 comments:

Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.

Thanks!