Learn something new every day!
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
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
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
As we fling emails back and forth at each other across the internet, we have also gotten sloppier with our typing. Unfortunately, the spelling and grammar police have not become any more forgiving. One of the most critical ways you are judged is by your spelling and grammar in email. In a world where we… Keep Reading
Let’s face it; it’s happened to all of us. You need to edit a computer file that is only available as a PDF. Commence screaming, hair pulling and nail biting. Back in days of yore (pre-2013), you were severely restricted in your options, if not downright stymied. I can recall converting PDF documents to graphics… Keep Reading
Lots of Excel experts love to nest functions and formulas inside of each other. This is actually a great way to combine several calculations in one cell, but it can be downright confusing if you are looking at it without understanding the Orders of Operation. The most important mathematical symbols in Excel are the parentheses.… Keep Reading
If you loved going back to school time as much as I did when you were a kid, then you are going to love Microsoft OneNote. Remember that feeling of picking out just the right notebook each year? Should I go 3-ring binder or spiral? Scooby-doo or Flintstones? (Okay, so I guess I’m dating myself… Keep Reading
You may have already read my previous post on how to string text together in Excel. That technique has been around forever, but it is so… 1995. Modern Excel users know that there is a very powerful function built into Excel that makes stringing text together as simple as 1-2-3. Before we get started, let’s… Keep Reading
when I Save, Close and later Open a document. We’ve talked a lot about the power of styles in Microsoft Word in the last few weeks. They give you the ability to control the structure and the appearance of your document with just a few clicks. Today’s Tip, however, is about those times when your… Keep Reading
Just because an image is available on Google Images or Bing Images, does not mean you have permission to use it. Not only is it a violation of copyright and trademark laws, it is also morally wrong. Luckily, there are dozens, if not hundreds of sites that offer free, high-quality images for you to download.… Keep Reading
