Online Excel in Business
CIS 308 - Advanced Excel in Business
Overview
This course is part of the Applied Business Analytics Certificate. Learn more about the certificate here.
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.
Course prerequisites and requirements
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.
Quick facts
- Credits: 3
- Length: On-demand or 8 weeks
- Cost: $25 + $400
What you’ll learn
- Calculate with advanced functions and formulas
- Organize worksheet, workbook and table data using a variety of techniques
- Create and modify charts and graphs
- Customize and enhance workbooks using graphic objects and data tools
- Understand how businesses can utilize advanced spreadsheet analytical techniques using pivot tables, v-lookups, amortization and graphical data to better understand their business and customers
- Manipulate and analyze data to make appropriate recommendations for managerial decision making
- Deploy advanced techniques to increase productivity and improve efficiency by streamlining workflow
What to expect in class
Lecture walkthroughs that help you create files to complete assignments, videos, quizzes, and exams
Exams and grading
58%
Interactive Assignments
13%
Quizzes
29%
Exams
Transcript
This course appears on your transcript identically to how it appears on the transcript of an enrolled ASU student who has taken the course on one of ASU’s campuses. Course attendance dates will be listed on your transcript. An on-demand course will appear on your transcript in the session you complete the course.
This course satisfies 3 credit hours at Arizona State University. It is strongly encouraged that you consult with your institution of choice to determine how these credits will be applied to their degree requirements prior to transferring your credit.