Getting Answers from Data using Excel for Mac or Windows

Data analysis with Excel Pivot tables, filtering and more. Real-world case studies for data-informed decision making

Created by: Carol Jacoby
Excel for Decision Makers

What Will I Learn?

• Draw hidden insights from any data file: counts, totals, sweet spots, similarities, rankings and more
• Design and apply a PivotTable to best answer any particular question, whether numerical or yes/no.
• Make data-informed personal and business decisions
• Merge disparate data files into a form for easy analysis
• Focus and organize your data to surface answers using sort, filter and PivotTables
• Apply various Excel tools to organize data and get answers, including sort, filter, PivotTables, VLOOKUP, formulas, conditional formatting and more.
• Perform data mining, clustering and segmentation using Excel

Requirements

• Basic familiarity with Excel. If you've used it for a list, for example, you're good to go.
• Any version of Microsoft Excel on any platform. I'm using a Mac with specific instructions for Windows in the few places the interface differs.
• A desire to draw answers out of a mess of data

Target audience

• Anyone with data who is looking for answers
• Busy decision makers who are more interested in getting answers than in learning a tool