![]() This job title exists solely to reward those of you who have built up enough number crunching credit to make your employer realize that if they promote you to a manager, they lose, and if they don't promote you at all, you can leave at any time. Enter the Lead Analyst (also called a head analyst, chief analyst, or executive analyst if where you work is incredibly far up it's own ass). ![]() Once your company has taken the bait, they may realize that you are a true elite operator, and that the loss of your abilities would result in a substantial drain on your business' intelligence. ![]() It is taken as evidence that you are a literal wizard, and you can't train a muggle to do magic.It misleads your company into believing that what you do is complex. ![]() This unlikely confluence of events generally begins after the fifth or sixth time that you've been asked to write a step-by-step tutorial showing how you built a specific report, only to find out that if written out in a truly step-wise fashion would take up 16 pages, and thus would never EVER be looked at. However, for those of you who have demonstrated such overwhelming nuance of technique that your company fears the loss of your truly awe-inspiring abilities more than they love adhering to the Peter Principle, there may indeed be another road. As stated in a previous post, generally you're likely to get promoted into a management position, where you no longer need your formidable skills of analysis, and they too, like all good things, will atrophy to nothingness. Now, with my obscure reference quota filled for the day, let's assume that you've been working as an analyst for some time now. Excel Data Manipulation: a Guide For Everyoneįirst things first, 10 points to anyone who understands what the title is referring to (that's either Charles Atlas' workout philosophy, or one of core tenants of Bokononism in Kurt Vonnegut's standout Cat's Cradle).How I Stopped Worrying and Learned to Love the Formula.Adventures in Excel: Power to the Pivot.Taking Out the Trash: Dirty Data in Excel.Getting Iffy With it: Conditional Statements in Excel.Yes.If(And)): Excel’s Mighty “IF” Statement.Your Invitation to the Excel Pivot Party.Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel.Create an Iterative List in Excel Without Any Real Coding.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |