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)