CIS 308 Advanced Excel in Business (ABDA 2)
3 college credits.
This is the second course in the ASU Applied Business Data Analytics Certificate (ABDA).*
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.
*Students who complete the following six courses will receive an additional credential: ASU Certificate in Applied Business Data Analytics.
- CIS105: Computer Applications and Information Technology
- CIS308 Advanced Excel in Business
- CIS309 Business Process Management
- CIS310 Business Data Visualization
- CIS313 Location Analytics in Business
- CIS405 Business Intelligence
Past course syllabus for reference only.
Gold designation: N/A