CDATips

Outlook and Inbox Zero: You can do it!

Skip the Pain, Go Right to Inbox Zero

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… Keep Reading

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… Keep Reading

New Text Box Shortcut works in PowerPoint, Word and Excel

Keyboard Shortcut for New Text Box

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… Keep Reading

Three Easy Ways to Add a New Page to OneNote Notebooks

Create a New Page in OneNote

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… Keep Reading

When Excel Columns become Numbers instead of Letters…

Using the R1C1 Cell Reference Style

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… Keep Reading

Say Adiós to the Mini Toolbar in Word

Turn Off the Mini Toolbar in Microsoft 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… Keep Reading

Converting Number data to AutoNumber data in Access

Access-Convert-Number-Datatype-to-AutoNumber-Datatype

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… Keep Reading

Primary Keys and Foreign Keys in Access

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… Keep Reading

Password Protect Macros in Excel

Password Protect Macros

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… Keep Reading

Encrypt Excel with a Password

Excel Password Encryption

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… Keep Reading