TheSpringPilot

The Spring Pilot is Where growth begins, and brilliance flows.
With us knowledge is not hoarded, it’s shared as Experience is not guarded, it’s gifted

[Abdur-Rasheed Adeoye @DAAXRasheed]

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.

[TheSpringPilot @thespringpilot]

@DAAXRasheed @msexcel Know this and build models with ease.

Next line of action is to understand the business and translate it into models ✋️😃

[TheSpringPilot @thespringpilot]

Thanks so much for this piece 👍

[Abdur-Rasheed Adeoye @DAAXRasheed]

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

[Abdur-Rasheed Adeoye @DAAXRasheed]

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

[TheSpringPilot @thespringpilot]

@DAAXRasheed @msexcel We've practically used all in one way or the other.

What about you 😃 ?

[Abdur-Rasheed Adeoye @DAAXRasheed]

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
👇🏾

[TheSpringPilot @thespringpilot]

@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

[TheSpringPilot @thespringpilot]

https://t.co/h3sI8VNGiG

We also made similar video to educate our audience

Thanks for this hack 👍

[Tips Excel @gudanglifehack]

✨Beginners vs Excel Expert 😱

#excel #office #spreadsheet

[TheSpringPilot @thespringpilot]

@Femiforge D off course

[TheSpringPilot @thespringpilot]

These are the Excel formulas used

Arabic Numerals
=SEQUENCE(20)

Roman Numerals
=ROMAN(SEQUENCE(20)

Ordinal Numbers

Control + 1
check superscript ✔️

[TheSpringPilot @thespringpilot]

PROFESSIONAL WAY OF NUMBERING IN EXCEL

Populate Arabic Numerals, Roman Numerals and Ordinal numbers as a professional in Excel.
check it out and give us your review
#dataanalyst #data #careergrowth #thespringpilot #creatorsearchinsights

[TheSpringPilot @thespringpilot]

Here you go 👍 😃

[>=40]"✅ "0;[<40]"❌ "0

[TheSpringPilot @thespringpilot]

STYLE UP YOUR REPORT WITH CUSTOM IN EXCEL

Check comment for the code.
Try it and give us your review

#dataanalyst #data #careergrowth #thespringpilot #creatorsearchinsights

[TheSpringPilot @thespringpilot]

@AdetunjiAbassi I like the line 😃

[TheSpringPilot @thespringpilot]

@DAAXRasheed @msexcel Category C ✔️

[Abdur-Rasheed Adeoye @DAAXRasheed]

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

[Abdur-Rasheed Adeoye @DAAXRasheed]

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 👇🏾

[Abdur-Rasheed Adeoye @DAAXRasheed]

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

[TheSpringPilot @thespringpilot]

@ezekiel_aleke Do we need INDEX-MATCH after XLOOKUP 😃 😊 🤣

[TheSpringPilot @thespringpilot]

@DAAXRasheed If 1 pin can save up to 3 lives
then 1,000 can save up to 3,000 lives

good one here sir 👏 👍