Advanced Excel
Online MBA Spring 2024: April 29-May 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.
Class Notes
Open to students admitted to the Special Session Online Masters in Business Administration Degree Program. Registrations are processed through the Professional & Continuing Education Office.
Class Details
Instructor
Instructor Name (static text):
Covington, Bathild J
Location
WWW ONLINE
Class Registration Information
Class #
4773
Course
BSIS 501 -
SECT 501
SECT 501
Units
1.5
Fees
Amount per Unit
- $1,000 / unit
Capacity
13/30
Class Meeting Dates
04/29/2024 - 05/17/2024
Days
TBA
Times
BSIS 501 - SECT 501
Advanced Excel
Class:
4773
Units:
1.5
Fees:
$1,500.00
M-F
04/29/2024 - 05/17/2024
TBA
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.
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