If you work a lot with spreadsheets, you know how difficult they can be once you get beyond simple tables and equations. And you know that data entry can be boring beyond belief. The more complex the table, the more confusing it is to evaluate. Shouldn’t there be quicker and easier way to do some of these tasks? Microsoft Excel has a lot of nifty shortcuts that can help relieve the tedium of data entry and provide clarity with complex tables. Here are six features built into Excel 2016 that can ease creating spreadsheets and understanding the ones you (and other people) create. And after those six, I’ll treat you to 20 keyboard shortcuts that – if you can memorize them – will make your jobs lighter. Some of these tricks will be found in earlier versions of Excel; others are exclusive to Excel 2016. Remember that if you subscribe to Office 365, you currently have Excel 2016. Tell Me What You Want To Do Do you always remember how to create a pie chart, freeze the left-hand column, or name a range? I didn’t think so. Excel’s “Tell me what you want to do” can help you complete a chore even … Read More
You can add and maintain more than one email account in Microsoft Outlook and easily bounce from one to another. Here’s how. Do you use Microsoft Outlook but have more than one email account? Instead of separately checking your messages from your primary account and your Gmail account and any other mail accounts, you can add them all to Outlook and access each one from the same application. The process of adding multiple accounts isn’t difficult, and once you’ve set them up, you then have a single spot in which you can check all your email. I set up my primary email account, my Gmail account, and an account for one of my clients all under the umbrella of Outlook. That gives me easy access to all my email and allows me to use Outlook’s robust, built-in features with each account. Let’s say you haven’t yet configured Microsoft Outlook with any accounts. Open Outlook. Click Next to get past the intro screen. Then answer Yes to the question: Do you want to set up Outlook to connect to an email account? Next choose the option for Manual setup or additional server types. Outlook asks if you want to use an … Read More
Your PST file contains all your Outlook email, so you need a safe and reliable way to back it up on a recurring basis. A little backtracking, for those of us who haven’t run across this term before. If you use Microsoft Outlook for your email, your PST files contain all your messages, calendar events, contacts, and other data. As the PST file is critical, you need a way to back it up on a regular basis in case something goes kerflooey with the live file. You can then always retrieve the backup, whether to locate an individual e-mail that’s been lost or deleted or to recover the entire PST file in case it gets corrupted. Outlook itself offers no way to back up the file, but you can turn to a couple of free utilities to do the work. Microsoft provides a free program called Personal Folders Backup, which sets itself up as an add-in for Outlook and can automatically back up your PST file at regular intervals. The drawback with Personal Folders Backup is that it works only with older versions of Outlook up to the 2010 edition. But no cause for worry. Those of us who run Outlook 2013 … Read More
Here’s the challenge: You use both Microsoft Outlook and Google for your calendar appointments, and you need a way to keep both of them in sync. Google once offered a free utility to sync your Gmail calendar with your Outlook calendar, but that tool has since bit the dust. So does that mean you’re out of luck? Nope — you can accomplish the same trick with help from a couple of third-party utilities. One free tool called Outlook Google Calendar Sync can keep your Outlook and Google calendars on the same path. Another utility known as Calendar Sync can also synchronize both calendars. Before we look at both tools, let’s just clarify one item. When I say Outlook, I’m not talking about the Outlook.com email service; I’m referring to the full version of the Microsoft Outlook email client that comes with Microsoft Office. Outlook currently is part of Office 2016 and Office 365. I’ve run Outlook for years and currently use the 2016 version through an Office 365 subscription. I also use Google for Gmail, as well as for my calendar appointments and contacts. So I’ve always needed a way to keep my Outlook and Google calendars in sync. In … Read More
Microsoft’s macro-programming language, Visual Basic for Applications (VBA), can automate many of your regular MS Word chores. Here’s an introduction to creating simple and useful macros — without the work of learning to be a full-on programmer.