Muigai Mwaura (@automation254) header
Muigai Mwaura (@automation254) profile picture

Software Engineer | Sharing tips, tricks and scripts | Excel | GoogleSheets Lover of all things tech and coffee. DMs open.

Nairobi, Kenya
Joined January 2023
Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)Photo by Muigai Mwaura (@automation254)
πŸ”₯#Excel Data Import: The Trifecta Unleashed!πŸ”₯ Discover how to harness web pages, PDFs, and images like a pro in our latest tutorial video! πŸ’» Web? πŸ•ΈοΈ Snagged it! πŸ“„ PDF? πŸ“š Cracked it! πŸ–ΌοΈ Image? πŸ“Έ Deciphered! Your data game is about to level up! πŸš€ #DataAnalytics
1
5
26
10,764
Another great use of the MOD function. If you have not started using it...you are missing out BIG TIME! #excel #hr #acccounting #crispExcel #exceltips
1
28
1
113
17,783
Quit analyzing data like it's a contract with the devil. Let conditional formatting highlight what matters.
1
5
1,611
πŸ“Š Why scrutinize your spreadsheet for trends like you're picking a partner for life? Learn how to use conditional formatting in Excel to highlight your best and worst performers in a snap πŸš€.
1
5
6
1,493
Learn how to make Excel your unpaid intern for tracking project tasks, deadlines, and leave – all with one killer formula. In just 30 seconds, you'll learn how to: Crunch those deadlines like a pro πŸ’Ό Effortlessly track leave 🌴 Never miss a due date again ⏰
2
2
229
πŸš€ STOP wasting time with #Excel like it's 1999! Do you want to learn a simple trick that will save you time and impress your boss? Find out to use a shortcut in Excel to sum up multiple tables of data in seconds. Just one keystroke and you’re done!
2
3
298
How old were you when you found out that: 1. Text function can accept an array of Values 2. Text function can accept an array of formats =TEXT(Dates,{"dddd","mmmm","yyyy"}) If you did not know...now you know!😎 #excel #exceltricks #acccounting #hr #india #excelformulas
3
58
2
213
50,700
Do you want to learn how to visualize data using stunning and informative maps in Excel? 🌎 Watch the video to see how easy it is to select your data, insert a map, and make it look awesome πŸ’ͺ
3
12
2,524
Do you know how to solve loops problem using Excel functions? Join Free Webinar on Saturday 22nd to learn more. π‘πžπ π’π¬π­π«πšπ­π’π¨π§ 𝐒𝐬 𝐟𝐫𝐞𝐞 𝐟𝐨𝐫 𝐚𝐧𝐲𝐨𝐧𝐞.Β  To secure your spot lnkd.in/eFjKUwZr #EXCEL_Challenge #programming
1
1
3
4,203
Do you want to learn how to stop people from messing up your Excel spreadsheet? ⚠ I’ll show you how to restrict data entry to a predefined list using data validation. This way, you can avoid having garbage data in your Excel Sheets.
1
4
17
2,313
How to Paste Excel Data into Word and Keep it Synced Effortlessly! No more copy-pasting, no more errors, no more stress!
4
12
1
58
5,893
Want to master Pivot Tables in Excel with zero effort? πŸ™Œ Β There's a magic button that can do it for you in seconds! The lightning bolt icon, It’s like having a genie in your spreadsheet. Just click, choose and boom - you’re done. 😎 Learn this trick and rock your data
1
2
234
Are you looking for a Youtube Channel with great content? Look no furtherπŸ‘‡πŸ‘‡ and Subscribe😎 youtube.com/@crispexcel #exceltips #exceltricks #india #hr #acccounting
1
3
1
12
3,475
Do you want to learn how to make your data analysis faster and smarter than ever? Of course, you do! That's why I've created a new video for you, where I show you five ways using Tables in Excel can transform your spreadsheet skills.
1
8
1
23
5,059
How to Make Your Data Pop with Excel: 3 Easy Tricks You Need to Know: * How to create a people graph to show how happy your customers are πŸ“ŠπŸ˜ƒ * How to use data validation to keep your data clean and organized πŸ“…πŸ”’ * How to add sparklines to see sales trends at a glance πŸ“ˆπŸš€
1
127
How to Return Multiple Items using INDEX Function Does anyone know a more condensed formula other than the below combination of -INDEX -SMALL -IF -ROW? #excel #exceltips #cheatsheets #programming
1
49
1
144
29,731
πŸ“ˆ Struggling with Excel formulas? 😩 You need ChatGPT, the AI-driven assistant that makes data analysis easy and fun. πŸ€–πŸ‘¨β€πŸ’Ό πŸŽ₯ Don’t miss this game-changing video that’ll transform your office life forever. youtube.com/watch?v=8hID4nY0…
2
5
1,378
Effortlessly calculate deadlines, leave, and due dates, all while excluding weekends and holidays! πŸ’‘ Use WORKDAY to: 1️⃣ Nail project deadlines with precision 🎯 2️⃣ Streamline employee leave management πŸ–οΈ 3️⃣ Keep your invoice due dates in check πŸ’Έ
2
11
19
2,278
πŸ”— Connect the dots: Pair WORKDAY with other date functions like EOMONTH and NETWORKDAYS to create comprehensive, dynamic, and insightful time-based reports! πŸ“Š #DataAnalysis #ExcelPro
1
103
πŸ”„ Adapt & thrive: Need to work with custom weekends or unique work schedules? Use WORKDAY.INTL to handle non-standard work weeks and keep your calculations on point! πŸ“… #ExcelTips #FlexibleScheduling
93