Advanced Excel

Online MBA Spring 2022: May 2-May 20

Description

The purpose of this course is for students to develop and apply advanced Excel skills. The primary learning outcome is that students will gain advanced skills to use Excel productively. The course delivery is online including short lectures, activities, assessments, and scheduled virtual office hours. Functions explored include VLOOKUP and XLOOKUP functions; IF, and Nested IF Statements with OR/AND conditions; Use of the Data Tab (e.g., What-If analysis, and Forecasting Sheet); Simulations and Solvers. High-level overview includes: Analyzing Data with Pivot Tables; Exchanging Data with Other Programs; Sharing Excel Files and Incorporating Web Information; Customizing Excel and Advanced Worksheet Management; Programming with Excel.

Prerequisite: Open to declared Online MBA students only.

Class Notes

Open to students admitted to the Online MBA Special Session Degree Program. Registration through Regional & Continuing Education rce.csuchico.edu/online-mba

Class Details

Instructor
Instructor Name (static text): 
Covington, Bathild J
Location

WWW ONLINE

Class Registration Information

Class #
5093
Course
BSIS 501 -
SECT 501
Units
1.5
Fees
Amount per Unit
  • $1,000 / unit
Class Meeting Dates

05/02/2022 - 05/20/2022

Days

Times
BSIS 501 - SECT 501

Advanced Excel

Class: 5093 Units: 1.5 Fees: $1,500.00

M-F 05/02/2022 - 05/20/2022

The purpose of this course is for students to develop and apply advanced Excel skills. The primary learning outcome is that students will gain advanced skills to use Excel productively. The course delivery is online including short lectures, activities, assessments, and scheduled virtual office hours. Functions explored include VLOOKUP and XLOOKUP functions; IF, and Nested IF Statements with OR/AND conditions; Use of the Data Tab (e.g., What-If analysis, and Forecasting Sheet); Simulations and Solvers. High-level overview includes: Analyzing Data with Pivot Tables; Exchanging Data with Other Programs; Sharing Excel Files and Incorporating Web Information; Customizing Excel and Advanced Worksheet Management; Programming with Excel.

Prerequisite: Open to declared Online MBA students only.

Class Notes

The purpose of this course is for students to develop and apply advanced Excel skills. The primary learning outcome is that students will gain advanced skills to use Excel productively. The course delivery is online including short lectures, activities, assessments, and scheduled virtual office hours. Functions explored include VLOOKUP and XLOOKUP functions; IF, and Nested IF Statements with OR/AND conditions; Use of the Data Tab (e.g., What-If analysis, and Forecasting Sheet); Simulations and Solvers. High-level overview includes: Analyzing Data with Pivot Tables; Exchanging Data with Other Programs; Sharing Excel Files and Incorporating Web Information; Customizing Excel and Advanced Worksheet Management; Programming with Excel.

Instructor
Instructor Name (static text): 
Covington, Bathild J
Location
WWW ONLINE