Send bulk emails with different attachments - Excel

I was assigned a task where I had to find a way to send bulk emails to customers. That part was easy. So, I was taking it easy. BUT comes the catch.. There were some conditions...not all attachments should be sent to everyone. Based on the nature of a candidate, the attachments should be assigned dynamically. Example: Person 1 should get only attachment 1, 2 & 3 and Person 2 should get attachments 1 & 2. At first I thought it was a crazy requirement for Excel. But

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

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.