Excel - The Foundations for Great Analysis

Does your team have the Excel skills required to do the basics? Excel is a an important tool for most analysts, sales people, category managers, and business people in general. And everyone knows Excel, right? Or do they? Without basic Excel skills, sales people and category managers can't effectively analyze their business (never mind draw insights from it), administrators can't create great worksheets, and analysts may struggle with fundamental concepts. Never mind the risk of making errors and drawing incorrect conclusions from poorly built formulas and PivotTables. So why is Excel training a requirement for organizations when there are automated reports that should give everyone everything they need for their business? Because they don't (and can't!) meet all needs. The reality is, most meaningful analysis requires data manipulation, cutting, formatting and customizing - and that requires some strong foundational Excel skills. A few months ago, a client of mine contacted me about the need for some training in Excel skills for one of their sales teams. A sales manager had raised a concern that her team was not able to perform certain Excel essentials like formula writing, building PivotTables and creating charts. It was surprising to hear that proficiency in these skills was lacking on her team because, after all, everyone knows Excel, right? After a collaborative meeting with her, I developed a virtual training session that included some Excel basics like moving around in a spreadsheet and sorting data, writing formulas and conditional formulas (SUM, COUNT, RANK, UNIQUE), and creating charts and PivotTables. The session was "opt in", meaning that folks who already had proficiency in these areas didn't need to attend. THE RESULTS? I ran two 3-hour sessions for the client because of the high interest (and remember, this was "opt in", meaning they had the choice of whether or not to attend). The hands-on exercises and examples were particularly relevant for her sales team, using data and item rank reports - not just creating formulas, but also helping to think about interpretation of the different KPI's, as well as getting participants to think about what the formulas are actually calculating. We used one of their massive automated reports to build a PivotTable - moving them from learning to application - using examples from their own business. The training became, not just conceptual, but practical! Here's some of the (unedited) feedback from these sessions: Best 3-hour lecture/class I’ve attended. Time went by way too quickly! I learned many new things, i.e., formula building, shortcuts, and importance of being clear on what I’m trying to say. Handouts were helpful, and I will go back to reference them. Ask your team if they need Excel basics training! You might be surprised by their response. Learn more about Excel Virtual Team Training
Read More