Prometheus Series: Data Analysis with Microsoft Excel

Information Systems

Microsoft Office

ISBN:

978-1-952023-19-4

Prometheus Series: Data Analysis with Microsoft Excel

John Anderson, PhD Nick Ball, PhD Gove Allen, PhD Robert Jackson, PhD

Go beyond basic and intermediate Excel and learn to analyze data like a professional. Students start with advanced functions, PivotTables, and dashboards, then move into optimization, simulation, and statistical and predictive modeling, including A/B testing, regression, classification, clustering, and time series. Students also use Excel for text classification, such as filtering spam. Every assignment is hands-on in the live Microsoft Excel environment and graded automatically with detailed feedback, supported by step-by-step video instruction and practice problems with hints.

Preview a Chapter

Request Access

Free instructor demo access to full resource

Plug-and-play solution for instant adoption

Lifetime access for students

Introduction: Device and Environment Setup Introduction to the Book: Data Analysis with Excel Lesson 1: Conditional Aggregate Functions Lesson 2: Referencing Functions and Date Functions Lesson 3: Conditional Formatting Variations Lesson 4: Multidimensional Analysis Using PivotTables Lesson 5: Advanced Visualization Lesson 6: Building Dashboards in Excel Lesson 7: Power Query and Power Pivot—Microsoft Windows Only Lesson 8: Optimization Using Solver in Excel Lesson 9: Simulation in Excel Lesson 10: Exploratory Data Analysis and Basic Probability Distributions Lesson 11: Inferential Statistics: A/B and A/B/C Tests Lesson 12: Prediction Using Linear and Multiple Regression Lesson 13: Predicting Class Using Logistic Regression Lesson 14: Predicting Class Using the Naïve Bayes Classifier Lesson 15: Grouping Objects Using Cluster Analysis Lesson 16: Forecasting: Time Series Lesson 17: Nonparametric Statistical Tests A1: Appendix

Request Free Access

Interested in using this resource in your course? Request free instructor access. Just tell us who you are and where you teach, and we’ll take care of the rest!

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Made by proffessors, for professors

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.