Ukeme Tom

Directions Website Contact the business

Ukeme Tom Excel Templates Design & Automation Expert
School Reports | Hospital Records | Business Finance Dashboard.
08032632639

𝗘𝗫𝗖𝗘𝗟 𝗙𝗨𝗡𝗖𝗧𝗜𝗢𝗡𝗦, 𝗙𝗢𝗥𝗠𝗔𝗧𝗧𝗜𝗡𝗚 & 𝗞𝗘𝗬𝗕𝗢𝗔𝗥𝗗 𝗦𝗛𝗢𝗥𝗧𝗖𝗨𝗧𝗦 𝗧𝗛𝗔𝗧 𝗥𝗘𝗣𝗟𝗔𝗖𝗘S 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗙𝗢𝗥𝗠𝗨𝗟𝗔𝗦 (𝗣𝗧𝟮)Welcome back to this very important...
30/06/2026

𝗘𝗫𝗖𝗘𝗟 𝗙𝗨𝗡𝗖𝗧𝗜𝗢𝗡𝗦, 𝗙𝗢𝗥𝗠𝗔𝗧𝗧𝗜𝗡𝗚 & 𝗞𝗘𝗬𝗕𝗢𝗔𝗥𝗗 𝗦𝗛𝗢𝗥𝗧𝗖𝗨𝗧𝗦 𝗧𝗛𝗔𝗧 𝗥𝗘𝗣𝗟𝗔𝗖𝗘S 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗙𝗢𝗥𝗠𝗨𝗟𝗔𝗦 (𝗣𝗧𝟮)

Welcome back to this very important tutorial on 𝗘𝘅𝗰𝗲𝗹 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀, 𝗙𝗼𝗿𝗺𝗮𝘁𝘁𝗶𝗻𝗴 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀, 𝗮𝗻𝗱 𝗞𝗲𝘆𝗯𝗼𝗮𝗿𝗱 𝗦𝗵𝗼𝗿𝘁𝗰𝘂𝘁𝘀 𝗧𝗵𝗮𝘁 𝗖𝗮𝗻 𝗥𝗲𝗽𝗹𝗮𝗰𝗲 𝗖𝗼𝗺𝗽𝗹𝗲𝘅 𝗙𝗼𝗿𝗺𝘂𝗹𝗮𝘀 𝗮𝗻𝗱 𝗘𝘃𝗲𝗻 𝗦𝗮𝘃𝗲 𝗬𝗼𝘂 𝗮 𝗟𝗼𝘁 𝗼𝗳 𝗧𝗶𝗺𝗲.

If you missed part 1 of this tutorial, I strongly recommend that you scroll back to see it. Today, we share more examples.

Here we go!

𝟰. 𝗣𝗶𝘃𝗼𝘁 𝗧𝗮𝗯𝗹𝗲𝘀 (𝗥𝗲𝗽𝗹𝗮𝗰𝗲𝘀 𝗠𝗮𝗻𝘆 𝗦𝘂𝗺𝗺𝗮𝗿𝘆 𝗙𝗼𝗿𝗺𝘂𝗹𝗮𝘀)
Instead of Using:
SUMIFS()
COUNTIFS()
AVERAGEIFS()
Multiple lookup formulas

A Pivot Table can instantly calculate and analyze your data in different criteria.
To create a Pivot Table
Select data.
Press: Alt + N + V, Click OK.

𝟱. 𝗦𝗼𝗿𝘁 𝗮𝗻𝗱 𝗙𝗶𝗹𝘁𝗲𝗿 (𝗥𝗲𝗽𝗹𝗮𝗰𝗲𝘀 𝗟𝗼𝗴𝗶𝗰𝗮𝗹 𝗙𝗼𝗿𝗺𝘂𝗹𝗮𝘀)
Instead of Using:
IF()
FILTER()
Complex lookup formulas

Filter Shortcut
Ctrl + Shift + L

𝟲. 𝗖𝗼𝗻𝗱𝗶𝘁𝗶𝗼𝗻𝗮𝗹 𝗙𝗼𝗿𝗺𝗮𝘁𝘁𝗶𝗻𝗴 (𝗥𝗲𝗽𝗹𝗮𝗰𝗲𝘀 𝗜𝗙 𝗦𝘁𝗮𝘁𝗲𝗺𝗲𝗻𝘁𝘀)
Instead of Using:
=IF(B2>100000,"Target Met","Target Not Met")
Select data.
Home → Conditional Formatting.
Choose:
Greater Than
Less Than
Top 10
Data Bars

𝟳. 𝗗𝗮𝘁𝗮 𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻 (𝗥𝗲𝗽𝗹𝗮𝗰𝗲𝘀 𝗜𝗙 𝗘𝗿𝗿𝗼𝗿 𝗖𝗵𝗲𝗰𝗸𝘀)
Data validation controls what users can enter.
Example
Allow only:
Dates
Whole numbers
Dropdown list
Shortcut: Alt + A + V + V

Alright, practice those examples while you follow this profile for part 3 of this tutorial.

You can pre-order this ebook 𝙀𝙭𝙘𝙚𝙡 𝙂𝙪𝙞𝙙𝙚 𝙛𝙤𝙧 𝘽𝙚𝙜𝙞𝙣𝙣𝙚𝙧𝙨 for only ₦3,500. Once it is launched, the price goes up to ₦5000.

The book contains all the lessons you need to work confidently in Excel as a beginner, covering Formulas and their uses, Conditional Formatting, Custom Number Formatting, how to solve Excel Formula Errors, and so much more.

Chat me on WhatsApp +2348032632639
to book your copy now.

For a private Excel class at your convenience, talk to me at +2348032632639; let's fix it.

WHY YOU SHOULD GET A LICENSED OFFICE 365Look at the 2 pictures and see the difference. I made this automated attendance ...
26/06/2026

WHY YOU SHOULD GET A LICENSED OFFICE 365

Look at the 2 pictures and see the difference. I made this automated attendance register for a school.

Picture 1: An automated time book with checkboxes. All the staff need to do is click on the checkbox, and the time will be recorded

Picture 2: Same template, but the staff have to type 1 in the cell instead of clicking on a checkbox.

The reason I had to redo the second template is that the checkbox feature is not available in my client's version of Microsoft Office.

I thought of many ways to fix it with formulas, but none worked. Finally, I applied common sense, replaced the checkbox with 1 for present and an empty cell for absent. And then edited the timestamp formulas to replace TRUE/FALSE with 1/"".

Now, imagine having to go through the pain of redoing this in 12 worksheets for Jan to Dec. Not to mention the time wasted. If not for my keyboard shortcut skills, it would have been a whole day's job.

You see why you need to step up and get a licensed Microsoft Office 365? There are many other interesting features that make work just easy, but you cannot get them in the pirated and outdated Office versions.

The same goes with PowerPoint and Word.

Send me a WhatsApp chat at +2348032632639
I will help you get your license ASAP.

𝗪𝗛𝗬 𝗔𝗥𝗘 𝗬𝗢𝗨 𝗔𝗙𝗥𝗔𝗜𝗗 𝗢𝗙 𝗘𝗫𝗖𝗘𝗟 𝗙𝗢𝗥𝗠𝗨𝗟𝗔𝗦?I feared mathematics in secondary school and avoided it. The scariest word to me th...
24/06/2026

𝗪𝗛𝗬 𝗔𝗥𝗘 𝗬𝗢𝗨 𝗔𝗙𝗥𝗔𝗜𝗗 𝗢𝗙 𝗘𝗫𝗖𝗘𝗟 𝗙𝗢𝗥𝗠𝗨𝗟𝗔𝗦?
I feared mathematics in secondary school and avoided it. The scariest word to me those days was “PROBLEM.” Why give it to me? I have many problems already.
Now, that is what is happening to new users of Excel.
Many new Excel users fear the word 𝗙𝗢𝗥𝗠𝗨𝗟𝗔. Once you mention formula, their heart skips 2 bits. And in their minds, they’re saying, “Oh, please, not again. I thought we were done with this in school already.” Formulas to them mean 𝗠𝗔𝗧𝗛𝗘𝗠𝗔𝗧𝗜𝗖𝗦.
But here’s the good news.
You don’t have to use scary complex formulas all the time. There’s another way. The easy way.
Excel provides several built-in functions, formatting tools, and keyboard shortcuts that can achieve similar results faster and with less complexity.
Here are some of the 𝗘𝘅𝗰𝗲𝗹 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀, 𝗙𝗼𝗿𝗺𝗮𝘁𝘁𝗶𝗻𝗴 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀, 𝗮𝗻𝗱 𝗞𝗲𝘆𝗯𝗼𝗮𝗿𝗱 𝗦𝗵𝗼𝗿𝘁𝗰𝘂𝘁𝘀 𝗧𝗵𝗮𝘁 𝗖𝗮𝗻 𝗥𝗲𝗽𝗹𝗮𝗰𝗲 𝗖𝗼𝗺𝗽𝗹𝗲𝘅 𝗙𝗼𝗿𝗺𝘂𝗹𝗮𝘀 𝗮𝗻𝗱 𝗘𝘃𝗲𝗻 𝗦𝗮𝘃𝗲 𝗬𝗼𝘂 𝗮 𝗟𝗼𝘁 𝗼𝗳 𝗧𝗶𝗺𝗲.
Here we go!
𝟭. 𝗙𝗹𝗮𝘀𝗵 𝗙𝗶𝗹𝗹 (𝗥𝗲𝗽𝗹𝗮𝗰𝗲𝘀 𝗧𝗲𝘅𝘁 𝗙𝗼𝗿𝗺𝘂𝗹𝗮𝘀)
The Flash Fill function automatically extracts, combines, or formats text based on a pattern you provide. It does a whole lot of work, especially when you understand how to use the Fill Series.
Instead of Using:
• LEFT()
• RIGHT()
• MID()
• CONCATENATE()
• TEXT()
𝙀𝙭𝙖𝙢𝙥𝙡𝙚
Suppose a list contains:
Full Name
John Smith
Mary Jones
To extract first names:
1. In the next column, type John
2. Press Ctrl + E
3. Excel automatically fills the remaining cells.
𝟮. 𝗔𝘂𝘁𝗼𝗦𝘂𝗺 (𝗥𝗲𝗽𝗹𝗮𝗰𝗲𝘀 𝗦𝗨𝗠 𝗙𝗼𝗿𝗺𝘂𝗹𝗮)
This keyboard shortcut automatically calculates totals.
Instead of Using:
=SUM(B2:B20)
𝙀𝙭𝙖𝙢𝙥𝙡𝙚
1. Select the cell below the numbers.
2. Press:
Alt + =
3. Press Enter.
𝟯. 𝗤𝘂𝗶𝗰𝗸 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗧𝗼𝗼𝗹
One of the best tools in Excel. It does instant calculations (SUM, AVERAGE, COUNT, Percentage totals, etc.), charts, tables, and conditional formatting.
The Keyboard Shortcut is
Ctrl + Q
𝙀𝙭𝙖𝙢𝙥𝙡𝙚
Simply select a range of numbers and press Ctrl + Q to access the Quick Analysis Tool.
Alright, practice those examples while you follow this profile for parts 2 and 3 of this tutorial.
You can pre-order this ebook 𝙀𝙭𝙘𝙚𝙡 𝙂𝙪𝙞𝙙𝙚 𝙛𝙤𝙧 𝘽𝙚𝙜𝙞𝙣𝙣𝙚𝙧𝙨 for only ₦3,500. Once it is launched, the price goes up to ₦5000.
The book contains all the lessons you need to work confidently in Excel as a beginner, covering Formulas and their uses, Conditional Formatting, Custom Number Formatting, how to solve Excel Formula Errors, and so much more.
Chat me on WhatsApp 08032632639
to book your copy now.
For a private Excel class at your convenience, talk to me 08032632639 let's fix it.

24/06/2026

Knowing how the Facebook algorithm works won't allow you to promote stupid posts. Every comment you make increases its visibility.

𝗖𝗔𝗡 𝗜 𝗟𝗘𝗔𝗥𝗡 𝗘𝗫𝗖𝗘𝗟 𝗔𝗡𝗗 𝗕𝗘 𝗣𝗥𝗢𝗙𝗜𝗖𝗜𝗘𝗡𝗧 𝗜𝗡 𝟭 𝗪𝗘𝗘𝗞?We spent the whole of our childhood, 5-12 years, learning the English lang...
15/06/2026

𝗖𝗔𝗡 𝗜 𝗟𝗘𝗔𝗥𝗡 𝗘𝗫𝗖𝗘𝗟 𝗔𝗡𝗗 𝗕𝗘 𝗣𝗥𝗢𝗙𝗜𝗖𝗜𝗘𝗡𝗧 𝗜𝗡 𝟭 𝗪𝗘𝗘𝗞?

We spent the whole of our childhood, 5-12 years, learning the English language. Then spend the rest of our lives trying to perfect our writing and speaking fluency in English.

But when it comes to learning a skill that will pay you for life, you want to do it in haste. You want to know Excel and be proficient in complex formulas and all of it in 1 week. That's not possible.

𝗘𝘅𝗰𝗲𝗹 𝗵𝗮𝘀 𝗼𝘃𝗲𝗿 𝟱𝟬𝟬 𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀, with more than 𝟭𝟬𝟬𝟬 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗳𝗼𝗿𝗺𝘂𝗹𝗮𝘀 available, depending on the version and updates.

𝗕𝘂𝗶𝗹𝘁-𝗶𝗻 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀: The latest versions of Excel include 500+ functions that cover a wide range of operations, including mathematical, statistical, logical, and text manipulation functions

𝗖𝗼𝗺𝗽𝗿𝗲𝗵𝗲𝗻𝘀𝗶𝘃𝗲 𝗟𝗶𝘀𝘁𝘀: Some sources indicate that there are over 1000 working Excel formulas when considering all the variations and combinations of these functions. This includes advanced functions like VLOOKUP, XLOOKUP, FILTER, and others that enhance data analysis capabilities.

𝗩𝗲𝗿𝘀𝗶𝗼𝗻 𝗦𝗽𝗲𝗰𝗶𝗳𝗶𝗰𝘀: For instance, Excel 2021 alone has over 470 functions, showcasing the extensive capabilities of the software

You don't need to learn all the formulas. But anything you learn in a hurry, you're bound to make mistakes at work. You cannot confidently deliver a good job with the skill because you're not grounded in it.

And that is why it is important to stay focused and learn one good skill and upgrade your knowledge gradually till you become a pro at it.

Start today. Dedicate the next 6 months to learning Excel from scratch. Don't miss a day without opening the worksheet to apply one of the lessons you've learnt.

Do this for 6 months straight, and you will see a big difference.

Ready to learn Excel?
Hit me up on WhatsApp 08032632639
or Email: [email protected]

I am your reliable private Excel tutor.

𝗛𝗢𝗪 𝗧𝗢 𝗠𝗔𝗞𝗘 𝗠𝗢𝗡𝗘𝗬 𝗢𝗡𝗟𝗜𝗡𝗘 𝗔𝗦 𝗔 𝗖𝗢𝗠𝗣𝗨𝗧𝗘𝗥 𝗡𝗢𝗩𝗜𝗖𝗘 (Pt 2)Hi people,Welcome to part 2 of this tutorial.If you did not read the...
06/06/2026

𝗛𝗢𝗪 𝗧𝗢 𝗠𝗔𝗞𝗘 𝗠𝗢𝗡𝗘𝗬 𝗢𝗡𝗟𝗜𝗡𝗘 𝗔𝗦 𝗔 𝗖𝗢𝗠𝗣𝗨𝗧𝗘𝗥 𝗡𝗢𝗩𝗜𝗖𝗘 (Pt 2)

Hi people,
Welcome to part 2 of this tutorial.

If you did not read the 1st part, it is important to do so.
Now, as I said, you don't need to be a perfect techie to start making money online. All you need is the willpower and basic digital skills to start.

Follow these simple steps:
𝗦𝘁𝗲𝗽 𝟲: 𝗙𝗶𝗻𝗱 𝗖𝗹𝗶𝗲𝗻𝘁𝘀
You can get clients through:
LinkedIn networking
Facebook groups
WhatsApp status marketing
Referrals from friends and family
Freelancing websites
Every day, contact potential clients and showcase your portfolio.

𝗦𝘁𝗲𝗽 𝟳: 𝗗𝗲𝗹𝗶𝘃𝗲𝗿 𝗘𝘅𝗰𝗲𝗹𝗹𝗲𝗻𝘁 𝗪𝗼𝗿𝗸
To get repeat business:
Meet deadlines
Communicate professionally
Follow instructions carefully
Deliver quality work
Satisfied clients often recommend you to others.

𝗦𝘁𝗲𝗽 𝟴: 𝗜𝗻𝗰𝗿𝗲𝗮𝘀𝗲 𝗬𝗼𝘂𝗿 𝗥𝗮𝘁𝗲𝘀
As your experience grows:
Add new skills
Improve your portfolio
Collect testimonials
Charge higher fees
Many successful freelancers started with small projects before earning substantial monthly income.

Alright, there you have it. Don't finish reading and do nothing.

Ready to begin this journey? Send me a direct message or
WhatsApp me on 0803 263 2639


𝘼 𝙥𝙧𝙤𝙛𝙚𝙨𝙨𝙞𝙤𝙣𝙖𝙡 𝙗𝙖𝙨𝙞𝙘 𝙙𝙞𝙜𝙞𝙩𝙖𝙡 𝙨𝙠𝙞𝙡𝙡𝙨 𝙩𝙪𝙩𝙤𝙧.

𝗚𝗘𝗧 𝗢𝗥𝗜𝗚𝗜𝗡𝗔𝗟 𝗢𝗙𝗙𝗜𝗖𝗘 𝟯𝟲𝟱 𝗟𝗜𝗖𝗘𝗡𝗦𝗘 𝗙𝗢𝗥 ₦𝟰𝟬𝗞 (𝟯𝟬 𝗨𝗦𝗗) 𝗔𝗡𝗗 𝗦𝗛𝗔𝗥𝗘 𝗔𝗠𝗢𝗡𝗚 𝟱 𝗢𝗙 𝗬𝗢𝗨𝗥 𝗧𝗘𝗔𝗠 𝗠𝗘𝗠𝗕𝗘𝗥𝗦When I tell those who know the v...
04/06/2026

𝗚𝗘𝗧 𝗢𝗥𝗜𝗚𝗜𝗡𝗔𝗟 𝗢𝗙𝗙𝗜𝗖𝗘 𝟯𝟲𝟱 𝗟𝗜𝗖𝗘𝗡𝗦𝗘 𝗙𝗢𝗥 ₦𝟰𝟬𝗞 (𝟯𝟬 𝗨𝗦𝗗) 𝗔𝗡𝗗 𝗦𝗛𝗔𝗥𝗘 𝗔𝗠𝗢𝗡𝗚 𝟱 𝗢𝗙 𝗬𝗢𝗨𝗥 𝗧𝗘𝗔𝗠 𝗠𝗘𝗠𝗕𝗘𝗥𝗦

When I tell those who know the value of a Microsoft Office 365 License that my price is ₦40k, they scream and ask if it is original.

But those who don't know the value would price me 10k.

This original Office 365 licence is like having a premium and verified LinkedIn profile, plus a premium Google account combined.

Some of you just know about a few popular Microsoft Office applications like Word, Excel, PowerPoint, Access, and Outlook.

Office 365 has about 20 Apps in the package. Including

𝗧𝗲𝗮𝗺𝘀, which is like Slack & Zoom: for messaging, video conferencing, and real-time collaboration.

𝗦𝗵𝗮𝗿𝗲𝗣𝗼𝗶𝗻𝘁, which is just like Trelo & Asana: a web-based platform for document management, intranet sites, and team collaboration

𝗣𝗼𝘄𝗲𝗿 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲, which is just like Make: used for automating workflows across apps and services.

𝗣𝗼𝘄𝗲𝗿 𝗕𝗜: Business intelligence and data visualization tool.

And the almighty
𝗢𝗻𝗲𝗗𝗿𝗶𝘃𝗲: Cloud storage with a whopping 1 TB of space for backing up your files, sharing, and synchronization.

Apart from the number of Apps, you also enjoy access to the newest Office features, such as the Filter, Sequence, Xlookup, and Checkbox functions in Excel.

The most interesting part is that you can share one license among 5 users across different devices.

As you may already know, the prices of things don't remain the same for 5 years.

I started selling Office 365 when it was 10k in 2022. Now, it is 40k. But you can also get it for 150k from another vendor. Same package.

Now, let me warn you.

If you find this Microsoft Office 365 anywhere for 20k, it is a single-user package. They have sold 5 of your accounts to other users.

Save my WhatsApp number +2348032632639
Get your licensed Office ASAP. The longer you wait, the higher the price.

𝗛𝗢𝗪 𝗧𝗢 𝗠𝗔𝗞𝗘 𝗠𝗢𝗡𝗘𝗬 𝗢𝗡𝗟𝗜𝗡𝗘 𝗔𝗦 𝗔 𝗖𝗢𝗠𝗣𝗨𝗧𝗘𝗥 𝗡𝗢𝗩𝗜𝗖𝗘 (Pt 1)Internet money is sweet. We are in the digital age, and you'll hear ...
03/06/2026

𝗛𝗢𝗪 𝗧𝗢 𝗠𝗔𝗞𝗘 𝗠𝗢𝗡𝗘𝗬 𝗢𝗡𝗟𝗜𝗡𝗘 𝗔𝗦 𝗔 𝗖𝗢𝗠𝗣𝗨𝗧𝗘𝗥 𝗡𝗢𝗩𝗜𝗖𝗘 (Pt 1)
Internet money is sweet. We are in the digital age, and you'll hear "𝙩𝙝𝙚 𝙞𝙣𝙩𝙚𝙧𝙣𝙚𝙩 𝙞𝙨 𝙩𝙝𝙚 𝙣𝙚𝙬 𝙤𝙞𝙡". Yes, it is.

The internet has created opportunities for people with simple digital skills to earn money from home.

People who work from home with a computer and internet to solve problems for clients outside their location are called Freelancers.

You do not need to be a programmer or a cybersecurity expert to get started. You just need to know the basics first, and then grow from there.

Follow these simple steps:
𝗦𝘁𝗲𝗽 𝟭: 𝗟𝗲𝗮𝗿𝗻 𝗮 𝗩𝗮𝗹𝘂𝗮𝗯𝗹𝗲 𝗗𝗶𝗴𝗶𝘁𝗮𝗹 𝗦𝗸𝗶𝗹𝗹
Start with beginner-friendly skills that businesses need every day, such as:
Microsoft Excel
Microsoft Word
Data Entry
Canva Design
Social Media Management
Google Workspace (Docs, Sheets, Forms)
Virtual Assistance
Online Research
PDF Editing and Conversion
Choose one skill and focus on becoming good at it before learning others.

𝗦𝘁𝗲𝗽 𝟮: 𝗣𝗿𝗮𝗰𝘁𝗶𝗰𝗲 𝗬𝗼𝘂𝗿 𝗦𝗸𝗶𝗹𝗹
Knowledge alone does not generate income. Practice regularly by:
Creating sample Excel spreadsheets
Designing social media flyers with Canva
Formatting documents in Word
Creating Google Forms and reports
Build confidence by completing small personal projects.

𝗦𝘁𝗲𝗽 𝟯: 𝗖𝗿𝗲𝗮𝘁𝗲 𝗮 𝗣𝗼𝗿𝘁𝗳𝗼𝗹𝗶𝗼
A portfolio is proof of your ability.
Examples:
Excel dashboards
Data entry samples
Canva designs
Word document formatting projects
Save your best work in Google Drive or as a PDF.

𝗦𝘁𝗲𝗽 𝟰: 𝗦𝗲𝘁 𝗨𝗽 𝗬𝗼𝘂𝗿 𝗢𝗻𝗹𝗶𝗻𝗲 𝗣𝗿𝗲𝘀𝗲𝗻𝗰𝗲
Create professional accounts on:
LinkedIn
Facebook
WhatsApp Business
Freelancing platforms such as Upwork and Fiverr
Use a professional profile picture and clearly state the services you offer.

𝗦𝘁𝗲𝗽 𝟱: 𝗦𝘁𝗮𝗿𝘁 𝗢𝗳𝗳𝗲𝗿𝗶𝗻𝗴 𝗦𝗲𝗿𝘃𝗶𝗰𝗲𝘀
Begin with simple services such as:
Data entry
Excel spreadsheet creation
Document typing and formatting
Canva flyer design
PDF conversion
Virtual assistance
Do not wait until you are perfect. Start with small jobs and improve as you gain experience.

Now, take the first step. Choose a basic digital skill to learn. Ready to begin this journey? Send me a direct message or
WhatsApp me on 0803 263 2639


𝘼 𝙥𝙧𝙤𝙛𝙚𝙨𝙨𝙞𝙤𝙣𝙖𝙡 𝙗𝙖𝙨𝙞𝙘 𝙙𝙞𝙜𝙞𝙩𝙖𝙡 𝙨𝙠𝙞𝙡𝙡𝙨 𝙩𝙪𝙩𝙤𝙧.

𝗘𝗫𝗖𝗘𝗟 𝗙𝗢𝗥𝗠𝗨𝗟𝗔  #𝗘𝗥𝗥𝗢𝗥𝗦: 𝗖𝗔𝗨𝗦𝗘𝗦 𝗔𝗡𝗗 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 (Pt 2)Hi evryone,Welcome to part 2 of this very important tutorial.Excel fo...
02/06/2026

𝗘𝗫𝗖𝗘𝗟 𝗙𝗢𝗥𝗠𝗨𝗟𝗔 #𝗘𝗥𝗥𝗢𝗥𝗦: 𝗖𝗔𝗨𝗦𝗘𝗦 𝗔𝗡𝗗 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 (Pt 2)

Hi evryone,
Welcome to part 2 of this very important tutorial.

Excel formula errors can be very annoying, and they can be even worse if you don't know the cause.

Knowing the problem is the first step to finding the solution. So, let's share the causes of error in Excel formulas and their solutions.

Shall we?

7. !
Cause: Excel returns when it finds the wrong type of data in a calculation.

Example: =B8+A8
where A8 contains text instead of a number.

Solution:
• Ensure all values involved in calculations are numeric.
• Remove unnecessary spaces.
• Convert text numbers to real numbers.

8. !
Cause: Invalid numeric values or impossible mathematical calculations.

Examples: =SQRT(-1) or =A9^B9
(result too large for Excel)

Solution:
• Check formula arguments.
• Avoid calculations that exceed Excel's numeric limits.

9. ! (only in Excel 365 and Excel 2021)
Cause: This happens when a dynamic array formula cannot return results because cells in the spill range are occupied.

Example: =SEQUENCE(10)
While cells below already contain data.

Solution:
• Clear obstructing cells. Create enough room for your data.
• Move the formula to an empty area.

10. ! (Available in Excel 365 and Excel 2021)
Cause: Excel encounters a calculation problem within a dynamic array formula.

Example:
=FILTER(A1:A10,B1:B10="Yes")
When no records match, and no alternative result is specified.

Solution:
• Review the formula logic.
• Add an optional result argument.

The Correct Formula should be:
=FILTER(A1:A10,B1:B10="Yes","No Results")

========================================
Pre-order my E-book Excel Tutorial for Beginners for ₦5000 only.
It contains all the basic Excel skills you need to learn.
========================================

11. ! (Excel 365)
Cause: It means Excel cannot recognize or retrieve a field from a linked data type.

Solution:
• Verify the field name.
• Refresh the linked data source.
• Select the correct data field.

12.
Cause: Excel is retrieving information from an external source.

Solution:
• Wait for the data retrieval to finish.
• Check internet or network connectivity.
• Refresh the connection if necessary.

13. !
Cause: Excel blocks access to external content, linked files, or data connections for security reasons.

Solution:
• Enable trusted content.
• Verify workbook security settings.
• Confirm external sources are trusted.

14. !
Cause: Excel has lost connection to an external data source.

Solution:
• Check internet access.
• Verify server or database availability.
• Refresh the connection.

15. !
Cause: Excel cannot identify a function, data type, or external service.

Solution:
• Update Excel.
• Verify the formula syntax.
• Check compatibility with your Excel version.

16. !
Cause: Excel is waiting for a service or external calculation to complete.

Solution:
• Wait for processing to finish.
• Refresh the workbook (press F9) if necessary.

Alright, there you have it.

You can pre-order my E-book Excel Tutorial for Beginners for ₦5000 only. It contains all the basic Excel skills you need to learn.

For one-on-one Excel training, WhatsApp +2348032632639

02/06/2026

Hi people,
I hope you practiced the solution to some of the Excel errors posted yesterday. Part 2 of the tutorial is coming soon.

Address

Uyo Itam

Alerts

Be the first to know and let us send you an email when Ukeme Tom posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Ukeme Tom:

Shortcuts

Share