Microsoft Office

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

Here’s a quick question we just got from a reader: I have educated myself on the topic of  developing VBA macros for Outlook using your tutorials. Now, i would like to run my newly created macro and i get a message stating that “Macros in this project have been disabled and and i should be … Read more

Here’s a question we got from a reader: Long time lurker, first time asking: Started to use Outlook 365 a couple months ago. Last week i started to notice some lagging in Outlook performance, which became quite slow to refresh my email (send / receive takes longer than usual, inbox syncronization is also somewhat slower). … Read more

Here’s a question from Kevin: Just starting out with Microsoft Access and looking into sample database i just built. Wanted to understand bit more about the procedure for exporting data from an existing table. I understand that if i am interested to apply some follow up analysis to the data using Python’s Pandas library, then … Read more

A couple days ago, a reader asked about there is a way to automate creation of PowerPoint presentations from scratch and then quickly add slides to that existing presentation. I though that script might be highly in the list of the most useful PowerPoint Macros.  As we indicated in the past, PowerPoint doesn’t include a … Read more

Here’s a question from a reader: Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel and lets you crunch data from different data sources at the same time. That sounds interesting.Looks like Power Pivot is missing in my system, as i don’t see it in my Excel 365 installation. How … Read more

Last Updated: July 2020. Here’s a question we got from a reader: I use my Outlook calendar to manage my business meetings and appointments, tasks and contacts; but also my personal appointments, as well as reminders to call friends on their birthday. As such i keep constantly getting reminders and notifications from Outlook on overdue … Read more