Advanced Excel

Issued by Rice University - School of Continuing Studies

Students will learn the power of Microsoft Excel. Students will learn how to implement statistical modeling, forecasting and prediction, pivot tables, and VBA scripting inside Excel!

Skills

Apply Statistical Models
Excel VBA

Earning Criteria

Analyze a dataset using Microsoft Excel and use formulas, pivot tables, stacked column pivot charts, and pivot chart line graphs to view trends within the data. Utilizing of conditional formatting to detect anomalous data or trends.
Analyze real-world data using VBA scripting that work on multiple sheets of data in Microsoft Excel.
Demonstrate appropriate tool selection when using Excel over other tools in course