This course covers advanced Excel skills using an applied focus on different types of decisions one may analyze using spreadsheet capabilities; graphs and charts to communicate complex analytics; pivot tables to slice and dice data for reporting; what-if analysis for forecasting and predictive analysis. Students will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work. They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets and leverage Excel’s advanced functionalities.
To be successful in this course, we recommend English language fluency and computer literacy. Knowledge of basic mathematical & problem-solving skills is recommended. We encourage you to make sure your laptop or desktop computer meets the technical requirements.This course uses the Windows Excel application which may not work on tablets, Chromebooks, or two-in-one devices. A Mac or Windows computer is highly suggested.
CIS 105 Computer Applications and Information Technology is strongly suggested as a prerequisite for success in this course.
Microsoft Excel is required for this course and not provided by ASU.