Advanced Excel

Online MBA Fall 2021: November 29-December 17

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. Log on daily or as required by the faculty.

Class Details

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

WWW ONLINE

Class Registration Information

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

11/29/2021 - 12/17/2021

Days

Times
BSIS 501 - SECT 501

Advanced Excel

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

M-F 11/29/2021 - 12/17/2021

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