At the end of this course you will be able to:.These powerful techniques have been in Excel for a long time. If you’ve used Excel for anything-making a list or adding up a column of numbers-you’re good to go. That’s why most of the time you spend in this class will be hands on, doing case studies of personal and business issues.Īll you need is a basic familiarity with Excel. The complexity comes from applying these seemingly simple techniques to real-life problems. Find the 20% that gives you 80% of the value.
Summarize it by one factor, then quickly try another. Immediately start exploring your data with sort and filter. Your data may be in inconsistent pieces or have extraneous information, and you’ll learn how to fix that. First you will structure the data to make finding answers quick and flexible. You will learn to turn your mess of data into answers, decisions, and action. You will learn PivotTables, sorting, filtering, VLOOKUP, formulas and more. Do the hands-on case study challenges and experience the power of these simple analytical techniques. You will be given sample spreadsheets for real-world personal and business case studies. You will be surprised at the powerful analysis that can be done with simple spreadsheets, including data science techniques like data mining, segmentation, and clustering.
Getting Answers from Data using Excel brings you the best techniques for slicing and dicing your mess of data until the insights fall right out of it.
0 kommentar(er)
