Download workbook: Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012: Topics in Video: 1. What is Data Analysis? ( min mark) 2. How Data Must Be Setup ( min mark) Sort: 3. Sort with 1 criteria ( min mark) 4.
Learn Mastering Data Analysis in Excel from Duke University. Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel for its own sake. We use Excel to do our calculations, and all math.
Sort with 2 criteria or more ( min mark) 5. Sort by color ( min mark) Filter: 6. Filter with 1 criteria ( min mark) 7. Filter with 2 criteria or more ( min mark) 8. Filter by color ( min mark) 9. Filter Text, Numbers, Dates ( min mark) 10.
Filter by Partial Text ( min mark) Pivot Tables: 11. What is a PivotTable? ( min mark) 12. Easy 3 step method, Cross Tabulation ( min mark) 13. Change the calculation ( min mark) 14.
More than one calculation ( min mark) 15. Value Field Settings ( min mark) 16. Grouping Numbers ( min mark) 17. Filter in a Pivot Table ( min mark) 18. Slicers ( min mark) Charts: 19.
Column Charts from Pivot Tables ( min mark) Formulas: 20. SUMIFS ( min mark) 21. Data Analysis Formula or PivotTables? ( min mark) 22. COUNTIF ( min mark) 23.
Formula to Compare Two Lists: ISNA and MATCH functions ( min mark) Getting Data Into Excel 24. Import from CSV file ( min mark) 25. Import from Access ( min mark) Highline Community College Professional Development Day 2012 Buy excelisfun products.
Curt Frye Curt Frye is the president of Technology and Society, Incorporated.He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including 'Rhetorical Mathematics' for CLE credit at the Law and Magic conference, 'Business Storytelling Using Microsoft Excel' at the ATD-Cascadia annual conference, and his Improspectives速 approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois. Chris Dutton Chris Dutton is a certified Microsoft Excel Expert and analytics consultant. Chris has nearly a decade of experience working with Fortune 500 companies across automotive, retail, insurance, and travel verticals. He has developed award-winning business intelligence and data visualization tools, which have been featured by Microsoft, the New York Times, and the Society of American Baseball Research (SABR). As founder of, Chris has helped thousands of students learn how to use Excel as a dynamic and powerful analytics tool, and has developed personalized training programs for individuals, private groups, and businesses across the country.
He graduated summa cum laude and received the Charles Bluhdorn Prize in Economics at Tufts University.