Being the 115th ranked general Excel blog on the internet sure has a nice ring to it. Well deserving of your e-mail subscription (located in the bottom right hand corner) if I was to be rather James Blunt about it. But what good is a rank if there are multiple categories to be considered?
If repetition is the key to mastery, repeating an activity the wrong way is a killer in disguise. A countless waste of hours dedicated to a mundane task. Fortunately, Excel is intended to avoid such things, and the distance between getting it done and being a master is much shorter than you may realize.
Undoubtedly you have called a function a formula and a formula a function; it's just the nature of the Excel-lingo beast. That stops now. I want you to see functions for what they truly are: computer programming. You may feel like you are not yet ready to call yourself a computer programmer - but you are. And I want to get you from here - to here - not through keyboard shortcuts but by taking the things that you are currently doing and giving you you the knowledge and confidence to know why you are doing them.
The founding fathers of Multiplan intended that spreadsheets would be for everyone: the rich and the poor, the data analyst and the data scientist, the sighted and the vision impaired. Often, things that we take for granted make a world of difference to others. Take the appropriate steps now to ensure that your work is up to accessibility standards.
It's Dangerous To Go Alone! Take This.
With every passing second of every minute, of every hour - you are in a constant race against time. Trying to find time to exercise, to spend time with friends or family, or read the latest Excel TV article. Managing your schedule becomes even more important in the age of information. More data means more analysis, which means more reports. Either you beat the clock, or the clock beats you. But not everything is what it seems when it comes to time...
Not since the great territory battles of 7-Eleven Vs. Quiktrip, has there been such an unparalleled rivalry: "VLOOKUP or INDEX/MATCH?"A seemingly innocent question, when asked among Excel users, gives you a general perception of one another. There is one function's inability to turn left and the others reliance on multiple functions for use. One's perceived simplicity vs. the others perceived complexity. Are we so divided, though that we are unable to recognize the benefits found within each function? I'm unsure.. but I know neither function is willing to surrender their position without a fight.
