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.

Faculty and course staff

Kavous

Kavous

Roumina

Clinical Associate Professor,

W. P. Carey Information Systems

Arizona State University

Read bio
Joey

Joey

Choi

Online Course Manager,

Learning Enterprise

Arizona State University

Read bio

Why take ASU Universal Learner Courses

  1. Credit you receive is from a regionally accredited university
  2. Your credit is highly transferable
  3. You only pay the $400 course cost if you pass

Related programs

Online BA in Applied Business and Technology Solutions

Online BS in Business Analytics

Mastery Certificate in Applied Business Data Analytics