User Question I’m managing a project timeline in Excel and need to calculate the duration in months between start and end dates. Some projects span multiple years, and I want to account for partial months. How can I accurately calculate this in Excel, both using formulas and VBA, especially when dealing with multiple projects? Find … Read more
Here’s a question from a colleague: I’ve received a spreadsheet containing employee information, including their start dates. However, these dates are in text format and use different styles (e.g., “01/15/2023”, “15-Jan-2023”, “2023-01-15”). I need to convert all these text entries to proper Excel date format for analysis and reporting. How can I efficiently standardize these … Read more
User Question: “I’m working on a presentation for my research project, and I need to cite various bibliography sources throughout my slides. How can I effectively add references to my PowerPoint presentation without cluttering the slides? Is there a way to manage and format these citations properly?” Step-by-Step Instructions: This guide will walk you through … Read more
If you often find yourself converting Excel reports to PDF format and manually typing in the current date to keep your file versions in order, you will find this trick pretty useful. We will use VBA (Visual Basic for Applications) to automate this task, saving you time and reducing the risk of errors. #1: Prepare … Read more
In this short tutorial we will learn how you can use Visual Basic for Applications (VBA) to automate the saving of your Excel 365 spreadsheet. Our code will assign a custom file name, consisting of a prefix concatenated with the current date and time. Macro to save workbook with VBA Step #1: Prepare your Excel … Read more
One of the best ways you can represent numerical data is by using bar graphs. For instance, if you want to represent a trend that has been growing over time, using a bar graph will make it much easier for the audience to understand than leaving the numerical data in tables. Fortunately, it is very … Read more
Here’s a question from a reader: I use Microsoft 365 Excel for data entry purposes. Once i have the data ready in the spreadsheet i would like to create different charts: pie, bars and so forth, all based on my dataset. It seems that by default no labels are posted in my Excel chart making … Read more
Going through the comments, i have seen a couple of reader questions on how to work with Visual Basic Input and Message boxes in PowerPoint. In this tutorial we’ll provide a very basic foundational knowledge to help you use those capabilities when automating your presentation creation. Setting up the Developer Tab First off, we’ll need … Read more
Applicable to Microsoft Outlook 365 / 2019 / 2016 Here’s a note we got from a reader: Thanks for your very useful Outlook coding help. I am wondering if you can share some code to help automate sending an email in Outlook 365? I know that there are several ways to send recurring message but … Read more
Here’s a question we just got from one of our readers: Hey there 🙂 I have Office Outlook 365 installed on my computer which is quite an upgrade from the previous email client i was using. But here’s the thing: Every once and then when i start Outlook on my Windows 11 laptop (which is … Read more