Data Analysis and Business Modeling with Microsoft® Excel®

MGMT X 430.716

This course provides a thorough working knowledge of business modeling and analysis techniques with Microsoft Excel 2013, with the ultimate objective of transforming data and modeling assumptions into actionable key metrics.

READ MORE ABOUT THIS COURSE
Fall
Spring
Online
Starting at $765.00
As few as 11 weeks
4.0

What you can learn.

  • Explore forecasting, evaluation, and analysis modeling techniques to create bottom-line results of forecasts, simulations, and sensitivity analyses
  • Understand relational database construction and integration including use of Pivot Tables and Descriptive Statistics
  • Understand and utilize trend analyses (i.e., multiple regression, exponential smoothing, etc.) as well as advanced Excel functions

About this course:

Market researchers, project managers, business analysts, economists, financial professionals, budgeters, venture capitalists, investment bankers, corporate treasurers, and operations heads are just a few examples of positions requiring a working knowledge of forecasting, evaluation, and analysis modeling. This course provides a thorough working knowledge of a “best practice” platform meeting many organizational and project analytical needs. Students learn business modeling and analysis techniques with Microsoft Excel 2013 with the ultimate objective of transforming data and modeling assumptions into key metrics as well as bottom-line results of forecasts, simulations, and sensitivity analyses. This course is hands-on, scenario-based, and involves relational data base construction and integration including use of Pivot Tables and Descriptive Statistics. Key tools included are trend analyses (i.e. multiple regression, exponential smoothing, etc.) as well as advanced Excel functions (i.e. OFFSET, INDIRECT, Power View, Solver, etc.) 

Fall 2021 Schedule

Date & Time
Details
Format
 
-
This section has no set meeting times.
Available
See Details
382403
Fee:
$765.00
Onlineformat icon
ENROLL BY: Sep 20, 2021
See Details
Notes

Enrollment limited; early enrollment advised. Visitors not permitted. Internet access required.

Refund Deadline
No refunds after September 24, 2021
Course Requirements
Internet access required.
Course syllabus not yet available.

Contact Us

Speak to a program representative. Hours: Mon-Fri, 8am-5pm.
Keep up to date on the latest news and offerings in Leadership & Management

vector icon of building

Corporate Education

Learn how we can help your organization meet its professional development goals and corporate training needs.

Learn More

vector icon of building

Donate to UCLA Extension

Support our many efforts to reach communities in need.

Innovation Programs

Student Scholarships

Coding Boot Camp

Lifelong Learning