Hire a Microsoft Office Excel MVP and VBA Expert!


I'm a Microsoft Excel MVP. A Microsoft Excel Consultant and Expert in Nigeria.

You can reach me +234-808-938-2423 or mike(at)urbizedge.com or skype olafusimichael
  • Do you need an Excel Expert to automate your analyses, charts and reports, so you can focus on growing revenue and making better business decisions?
  • Do you need an Excel Expert to build a custom Excel dashboard to track your business key performance metrics?
  • Do you need an Excel Expert to build Excel based applications that are easy to use and can interact with third party data sources like your CRM or Access Database?
  • Do you need an Excel Expert to help your team focus on their core duties by building Excel based data entry tool that does automatic analysis and reporting?
  • Do you need an Excel Expert to train your team on getting the best out of Excel and increasing their productivity?
  • Do you need an Excel Expert to design and build performance monitoring and business analysis Excel solutions that will show you what you're doing right, what you're doing wrong and what you need to focus on?
  • Do you need an Excel Expert to fix an old Excel Macro or make an entirely new, better and more robust one?
  • Do you need an Excel Expert to improve and automate your KPI & Scorecard dashboards.
  • Do you need an Excel Expert to build a work shift solution for your company? A very flexible and intelligent one that makes sure all your employees get a timeslot that suits them and can help you identify backup staff when one suddenly calls sick.
  • Do you need an Excel Expert to automate your inventory system? So you'll never be confused about what's in stock and what's not in stock, and quantities.
  • Do you need an Excel Expert to build you a stocks analysis spreadsheet or a portfolio monitoring spreadsheet?
  • Do you need an Excel Expert to build an Income Expense tracker for your business?
  • Do you need an Excel Expert to build a scalable business data analysis tool for your company?
You are in luck! Look no further.

I have been doing these for multinationals in Nigeria, and a couple of foreign based companies that outsource to Asia and Africa. And occasionally, for individual clients.

I also offer tailored Excel training for professionals, business analysts, MIS analysts and financial analysts.

As a sample, here are the details of my training pack for Business Data Analysts:

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. Advanced 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. Advanced 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. All the different 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
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) Reporting
a. Best Practices
b. Benefit of a secret Almighty sheet 
c. What to share and what to keep
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) Excel VBA 
a. Introduction to VBA
b. Recording Macros and it's limitations
c. Writing your own Macro
d. When to use a Macro and the implications
e. Hands-on, doing the impossible with Macros

You can reach me on +234-808-938-2423 or mail me at michael(at)olafusimichael.com

 "Michael [UrBizEdge] was instrumental in getting our staff up to speed on basic Excel, as well as more advanced skills that have already started to improve the back end of our programs. He was flexible, accommodating, professional, friendly, and was able to tailor our training to exactly what we needed. We could not have been more happy working with him, and he truly has helped our organization increase our effectiveness and comfort with database work." 
-- Beth M., Program Manager for Kentucky YMCA, USA.

5 comments:

  1. Your line isnt going through.. bn trying to reach you like foever

    ReplyDelete
    Replies
    1. Hi Ernest. Sorry, could be very busy on my training days. My direct lines are 08063125227 & O8089382423. Also available on Whatsapp. You can also reach the team via 01-6311885. Thanks!

      Delete
  2. I need this training individually. How can you be of help?

    ReplyDelete
    Replies
    1. Hi,

      You can get registration details for our monthly class via https://www.urbizedge.com/Excel

      Thanks!

      Delete
  3. How much are for the trainning

    ReplyDelete

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!