MGMT X 430.716 - Data Analysis and Business Modeling with Microsoft® Excel®
22366988
Delivery Options
Online
Loading...
Course Description
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 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 database 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.)Course Outline
This course provides a thorough working knowledge of business modeling and analysis techniques with Microsoft Excel, with the ultimate objective of transforming data and modeling assumptions into actionable key metrics.Notes
Contact:
Lina Ogolla
310.206.1579
logolla@uclaextension.edu
Applies Towards the Following Certificates
- Business Analysis : Electives
- General Business Studies : Electives - Business Management
- General Business Studies with Concentration in Accounting : Electives - Business Management
- General Business Studies with Concentration in Entrepreneurship : Electives - Business Management
- General Business Studies with Concentration in Finance : Electives - Business Management
- General Business Studies with Concentration in International Trade and Commerce : Electives - Business Management
- General Business Studies with Concentration in Leadership : Electives - Business Management
- General Business Studies with Concentration in Marketing : Electives - Business Management
- General Business Studies with Concentration in Real Estate : Electives - Business Management
- Quantitative Financial Analytics : Required Courses
- Study Abroad at UCLA Program : Required
Loading...
Application
Name
Certificate in Business Analysis
Review Sections
Required fields are indicated by .