Advanced Excel
Online MBA Spring 2025: April 28-May 16
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
WWW ONLINE
Class Registration Information
SECT 501
- $1,000 / unit
04/28/2025 - 05/16/2025
TBA
Advanced Excel
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.