1. Browse
  2. Business Skills
  3. Technology
  4. Microsoft
  5. Answers from Data: Excel PivotTables, More + Case Studies

Answers from Data: Excel PivotTables, More + Case Studies

Answers from Data brings you the best techniques for slicing and dicing your mess of data until the insights fall right out of it. You will be surprised at the powerful analysis that can be done with simple Excel spreadsheets, including data science techniques like data mining, segmentation, and clustering. You will be given sample spreadsheets for real-world personal and business case studies. Do the hands-on case study challenges and experience the power of these simple analytical techniques. You will learn PivotTables, sorting, filtering, VLOOKUP, formulas and more.

172 Enrolled (3) Beginner

Course Goal

  • Draw hidden insights from any data file: counts, totals, sweet spots, similarities, rankings and more
  • Design and use a PivotTable to make data-informed decisions in real-world case studies
  • Apply various Excel tools to organize data and get answers, including sort, filter, PivotTables, VLOOKUP, formulas, conditional formatting and more
  • Merge, unmerge, organize and bin data for fast and meaningful Excel analysis

Who This Training Is For

  • Consultants
  • Executives and Managers
  • IT/Business analysts
  • Project Managers
  • Project team members


  • Formal final exam (timed and graded,see sample SAP exam)
  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Answers from Data: Excel PivotTables, More + Case Studies certificate

How students rated this courses


(Based on 3 reviews )



Carol Jacoby

Analyst and Instructor | Serving Technical Managers and Decision Makers | Turning data into actionable insights

4.8 Instructor Rating

I turn data into actionable insights. I can help you move decisively through your most knotty or slippery problem, whether it has too much data, too little data, too many unknowns, or too many constraints. I’m an instructor and consultant in data science, decision analysis, Excel for analysts and decision-makers, statistics for Six Sigma, systems engineering, and more. I’m the author of the book "Simple Spreadsheets for Hard Decisions," which teaches leaders to use the interactive features of Excel to explore ever-changing questions. I’ve taught these powerful techniques to technical managers at major corporations and government agencies through short courses at major universities. Now, after 20 years, I’m bringing these simple but strong tools to a general audience through the Udemy class series, “Excel for Decision Makers.” The first is now available, “Insights from Data using Excel.” 

I love doing mathematics research. I have a Ph.D. in mathematics with several recent research papers in peer-reviewed journals and a graduate-level text, “Abelian Groups: Structures and Classifications” (with Peter Loth, de Gruyter, 2019). Before founding Jacoby Consulting, I had 28 years of experience as a systems engineer specializing in the critical early stages of system development. 

Specialties: Data science, decision analysis, systems engineering, systems-of-systems, assessment of needs, concept development, mission analysis, concept effectiveness, system simulation, system trade studies, Microsoft Excel, writing, briefing, training, motivational speaking, intelligent transportation systems, defense, mathematics research in abelian group theory and logic.

View Details

What's Included?

  • Language : English
  • Level : Beginner
  • Duration : 2.5 Hrs
  • Type : Instructor-led
  • Releases :
  • Category : Technology

Training 5 or more people?

Unlimited access for your entire SAP team.


Related Courses

SAP Fiori - End User

SAP Fiori - End User

  • 3h 56m
  • Beginner
4.6 (360)
Macros and VBA in Excel for Beginners

Macros and VBA in Excel for Beginners

  • 3h 56m
  • Intermediate
4.6 (5)
Basics of SAP S/4HANA

Basics of SAP S/4HANA

  • 3h 56m
  • Beginner
4.8 (31)
Introduction to SAP Business Partner Operating in ...