The following Excel® tips are widely applicable to reducing time on business projects, whether they are finance- or IT-related. It’s never too late to learn a couple of new tricks, and one of them just might wind up saving you hours of precious time on your next project. I recently had a seasoned IT consultant tell me that one of the maneuvers I’m about to show you was “the best thing he has learned in all his years of consulting.” You may already know some of these, but if not, it might be worth it to bookmark this page, or at least print it out and file it away somewhere.
This article is outlined with the easy tips you might already know up front, and we end with the all too elusive “Go To Special”. If you are working with spreadsheets that contain thousands, or even millions, of rows of data, then the “Go To Special” information will prove to be a helpful tool if you need to change a large or small amount of that data based on any kind of logical behavior. We’ll focus on 7 different tips, none of which involve macros or Visual Basic whatsoever – they are purely ground-level functions and features of Microsoft Excel. >>SHOW ME!!