Glad to see good news about Chartered Accountants through #ICAN left and right yesterday.
May this be the beginning of elevated blessings and favours.
For those still having papers, keep pushing. You're almost there and yours shall also be of celebration soon.
ERROR Proofing
Not all Excel errors mean the same
#N/A: Lookup can’t find the value (VLOOKUP, INDEX drama)
#VALUE!: Wrong data type or invalid operation (text+number wahala)
Use IFNA to handle #N/A
IFERROR catches invalids result
Errors aren’t mistakes but signals
#ExcelTips
Family of IF (Conditional) Functions in @msexcel
IF: single condition logic
IFS: multiple conditions, cleaner than nesting
IFERROR: handle any error gracefully
IFNA: handle only #N/A errors
SUMIF: add values by 1 condition
SUMIFS: add values by multiple conditions
👇🏾
#ExcelTips
Dear Data Analysts,
This week is about Pivot Table, a quick summary engine in @msexcel and the secret weapon 🚀 for Data Analyst.
Let's talk about some 5 unique features, check my first comment and let me know which feature of Pivot Table has been helpful to you
👇🏾
@DAAXRasheed@msexcel I used to think you can only perfom custom calculations via DAX only to Pivot Table until I learnt that you can also use calculated fields direcrly without using the measure and it works perfectly just like measures also.
👍 for this
We don't only donate data we also donate blood ✨
Happy International Blood Donor Day🩸to all unsung heroes saving lives with their precious blood
1 pint can save up to 3 lives
If you're fit, kindly donate & be the hero someone desperately needs
#GiveBloodSaveLives
Claim 100% FREE @Microsoft Exam Vouchers through Microsoft #Fabric Data Days 2026
Eligible exams
DP-600
DP-700
DP-800
To qualify you must be a member of a Fabric Community like @Fabric_UG_Naija
Request a voucher here: https://t.co/rsHBzCy3xW
For other details, check thread 👇🏾
Dear Data Analyst
There is a clear difference between .xlsx (A) and .xls (B) file extensions in @msexcel
- A is the latest version from 2007 upward & B was used from 93 - 2023
- A has 1,048,576 rows and 16,384 columns but B has 65,536 rows and 256 columns only
Save wisely