Elibe Miriam||Virtual Assistant||Excel-focused
1.3K posts
@RiaShugar
I help executives, founders and decision makers stay organized, track performance and make decisions faster using data driven operational support.
I’m restarting my Excel for Data Analysis journey from the beginning Not because I don't know anything, but because I want to document everything and share my notes with fellow beginners If you're learning Excel, let’s grow together. My fellow Aspiring Data analysts are we in?
Tell me a story that sounds fabricated but is 100% true. (Nollywood industry edition) don’t air me 🥹⚡️
Day 3 of my 30-Day Excel Challenge with DataCamp. I’ll do a full breakdown tomorrow because NEPA took light while I was finishing my exercise on logical functions 🙂 But here’s a quick recap: Today I started the second course in the Excel Skill Track: Data Preparation.
day 2 of daily excel series to help you win the excel interviews yesterday we learned about text to columns feature and today I will show 3 very powerful text formulas that you'll definitely use every single time while cleaning messy data in analytics, you'll often need to merge or break down data this is where concat, textjoin & textsplit will help you → concat: to combine 2 or more string cells → textjoin: same as concat but more flexible → textsplit: same as text to columns feature but more dynamic few examples of how i use it at my analytics job i use python for web scraping but the code requires the product skus to be separated by a comma example: sku-001, sku-002 if i have a list of 1000 skus, i can't type quotes manually i use the concat formula & drag them for every cell =concat("sku-001", ",") this generates the exact format my code needs in seconds some times i have to combine a lot of cells by "-" let's say i need to combine 50 cell values =concat("a1", "-" , "a2", "-" , "a3"...... are you serious? this would take ages to do instead i use text join because i know every word just needs to be separated by "-" =textjoin("-", true, a2:a50) done & dusted isn't this one more flexible over concat formula? yesterday we learned text to columns textsplit is the formula version of that tool but what's the advantage of it over the text to column? it's dynamic so if your data changes, the split updates too using yesterday's example: id_101|dep_50 if this is in cell a2, i use: =textsplit(a2, "|") it automatically splits the id & department into two cells these 3 formulas look easier but you might get confused in between all of them in the interviews below i am dropping: → task sheet & dataset to solve → interview questions → youtube videos for reference -- → build in public: this series is about commitment post the task output & explain it to others about what you learned today (you can tag me for engagement) documenting your journey locks this knowledge in your mind forever + opens job opportunities if you have any doubts, drop them below i’m answering everything
day 1 of daily excel series to win the excel interviews real world data is always very messy and you just can't clean it manually one by one this is where text to columns will help you save a lot of time it is a feature that splits a single column of text into multiple columns based on specific rules there are two methods in it → delimited: splits text based on a character (comma, semicolon, space, or @) → fixed width: splits text based on a specific position (exanple: always cut after the 8th letter) few examples of how i use it at my analytics job sometimes i get messy dates such as 31-01-2026 21:59:57 but i only require dates in dd-mm-yyyy i use text to column to split the date & time part but by using the delimited method by splitting it with the empty space between both 31-01-2026" "21:59:57 whereas sometimes i use fixed width because i know, no matter what date it will be i will only require the first 12 characters from the left side also, sometimes i get mails like ayankhan@xyz(.)com i use the @ as a delimiter to separate the username from such domains to automatically get the names of the customers often, I get two ids joined by a hyphen or pipe (id_101|dep_50) i split these into separate "id" & "department" columns you'll use text to columns almost every single day at your job but for that you should be good enough when it comes to using it let me give you a task to practice copy/paste this into excel ⬇ 20240501;arun.v@xyz.com;prod_001 20240501;priya.s@xyz.com;prod_002 20240502;rahul.k@xyz.com;prod_003 the task is to split these into 3 columns: → date → email → product id i'm dropping interview question & youtube video tutorial ⬇ -- → build in public: this series is about commitment post the task output & explain it to others about what you learned today (you can tag me for better reach) documenting your journey locks this knowledge in forever + open job opportunities if you have any doubts, drop them below i’m answering everything
