Gili

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

Last update: October 2019. Here’s a question we just got for a reader: Hello there, i am a travel agent, and would like to define a custom email template to answer emails that my customer send me. I also would like to speed up my appointment scheduling process and have a template i can use … Read more

Here’s a question we got from a reader: I am trying to figure out macro development from going through code examples in your website. I figured out that some of the examples point out to the developer menu in Microsoft Excel, Word and Outlook. For some reason, i don’t see that menu item in the … Read more

Last update: December 2019. Here’s a question from a reader: I am using Microsoft Office 365. I have noticed that after i click on a specific email entry in the Outlook Mail tab and open it for reading, it shows as read. What’s annoying is that i have noticed that items that i view in … Read more

Here’s a question from a reader: Just finished to setup Outlook in my computer, and started to get some emails from different people. One thing i notice is that i started also to receive those small black alerts that keep popping up on my Windows 10 desktop. I don’t recall those appearing on Windows 7. … Read more

Applicable to Microsoft Office 365, 2019 and older. Windows operating Systems. Here’s a question we got from a reader: I have a need to automatically resize all images stored in a specific presentation I have to prepare for my management. As the slides are quite standard, this looks like something I could automate using a … Read more