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.