Excel in Business

CIS 308 - Advanced Excel in Business

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.

Overview

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.

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.

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

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 Roumina

Clinical Associate Professor,

W. P. Carey Information Systems

Arizona State University

Read bio

Matthew Kwan

Online Course Coordinator,

Learning Enterprise

Arizona State University

Read bio

Why take ASU Universal Learner Courses

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