I work with Excel so often that I forget that things I do all the time and take for granted may not be widely known or used.  Today is yet another example.  While working on a client spreadsheet I did something that made my client exclaim and stop me mid-stream to show him what I had done. We were working on multiple sheets in a workbook - actually it was his Paypal transactions and we were preparing sheets for each month.  He had already started the sheets and I was putting in

We do a lot of spreadsheet reporting against a variety of data environments - for example ACT, Quickbooks, and other SQL vertical applications.  By default, Excel does not automatically refresh the data connections when you open the file.  You need to "turn on" this option.  Note, if the data being imported is a large amount, this will mean it will take longer to open your Excel file - which is why it is turned off by default. Here's what you do to turn it on.  

While practicing for my upcoming Virtual Roadshow, I noticed that when I went into Remote Desktop to access my virtual machine, it was not truly going full screen. Well, that was a bummer. I closed the remote desktop session and when I clicked on the Remote Desktop icon to restart it, I decided to click on the Options button to see if I could resolve this issue.  Sure enough, when I clicked on the DISPLAY tab, there was a slider bar that was not all the way to the right.  Once I

Today's quick blog article will talk about a favorite formula string I use time and time again.  If you read my blog, you know I use Excel as my tool of choice for data manipulation. My challenge today was to find and match emails in two columns.  What I wanted to do was weed out emails that were duplicated in both columns.   I used a formula and will explain it below. Let's use the following list as my example: Column A Column B Column C This email address is being protected from spambots. You need JavaScript enabled to view it.  

Sometimes it's the little things that matter.  You work with a software program for so long that you "assume" someone else knows the tricks and tips.  Ah, yes, you know what they say about assuming.  Well, it happened again.  While working with a client showing them my Company Wizard Plus add-on for ACT, I did one of my favorite tricks and the client went - "whoa, stop right there - what did you just do."  I had hit Ctrl A to highlight all contacts in the list. &

First off, let me say that asking and ANSWERING questions on Linkedin is a very good thing. I asked a question a few days ago about whether or not people were moving to Windows 8. Got interesting and great answers. I thought I would share them with you. http://www.linkedin.com/answers/technology/information-technology/computers-software/TCH_ITS_CMP/1065938-459965