Search

Who joined meeting late and who left early? - Microsoft Teams

During our face to face meetings, we can track the late comers and early leavers of the meeting. Quite embarrassing for someone to enter late right? I have done that a lot ☺️ Also, if you are the meeting host and a member leaves early, it gets you thinking "Am I boring?" Have you been in such a situation? Let me know 😏 I received a request from a client to find these elements out from Teams meeting. If you are a organiser of the meeting, you ca download the log one your meet

Create Macros - Without ANY CODE!

Yes this is possible! Its inbuilt in Excel itself. All you have to do is do a couple of clicks and your macro is ready! So, I had to create a very complex macro for a project and was going crazy. Me being super lazy thought that there has to be another way. Its MICROSOFT! And...I was right. There is a brilliant way which can be used. Ensure that you have your developer tab enabled and don't forget to save your file in Macro Enabled format. Create macro as shown in the video i

NO FORMULAS! Concatenate First & Last Name - Detect pattern - Excel

Excel can scare people with its extensive use of formulas. Yes, it is great. No doubt about that. But it can get overwhelming for some. So, Microsoft has a function called Flash Fill which is AMAZING! It ca detect patters in your column and replicate that. You can even use it to create Invoice No's and so much more! Check out its use to concatenate first and last name without any formulas! Pretty great right? Every time I explore Excel I learn something new. Is this also the

Save Space in your Dashboard - Simple Trick!

I always face an issue of being short of space while creating dashboards in Power BI as I keep looking at doing things differently and exploring other visuals. I hope I am not alone. Let me know if you are like me :) So, here is a simple trick that will help you save some space. That's like us doing multi-tasking. One human, tons of tasks with urgent deadlines :) The trick is to use our famous slicer which is already available in BI. No need to add from the marketplace. Keep

How to get next week and last week date in Power BI? QUICK AND EASY WAY!

If you are new to Power BI then DAX and Queries can get a little confusing. Well, it did for me. If it didn't bother you then I guess you are a genius! :) So, the task assigned to me was to get all data ranging between last week Tuesday to next week Monday. Sounds crazy right? Well, your solution is right here. Use a simple function - WeekDay() to get next week (Monday) and last week (Tuesday) date in Power BI! You can use this in several ways to get data from date ranges. Do

Input box on click of dropdown and update cells - EXCEL

To be honest, I really struggled with this! I had to display an input box in Excel when user selects a specific value AND update another cell with the current values stored AND replace the cells with values entered by the user. Confused? Well, so was I when this requirement was received! Check out this video for how this can be achieved. Basically, when user selects "Rescheduled" from the dropdown, we need to capture the existing dates in "Remarks" column and replace the exis

Easy Ways to Enter Data in Excel

Why spend hours preparing Do's and Don'ts, SOP, Guidelines document to tell your staff what and how data needs to be entered in Excel? Don't blame your staff if the data entered is not as per the required guidelines! Help them record data more efficiently and become more productive. Guide user at every cell - every step of the way without any document! AMAZING!! Right? Okay, I won't waste your time. This video shows some simple tricks which you can use - Say NO to Do's and Do

Missing Corporate Files? Not anymore with this FILE TRACKER! - Excel!

I am sure you must be having this issue at work where the files go missing and you end up spending HOURS looking for that ONE FILE! Very frustrating right? Well, here we have come to you with a quick and easy solution using only your mobile and Excel! Simply scan the QR code and get the details auto updated in excel from sender and receiver. Its as simple as that! Two steps and you will NEVER have to look for files again! Step 1 - Sender scans the QR code from mobile camera.