Our Next Class Based Microsoft Excel Training -- 17 & 18 April 2015

, , 2 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 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 prospects. So this is an opportunity you shouldn't miss.

The training details are as follows:

Date: 17th Friday and 18th Saturday, April 2015 (9:00am to 5:00pm daily)
Venue: Kristina Jade Learning Center, 70b Olorunlogbon street, off Alade Lawal street, Idiroko b/stop, Maryland, Lagos state.
Cost: N50,000 N35,000 (special 30% discount)

The cost covers your training 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 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
f.        Power Map and Power View (Excel 2013)

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)      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
b.    Simple Practical uses



2 comments:

  1. Hi Michael. Great content. Any chance of scheduling a session in Portharcourt? Do you have sessions that are more focused on VBA?

    Atoberi Ogbimi

    ReplyDelete
    Replies
    1. Hi Atoberi,

      Thanks for your inquiry. Please send your contact details to us via info@urbizedge.com and we'll keep you informed on our plans to reach Port Harcourt.

      Thanks again,
      Michael

      Delete

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!