Author: CDATips

Outlook and Inbox Zero: You can do it!

As I’ve taught people how to use Microsoft Outlook over the years, I’m constantly amazed by the number of people who report physical symptoms when checking their email. One common thread is that so many people are overwhelmed by email that they report physical symptoms when checking their email, up to and including hyperventilating. The good news is that you can take control over Outlook, and you can whip it into shape. The goal is commonly termed Inbox Zero, and …

Outlook and Inbox Zero: You can do it! Read More »

Excel Rules for Creating Formulas and Functions

There are lots of rules out there in the world, and we don’t always follow them. Most everyone I know has broken the speed limit at some point, and I hear some people are actually eating laundry detergent recently (ugh!). There are clearly marked speed limits on the side of every highway, and I trust there must be a label on the side of detergent boxes that says do not consume. But breaking those rules isn’t necessarily going to ruin …

Excel Rules for Creating Formulas and Functions Read More »

Tagged with: , ,

New Text Box Shortcut works in PowerPoint, Word and Excel

Many users feel condemned to using the mouse to hunt and peck through the Microsoft Ribbon. They just don’t know a better way! Today’s tip is going to drill down on one shortcut, how to add a new text box in Microsoft PowerPoint, Word or Excel using the keyboard. Once you have the program open and are ready to perform this technique, just press the Alt key and the letter N at the same time, then let go of those …

New Text Box Shortcut works in PowerPoint, Word and Excel Read More »

Tagged with: , , , , ,

Three Easy Ways to Add a New Page to OneNote Notebooks

It’s wonderful when things in life are simple, and few things are easier than creating a new page in a OneNote notebook. It’s so easy, there are three different ways to do it! Method 1: Click the Add Page button at the top of the Page Tabs pane. (The blue panel in the image.) Method 2: Right-click anywhere in the Page Tabs pane. (The blue panel in the image.) Method 3. Press the Control key and the letter N at …

Three Easy Ways to Add a New Page to OneNote Notebooks Read More »

When Excel Columns become Numbers instead of Letters…

aka Turning the R1C1 Address Option On and Off A client called me a while back with a terrifying problem: all of the column letters in Excel had become numbers and she had no idea how it got that way or how to write formulas anymore. Rest assured, it was not the beginning of the robot rebellion, and we were able to get her back up and running right away. The problem was that R1C1 notation had gotten accidentally turned …

When Excel Columns become Numbers instead of Letters… Read More »

Tagged with: , , ,

Say Adiós to the Mini Toolbar in Word

The Mini Toolbar in Microsoft Word is one of those features that you either love or hate. It pops up when you have text selected, and it offers a shortcut to the most common text formatting features in the Home tab of the Ribbon. Before you turn it off, of course, you want to be certain you don’t like it. To see if the Mini Toolbar is active on your installation of Microsoft Word, just select a few words of …

Say Adiós to the Mini Toolbar in Word Read More »

Tagged with: ,

Converting Number data to AutoNumber data in Access

The AutoNumber data type is one major advantage of using Access. You can let the computer keep track of things like the next customer number to be assigned whenever a new record is created. If you read my article Primary Keys and Foreign Keys in Access, you know how important it is to have unique key fields. Another advantage of Access is the ability of the program to import data from Excel and other delimited data files. That way, if …

Converting Number data to AutoNumber data in Access Read More »

Primary Keys and Foreign Keys in Access

One of the first concepts that new users of Access have to wrap their head around is that of keys. A key is a way of connecting one record in a database with another record. Just like you have a different key for your car, your house and your office, each record will have a different key. Having the key gives you access to the record. Simple, right? Even though some people resist the idea — “I am not just …

Primary Keys and Foreign Keys in Access Read More »

Tagged with: , , ,

Password Protect Macros in Excel

I confess that today’s tip was motivated by a student asking a question in a recent class. During a discussion about all of the different ways you can password protect a document, the question was asked about how to password protect just a macro. This technique will allow you to protect your macro code from snoops and ne’er-do-wells, but still allow the document to be opened without a password AND the macro will run without a password. In order to …

Password Protect Macros in Excel Read More »

Encrypt Excel with a Password

The most complete protection you can provide an Excel document is Password Encryption. It requires that someone have your password before they can open or view your workbook, and it is virtually bullet-proof. I’m not aware of any ways you can break into an encrypted Excel workbook, but I wouldn’t put it past some cyber-fiend to find a way! That being said, two critical cautions come to mind: Don’t forget your password. There is NO password recovery feature. Don’t give …

Encrypt Excel with a Password Read More »

Tagged with: ,