Hello X,
Iβm Aderonke.....a Data Analyst who turns messy spreadsheets into meaningful insights.
By day: Working in Ikoyi / Banana Island
By night: Learning, building and sharing my journey.
On this page, I share:
Data analytics (Excel, dashboards, insights)
My Journey as 9-5er
@Shasheen_ Not him outsourcing emotional intelligence to his mum, but honestly..thatβs so intentional.
Men may not always have the words, but paying attention enough to know who will show up for you properly? That's Care. That's Effort. That's Love in a different language
πππππππππππ() or ππππππ():
Purpose: Joins multiple text strings into one.
Example: =πππππππππππ(π΄1, " ", π΅1)
π§ππ«π§():
Purpose: Formats numbers or dates as text.
Example: =π§ππ«π§(π1, "dd/mm/yyyy")
Follow me β€οΈ for more.
πΌππππ():
Purpose: Returns the value of a cell based on row and column numbers.
Example: =πΌππππ(π΄1:πΆ10, 2, 3)
πππππ():
Purpose: Searches for a value and returns its position in a range.
Example: =πππππ("Product B", A1:A10, 0)
HLOOKUP():
Purpose: Searches for a value in the first row and returns a value in the same column from another row.
Example: =πππππππ("Sales", A1:F5, 3, FALSE)
πππππππ():
Purpose: Searches for a value in the first column and returns a value in the same row from another column.
Example: =πππππππ(π·1, π΄1:π΅10, 2, FALSE)