Recently, I have been working on many projects that entail rigorous record keeping.  Having used Microsoft Excel on a daily basis for many years now, I consider myself to be pretty advanced when it comes to spreadsheets.  Some people in my office even refer to me as the Sultan of the Spreadsheet (actually, I made that up, but you get the point). But no matter how cocky I get when it comes to manipulating columns and rows, I am always finding new ways of making Excel work harder for me.

Over the next few blog posts, I will highlight some of my favorite tricks that I use to make my Excel experience more efficient and enjoyable, especially in a marketing environment.

Tip #1: Hide Rows and Columns -

Now, most of you are probably saying to yourselves “He’s kidding right?  I hide rows and columns in my sleep.” Don’t worry; I will offer some more advanced tips as we go.  Regardless, hiding rows and columns is a great way to remove unnecessary clutter on your worksheet without deleting important data. This is often the first step I take when working with a spreadsheet because it simplifies everything after that. Trust me, it may take some time up front, but it will save time in the end.

Tune in to my next two posts where I will uncover some more advanced Excel tricks that I use on a daily basis.