Pinned Tweet
π₯#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
Muigai Mwaura retweeted
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
Quit analyzing data like it's a contract with the devil. Let conditional formatting highlight what matters.
π 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 π.
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 β°
π 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!
Muigai Mwaura retweeted
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
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 πͺ
Muigai Mwaura retweeted
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
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.
How to Paste Excel Data into Word and Keep it Synced Effortlessly!
No more copy-pasting, no more errors, no more stress!
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
Three WhatsApp Features you need to know!
1οΈβ£ Become a Group Block Guru! π«
2οΈβ£ Find the perfect emoji in seconds on WhatsApp Web! π
3οΈβ£ Master the art of secrecy with Disappearing messages
linkedin.com/posts/muigai-mwβ¦
1
132
Muigai Mwaura retweeted
Are you looking for a Youtube Channel with great content?
Look no furtherππ and Subscribeπ
youtube.com/@crispexcel
#exceltips #exceltricks #india #hr #acccounting
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.
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
Muigai Mwaura retweeted
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
π 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β¦
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 πΈ
π 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



