# Michael Olafusi

• ### Tool for Stocks Picking and Market Analysis in Nigeria - Duration: 21 minutes.

• 3 days ago
• 58 views
Picking stocks to buy or sell on the Nigerian Stock Exchange using http://vip.urbizedge.com/economy
• ### Power BI DAX #6 - UNION - Duration: 5 minutes, 48 seconds.

• 1 month ago
• 86 views
UNION is a DAX formula that allows you to append/join two or more tables. And in this demonstration I will show you a cool way to create a literal table in Power BI DAX (a table with rows of data t...
• ### Nigeria Market Data chat bot (for stocks; GDP, inflation, Exchange rate, company financials etc.) - Duration: 54 seconds.

• 1 month ago
• 32 views
You can access easily stocks, financial markets and macro-economical data on Nigeria easily via our new chat bots available on major social media platforms.

Telegram: http://t.me/NigeriaMarketData...
• ### Practical Task on SUMIFS, INDEX, MATCH, SUMPRODUCT, SUM (after training benefit) - Duration: 15 minutes.

• 1 month ago
• 46 views
We give participants of our Excel training (www.urbizedge.com) weekly tasks. Here's the solution to Week 1 task.

And the solution file is: https://urbizedge.blob.core.windows.net/urbizedge/UrBizEd...
• ### XLOOKUP: The ultimate comprehensive demonstration, short and direct. - Duration: 14 minutes.

• 1 month ago
• 89 views
I go straight to the point without wasting your time on stories:
1. XLOOKUP vs VLOOKUP
2. XLOOKUP vs HLOOKUP
3. XLOOKUP vs INDEX and MATCH
4. XLOOKUP to return cell address (like INDEX does)

Here'...
• ### New Excel Magic Formula #2: SORT - Duration: 2 minutes, 45 seconds.

• 2 months ago
• 70 views
Microsoft has included some new formulas in Microsoft Excel that I call "magic formulas".

They are:
UNIQUE
FILTER
RANDARRAY
SEQUENCE
SORT
SORTBY

In today's post I am going to introduce...
• ### New Excel Magic Formula #1: UNIQUE - Duration: 7 minutes, 9 seconds.

• 2 months ago
• 97 views
Microsoft has included some new formulas in Microsoft Excel that I call "magic formulas".

They are:
UNIQUE
FILTER
RANDARRAY
SEQUENCE
SORT
SORTBY

In today's videoI am going to introduce yo...
• ### Basic Investment and Financial Planning - Duration: 1 hour, 6 minutes.

• Streamed 4 months ago
• 181 views
You can join the Meetup group at https://www.meetup.com/Nigeria-Investment-Personal-Financ... and the Telegram group at https://t.me/joinchat/Gfyf4VFBAOHYM3kdc98QHA

• ### Formula to Generate Random Texts and Paragraphs in Word - Duration: 2 minutes, 14 seconds.

• 5 months ago
• 108 views
Yes. Your eyes aren't deceiving you! You can generate random texts and paragraphs in Microsoft Word.

Can be very helpful in creating templates and sample official documents.
• ### Auto creating Table of Contents and creating Different Numbering Styles in Word - Duration: 5 minutes, 37 seconds.

• 5 months ago
• 49 views
Learn how to:
2. Create different numbering styles in same document

Can be time saving in creating official proposals, academic report...
• ### Creating Interactive Dynamic Forms in Microsoft Word - Duration: 5 minutes, 37 seconds.

• 5 months ago
• 172 views
Learn how to:
2. Picture picker
3. Combo-box/Dropdown
4. Text box
5. Make text entered automatically show in other parts of your document
• ### Financial Modeling Training -- www.urbizedge.com - Duration: 3 hours, 32 minutes.

• 5 months ago
• 218 views
From empty Excel to:
1. Creating the financial modeling template
2. Making the financial statements forecast
3. Including different scenarios - best case, base case & worst case
4. Creating a DCF v...
• ### Get Nigeria Unemployment rate figures directly in Microsoft Excel - Duration: 78 seconds.

• 9 months ago
• 55 views
How to get Nigeria Unemployment rate figures directly in Microsoft Excel
• ### Get Nigeria Population figures directly in Microsoft Excel - Duration: 83 seconds.

• 9 months ago
• 21 views
How to get Nigeria Population figures directly in Microsoft Excel
• ### Get Nigeria PMI figures directly in Microsoft Excel - Duration: 89 seconds.

• 9 months ago
• 28 views
How to get Nigeria PMI (Purchasing Managers' Index) figures directly in Microsoft Excel
• ### Get historical Nigeria CBN Interest rates directly in Excel - Duration: 75 seconds.

• 9 months ago
• 23 views
How to get historical Nigeria CBN Interest rates directly in Excel
• ### Get Nigeria Inflation Rates directly in Microsoft Excel - Duration: 79 seconds.

• 9 months ago
• 29 views
How to get Nigeria Inflation Rates directly in Microsoft Excel
• ### Get Nigeria GDP Growth Rates directly in Microsoft Excel - Duration: 83 seconds.

• 9 months ago
• 27 views
How to get Nigeria GDP Growth Rates directly in Microsoft Excel
• ### Get Nigerian Oil Production Volume historical figures in Microsoft Excel - Duration: 2 minutes, 5 seconds.

• 9 months ago
• 25 views
How to get Nigerian Oil Production Volume historical figures in Microsoft Excel
• ### How to get global Stock Indices directly in Microsoft Excel - Duration: 2 minutes, 32 seconds.

• 9 months ago
• 35 views
How to get global Stock Indices directly in Microsoft Excel:
DOWJONES
SP500
NASDAQ100
NASDAQ
RUSSEL2000
FTSE100
FTSEALL
DAX
CAC40
FTSEMIB
IBEX35
MICEX
AEX
BIST100
SMI
OMXS30
ISEQ
LUXX
EUROSTOXX50
E...
• ### Extract Brent Crude Price history directly in Microsoft Excel - Duration: 2 minutes, 22 seconds.

• 9 months ago
• 24 views
How to extract Brent Crude Price history directly in Microsoft Excel
• ### Get NSE listed companies stock prices directly in Microsoft Excel - Duration: 2 minutes, 56 seconds.

• 9 months ago
• 95 views
Access the current and historical prices of companies listed of the Nigerian Stock Exchange, directly in Microsoft Excel
• ### How to extract Nigerian exchange rates, current and historical, in Microsoft Excel - Duration: 2 minutes, 29 seconds.

• 9 months ago
• 39 views
Get current and historical exchange rates of Naira against the major global currencies in Microsoft Excel
• ### Power BI DAX #5: SUMMARIZE - Duration: 3 minutes, 41 seconds.

• 9 months ago
• 1,727 views
You can read up on the official documentation of SUMMARIZE: https://docs.microsoft.com/en-us/dax/summarize-function-dax

In essence, how the syntax works is you put in the table name, the columns ...
• ### How To Automatically Pull In New Report Data Into Excel Using PowerQuery - Duration: 6 minutes, 15 seconds.

• 9 months ago
• 367 views
One common situation most users of Excel face in making recurrent reports -- daily reports, weekly reports, monthly reports etc -- is that of updating the raw data part of the report with the new d...
• ### Power BI DAX #4: CALENDAR, every sales/operations analyst friend - Duration: 4 minutes, 13 seconds.

• 9 months ago
• 142 views
Power BI DAX #4: CALENDAR, every sales/operations analyst friend

CALENDAR allows you to easily create a date table.

• ### Power BI DAX #3: VALUES, another must know DAX formula - Duration: 3 minutes, 40 seconds.

• 9 months ago
• 497 views
VALUES gets you the list/table of unique records in a specified table or column. It is a must know DAX formula.

There is a similar DAX formula called DISTINCT. However, VALUES performs a referenti...
• ### Power BI DAX #2: Meet the most popular DAX formula -- CALCULATE - Duration: 8 minutes, 49 seconds.

• 9 months ago
• 324 views
Power BI DAX Tutorial #2: CALCULATE

CALCULATE is the most popular, and perhaps, most important formula, in Excel. It enables you to change filter context in your calculations, making you achieve t...
• ### DAX Tutorial #1: CROSSJOIN - Duration: 3 minutes, 14 seconds.

• 9 months ago
• 195 views
CROSSJOIN enables you to create an interesting combination (cartesian product) of rows from two or more tables.

Watch the video to see it in action. To join our training class, visit www.urbizedg...
• ### Financial Modeling and Valuation Training - Duration: 12 minutes.

• 10 months ago
• 88 views
Register for our hands-on industry relevant Financial Modeling training by a certified Advanced Financial Modeler: https://www.urbizedge.com/FinancialModelling
• ### Nigerian Excel Users 2018 Meetup: Corporate Data Analytics by Evans Otalor - Duration: 17 minutes.

• 1 year ago
• 102 views
Nigerian Excel Users 2018 Meetup: Corporate Data Analytics - Structures and Processes by Evans Otalor
• ### Nigerian Excel Users 2018 Meetup: Machine Learning with Excel - An SSAS approach by Kelechi Emenike - Duration: 13 minutes.

• 1 year ago
• 75 views
Nigerian Excel Users 2018 Meetup: Machine Learning with Excel - An SSAS approach
• ### Nigerian Excel Users 2018 Meetup: Underestimated Power of Excel by Victor Momoh pt 2 - Duration: 17 minutes.

• 1 year ago
• 71 views
Nigerian Excel Users 2018 Meetup: Underestimated Power of Excel by Victor Momoh pt 2
• ### Nigerian Excel Users 2018 Meetup: Practical Career Advice from Charles Otoighile - Duration: 71 seconds.

• 1 year ago
• 49 views
Nigerian Excel Users 2018 Meetup: Practical Career Advice from Charles Otoighile
• ### Nigerian Excel Users 2018 Meetup: Underestimated Power of Excel by Victor Momoh - Duration: 6 minutes, 21 seconds.

• 1 year ago
• 63 views
Nigerian Excel Users 2018 Meetup: Underestimated Power of Excel by Victor Momoh
• ### Nigerian Excel Users 2018 Meetup -- Introduction by Charles Otoighile - Duration: 4 minutes, 9 seconds.

• 1 year ago
• 43 views
Nigerian Excel Users 2018 Meetup -- Introduction by Charles Otoighile

• 1 year ago
• 24 views
Intro
• ### Different Charts in Microsoft Excel - Duration: 25 minutes.

• 1 year ago
• 74 views
Charts in Excel
1. Column: To show data for different categories
2. Line: To show trend (there must be a time component)
3. Pie: To show relative contribution
4. Bar: To show data for different cat...
• ### Row Level Security in Power BI to Manage Report Access By Job Role - Duration: 6 minutes, 54 seconds.

• 1 year ago
• 7,892 views
Make one report and share to different country or regional managers but let each country/regional manager see only what is for his own country/region.

It is very simple yet powerful. Watch me show...
• ### Fuzzy Lookup in Excel for matching inconsistently spelled names - Duration: 3 minutes, 41 seconds.

• 1 year ago
• 7,708 views
Got different tables in Excel you would like to match their records line by line, and VLOOKUP is not getting them right because of inconsistent spellings in the match fields?

• ### My Most Important Excel Formulas: Would Recommend You Master Them - Duration: 1 hour, 8 minutes.

• Streamed 1 year ago
• 349 views
As a full-time Microsoft Excel consultant, of all the over 450 formulas in Excel there are just a handful I focus on in my training classes because they provide the most value in practical day-to-d...
• ### February 2018: 45 mins Crash Course on Power BI - Duration: 1 hour, 16 minutes.

• Streamed 1 year ago
• 1,759 views
I have been teaching professionals from different companies and countries Power BI since 2015.

Many people still find it tough to grasp what the value is in using Power BI or what business intelli...
to add this to Watch Later