Mastering Data Analysis in Excel

Improving market researchers’ skills and knowledge in Excel

Overview
As a researcher with a client waiting for a deliverable, whether your challenge is navigating through a vast set of figures or calculating results to chart them, you are very likely to, at some point, end up working in Excel.

This course therefore takes you through the challenges that are often specific to market researchers, looking at:

• Navigating and collating data from tables
• Simple steps to consider in table design and specifications
• Using raw data to drive aggregations and charting
• Preparing data for advanced analysis
• Manipulating and managing data for both display and delivery

The course is run in a small group to ensure there are opportunities to engage personally – and you are encouraged to come with specific issues and cases that can be used as examples. We will also review the fundamental principles of data management to help define ways of working with data in your day-to-day roles. A short pre-class survey will help to prioritise areas of focus.

Please bring your own laptop – training can be tailored to suit different Excel versions but is based on modern versions of Office 365.

Learning outcomes:

• Efficient ways of using Excel in common market research contexts
• The broad scope of Excel’s powerful capabilities
• Easy ways to solve common problems and source solutions: tips, shortcuts and techniques
• Troubleshooting common issues and understanding how spreadsheet errors can be avoided
• Improved understanding and confidence in working with Excel
• How to source future support and help

Who will benefit:
Anyone who uses Excel regularly at a basic level and would like to improve their skills and confidence in either working more efficiently or learning about new methods and opportunities with Excel.