Insight Edge Data Analytics School

26/03/2026

Hi Data Fam,

Have you used the CHOOSE function before in Excel?

Did you know that this function uses an index number to retrieve your data?

Watch this video to see how the function works.

tutorial # function #

03/03/2026

Are you struggling with ranges in Excel? In this tutorial, I show you how to master VLOOKUP Approximate Match. Some people might not be use to this function, but as a Data Analyst, you need to know how to handle Tiers and Ranges.

In this video, you will learn:

When to use "TRUE" instead of "FALSE."

How to sort your data so the formula actually works.

Real-world example of Approximate Match in action.

Subscribe to Insight Edge Data Analytics to build your professional Excel library!

Link https://youtu.be/3541PH5ceA0

18/02/2026

Stop searching for data manually! ✋📊

If you want to move from a beginner to a pro Data Analyst, you have to master the LOOKUP function.

In today's tutorial, I explained exactly how it works so you can save hours of work every week.

Click the link below to watch the full tutorial! 👇
https://youtu.be/VGXbbEKSHf8

11/02/2026

Upgrade your Excel logic! In this video, I went beyond the basic IF function to explore AND and OR. Learn how to test multiple conditions at once to make your spreadsheets truly "smart." Perfect for data analysts and anyone looking to automate their reporting.
Watch it on my YouTube channel: https://surl.lt/czsohi

04/02/2026

Title: Mastering the "IF" Function
​I’ve just uploaded the next installment of our Excel series to the YouTube channel.

​As I’ve been building this library (we are now at 25 videos!), I’ve realized that having everything in one place on YouTube makes it much easier for you to search, save, and learn at your own pace.

​Today's video is all about the IF Function. If you’ve ever wanted to make your spreadsheets "smarter" so they categorize data for you automatically, this is the one to watch.

​I’m focusing all my energy on building out the YouTube channel as a free resource for anyone who wants to improve their skills.

I’d love for you to head over there, watch the lesson, and if it helps you, join the community by subscribing!

​Watch the full video here: https://youtube.com/-o6i?si=K-rP09kS9F7U9pJp

28/01/2026

Compliment of the season everyone. You can watch this video tutorial on my YouTube channel. If you also find it useful kindly like, share and subscribe to my channel. Thank you

In this video, you will learn important Microsoft Excel skills for beginners.You will learn how to format cells, apply date and currency, use find and replac...

03/11/2025

Hello Datafam,

Do you often struggle with how to apply “AND” and “OR” in logical statements?

Watch this video to learn more.

I believe that once you understand these basics, it will help you tackle more complex problems that come your way.

Have a wonderful day!

30/07/2025

Hi Data Fam,

Today, we will be looking at conditional formatting in Excel alongside the IF logical statement.

In this video, I applied conditional formatting on a particular column, and I also used the IF logical statement to get the same result.

Enjoy it and learn.

For further learning, here is the link to my video course:

https://bit.ly/3ELsn1W

02/07/2025

Report Summary

Aim: The project's aim was to know the following:

A. Revenue the company made from two products.

B. Revenue the company made from 5 regions.

C. Amount of products sold based on the units.

D. Top 5 customer locations by revenue.

E. Top 5 product brands by unit sold and the bottom 5.

Preparation: The datasets was imported to Power BI and was cleaned and transformed with Power Query.

Here are the steps applied in Power Query:

1. Renaming of the column header.

2. Reordering of columns.

3. Addition of currency.

4. Addition of a custom column to get a new revenue column.

5. The transformed data sets were then closed and loaded.

Process: Here, the dashboard was built, charts were used for visualisation.

Analyze:

1. Insights extracted revealed that the company made the highest revenue from laptops, but the difference from the revenue made from mobile phones is just a little margin.

2. Based on the region, the West region had the highest revenue amongst the four, while the others had the same revenue.

3. Based on the top 5 customer locations, the company made their highest revenue from North Michael, with East James and Lake Michael having the same revenue.

4. Insights extracted from the top 5 showed that Google took the lead while Asus had the worst patronage.

I am Olufemi Michael a data analyst/data analytics instructor.

I conduct group training and personalized training for anyone who wants to make a transition into data analytics at an affordable price.

Do you want to make a transition into data analytics, and do you need a trainer?

Don't panic! I am here for you.

Contact me via my Whatsapp number:+2348162378964.

23/06/2025

Hi Data Fam,

Trust you are all learning!

Today, I will be showing you "how you can get rid of blank cells in Excel"

Are there methods that can be used to remove blank cells? Yes!

Can blank cells be removed manually? Yes!

What if I have thousands of blank cells; will the method of removing manually work?

That was why I recorded this video for you to learn.

Watch and learn how to remove blank cells.

I specialize in training people who want to start a career in Data Analytics.

Are you in need of personalized training?

Chat me up now and let's discuss.

Also, if you have been finding my video content useful and you want to enhance your skill in Microsoft Excel; why not purchase my "Excel essential video course" and learn Excel at your pace from basics to advanced level at an affordable price.

Below is the link:

https://bit.ly/3ELsn1W

12/05/2025

Hi,

Today, I will be teaching you on how to convert from a short date to a long date in Excel.

Steps:

1. Highlight the date you want to convert.

2. Locate your number group under the home tab ribbon.

3. Click the drop-down.

4. Find your long date and click.

5. Repeat the same steps to get back your short date. In this case you will have to click your short date instead.

Enjoy it.

Link to my video course:

https://bit.ly/3ELsn1W

You can repost my video if you want to.