Advanced Excel
Online MBA Fall 2024: December 2-December 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.
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. Log in daily or as required by faculty.
Class Details
Instructor
Instructor Name (static text):
Covington, Bathild J
Location
WWW ONLINE
Class Registration Information
Class #
5079
Course
BSIS 501 -
SECT 501
SECT 501
Units
1.5
Fees
Amount per Unit
- $1,000 / unit
Capacity
14/30
Class Meeting Dates
12/02/2024 - 12/20/2024
Days
TBA
Times
BSIS 501 - SECT 501
Advanced Excel
Class:
5079
Units:
1.5
Fees:
$1,500.00
M-F
12/02/2024 - 12/20/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