How To

5 Ways to Use Your Outlook Calendar to Improve Productivity

If you’re using your Outlook calendar like it should be hanging on a wall, you’re likely missing out on the many benefits that come with using an e-calendar tool. Your Outlook calendar is the office assistant you didn’t know you had: it can organize your time, assign tasks to your co-workers, and schedule meetings on your behalf, among other things.

Read now

Automatically Run VBA Code Upon Opening an Access Database

Access has the ability to run an Access object’s VBA code automatically whenever the object (form, report, etc.) is opened. It also has the ability to automatically open a designated form when the database launches. Combining these two means VBA code within a form can be automatically run when the database opens.
Read now

Useful URLs For Creating VBA Code

There are a multitude of online resources to help you develop your Visual Basic for Applications (VBA) skills. Here are a few core links, referenced in Beezix’s VBA 2016 Introduction quick reference guide, that will enhance any VBA project you take on. 
Read now

Refining Searches in macOS

Updated to include macOS Big Sur. Most searches on your Mac can be done quickly and easily by clicking  and typing either the name of or a word contained within the file you need. Sometimes, though, a more refined search is...

Read now

A First Date with Excel: Entering Dates

Excel features a special format for dates. Unfortunately, some people find out about how Excel formats dates only after dates hadn’t been entered properly. Perhaps an invoice gets sent out on December 1 instead of January 12 because the day and month were reversed. Or maybe you can’t sort that data you collected because the dates weren’t entered properly.
Read now

Changing Your System Date Settings

Changing your operating system’s regional settings — whether it’s a PC or Mac — allows you to see and enter dates in a way that is familiar to you. In Excel, for instance, entering dates will be different based on the regional settings.

Read now