Introducing Our New Personalized Premium One-on-one Class

Another Industry First From Us to You. Get Our New Personalised Premium Offering Now.

Another Industry First From Us to You. Get Our New Personalised Premium Offering Now.

Today, we are thrilled to announce the launch of UrBizEdge’s Personalized for me, this special pack allows you to pick the topics/areas you want to master in Excel and Power BI to achieve your objectives and aspirations. You will also have a trainer take you through applying these to your reports. Our goal is to help you further develop your skills through a personalized learning experience.

With over 7 years of experience, UrBizEdge thus has a unique perspective on the evolution of jobs, industries, organizations, and skills over time. Today we are expanding our current programs by delivering a personalized, comprehensive, course designed just to fit your evolving business needs. Another key advantage of this special pack is having both consulting and training at the cost of just training. 

How to Get Started?

If interested, take a look through these topics listed below and let us know which ones you want to set up a customized one-on-one class around. 

Based on your selection we will then have the class structured into an appropriate number of days. The price for this premium offering is N50,000/day. For most people, 1 or 2 days cover their unique focus areas. We have had huge success delivering this model for many managers and super busy executives who would rather just have a class structured around their needs and usage scenarios with a very personalized touch.

Modern Excel:

  • New Formulas in Excel
    • XLOOKUP which is the replacement for VLOOKUP, HLOOKUP, and INDEX + MATCH combo
    • UNIQUE to remove duplicates and create dynamic dashboards/reports
    • FILTER to have a dynamic filter and create dependent dropdowns
    • SEQUENCE
    • SORT, SORTBY
    • RANDARRAY
    • LAMBDA
  • Power Query – the ultimate data transformation and cleaning tool in Excel
    • Combining data/reports from multiple sheets super easily
    • Combining data/reports from multiple files super easily
    • Pulling data from multiple sources and cleaning/transforming them
    • Unpivot (a magical data transformation tool)
    • Unrivaled column splitting
      • Split to rows
      • Separate numbers from texts
      • Split by case change
      • Split on every x number of characters
    • AI Insights
      • Text Analytics
      • Vision
      • Azure Machine Learning
    • Groupby (SQL type action)
    • Append Queries
    • Merge Queries
      • Standard Merge
      • Fuzzy Match to handle inconsistent spellings
  • Power Pivot
    • Handling data of more than 1.05 million rows
    • Data Modeling (creating relationships between datasets and more)
    • DAX formulas
    • Integrating with Pivot Table
  • Deep Dive into Pivot Table and Pivot Charts
    • Using Pivot Table to create very interactive dashboards
    • Slicers and Timelines
  • Data visualization and Charts
    • Understanding all the new 18 charts in Microsoft Excel
    • Combo chart
    • Sparklines
    • Conditional formatting as a visual
    • Icons and smart arts (infographics)
  • Formulas Deep Dive
    • IF, AND, OR, IFS, SWITCH, XOR
    • SUMIFS, COUNTIFS with wildcards (especially * and ?)
    • ISNA, ISERROR, ISBLANK, ISLOGICAL, ISFORMULA, ISREF, ISTEXT, ISNUMBER
    • VLOOKUP, HLOOKUP, INDEX + MATCH combo
    • EDATE, EOMONTH, TODAY, NOW, DATE, TEXT, YEAR, MONTH, DAY, DATEDIF, NETWORKDAYS, 
    • CONCATENATE, CONCAT, TEXTJOIN, FIND, SEARCH, MID, LEFT, RIGHT
    • SUMPRODUCT to replace VLOOKUP, SUMIFS etc (a must know for anyone claiming Excel expert level)
    • INDEX (one of the most versatile formulas in Excel)
  • Creating Dashboards in Excel
  • Planning and Strategy Tools in Excel
    • Goal Seek
    • Scenario Manager
    • Data Table
    • Solver
  • Integrating Excel with Data Science tools
    • R (using BERT)
    • Python (using xlwings)
    • JavaScript Office APIs
  • Power Automate in Excel
  • Excel VBA
    • Recording macro
    • Coding from Scratch
      • Userforms
      • Modules
      • User-Defined Functions  VBA

Power BI: 

  • Mastering Power Query in Power BI
    • Power Query handbook with M codes
    • Advanced Editor use
    • Column profiling
    • Diving into the deep end of Merge and Append
    • Magic of Right Click
    • Mastering the Power Query interface
      • Enabling the Formula bar
      • Query Settings
      • Query Dependencies
  • DAX deep dive
    • Must know DAX formulas (CALCULATE, FILTER, SUMMARIZE etc)
    • DAX Studio
    • Debugging incorrectly working DAX formulas
    • Optimising your DAX
  • Data Modeling
    • Relationships
    • Cardinality
    • Direction
    • Synonyms
    • Date Table
  • Visuals and Report Creation
    • Native visuals
    • Imported/marketplace visuals
    • Symbols and Unicode icons
    • Report layouting
    • Row-level security
  • Report Publishing, Dashboards, and Power BI Service
  • AI in Power BI
  • Power BI Settings

In summary,

  1. You get to choose the topics you want to master.
  2. You get to choose the date to have the class.
  3. You get more options of venue (our place or your place).
  4. You get to have the trainer work on your report for you during the training.
  5. You get to improve on the new areas of data analysis you are weak at without being forced to go through areas not important to you as is often the case in general training classes.
  6. The best part is that we are setting the fees at a very affordable rate that’s the same as the general classes while you get a personalized training.

Don’t delay. Take advantage of this offer before the price is raised. Reply to us now or call Hope on 0808-266-9002 or Faith on 0913-137-0701.

Leave a Reply

Business Data Analysis
close slider
[]
1 Step 1

Interested in our Business Data Analysis Training?

keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right