I was recently asked to give a 5-minute presentation on any Excel topic for a “Lunch and Learn” session. Five minutes?!?!? That is not much time. And besides, the Internet is chock-a-block full of Excel productivity tips, so how could I narrow it down to just one tip? Also, I knew very little about the… Read More »
Q. A client asked: If I’m on my local computer, and I delete a document from the server, the document disappears from the folder, but I don’t know where it goes. It’s not in the Recycle Bin on the server or the one in my computer. Why not? A. The way Windows works, only local… Read More »
Whenever I start on a new project, if it’s anything like past projects, it will be a safe bet that there is no written documentation for the Excel files the client is using. The users will do their best to explain it, then it will be up to me to go under the hood and… Read More »
The Question (long version) Here’s the question as posed by the client in his own words: I want to use Excel to calculate the total postage needed to mail packages of stuff to customers. So if they buy one medium T-shirt (10.7 oz) one large T-shirt (13.2 oz) and one pair of socks (2 oz) that all… Read More »
In most applications, Ctrl-Y is the keyboard shortcut for “Redo.” (This repeats the last action, or if the last action was Undo, then it undoes the undo, which I guess is indeed a repeat of the last action!) However, in the VBA Editor, Ctrl-Y deletes the current line of code, kind of like a more… Read More »
Do you ever send an email and forget to include the attachment you meant to attach? Here’s how to make sure that never happens again! If you’re using Outlook 2013… You’re already covered! This feature is new in Outlook 2013; it is turned on by default, but you can enable it or disable it. http://www.howtogeek.com/tips/how-to-enable-or-disable-the-forgotten-attachment-reminder-in-outlook-2013/… Read More »
Twice in the past few months, clients have asked me to look at a problem they encountered using an Access database file with Dropbox syncing. The users observed that multiple copies of the database were generated, with a suffix like “(Phil’s conflicted copy 1-24-2012)”. This is what Dropbox does when it finds that two different… Read More »
Remember when new computers came with their own installation disks for the operating system? They don’t anymore, but you still need them. You just have to make them yourself. Haven’t done this yet? Do it today, before you encounter a problem. Don’t know how? The instructions should be with the documentation that came with your… Read More »