Microsoft Excel Data Analysis and Business Modeling
In today’s data-driven world, every business (big or small) thrives on its ability to transform data into action items. This Excel Business Modeling and Data Analysis course teaches you how to use MS Excel for analyzing data and building financial models that help businesses make informed decisions. Other than learning basic excel formulas, functions, data manipulation and chart creation, you’ll also learn how to use data analysis tools like PivotTables, data tables, scenario analysis (what-if situations), and data consolidation.
Use of analytical techniques for building financial models like budgets and forecasts is also covered in the Excel data analysis training course. To make it a fun learning experience for you, we have also included interactive activities like hand-on labs, flashcards, and quizzes along with the course content.
What You`ll Learn on This Course
-
- Translating Excel basics to relatable analytics
- Using Power Query for cleaning and connecting data
- Create custom functions with LAMBDA (without VBA)
- Utilizing new charts and data types for visualizing data like a pro
- Utilizing data manipulation techniques like advanced XLOOKUP function
- Using 3D Maps for highlighting geographical trends
- Confidently building powerful business data models
This course comes with:
Curriculum
- 2 Sections
- 0 Lessons
- 26 Weeks
Expand all sectionsCollapse all sections
- Lesson Plan
Introduction
- What you should know before reading this course?
- How to use this course?
2 Basic worksheet modeling
- Lesson questions & problems
3 Range names
- Creating named ranges, lesson questions & problems
4 Lookup functions
- Syntax, lesson questions & problems
5–6 INDEX and MATCH functions
- Syntax, lesson questions & problems
7 Text functions and Flash Fill
- Syntax, lesson questions & problems
8–10 Dates, IF functions, Time functions
- Lesson questions & problems
11–14 Financial functions and Circular references
- NPV, IRR, MIRR, Paste Special, lesson questions & problems
15–16 3D formulas, hyperlinks, auditing
- Lesson questions & problems
17–20 Sensitivity analysis, Goal Seek, Scenario Manager
- Lesson questions & problems
21–25 COUNT/SUM/AVERAGE functions & data summarization
- Lesson questions & problems
26–29 Consolidation, subtotals, OFFSET, INDIRECT
- Lesson questions & problems
30–36 Form controls, Conditional formatting, Tables, Charts, Maps, Sparklines
- Lesson questions & problems
37–39 Importing data & Power Query Editor
- Lesson questions & problems
40–44 Sorting, Filtering, Array formulas, Dynamic arrays, Validation
- Lesson questions & problems
45–49 STOCKHISTORY, PivotTables, Data Model, Power Pivot, Analyze Data
- Lesson questions & problems
50–60 Solver and Optimization lessons
- Optimal product mix, workforce scheduling, transportation, capital budgeting, financial planning, sports rating, warehouse location, penalties, traveling salesperson problem
61–66 Regression, Correlations, Nonlinearities
- Lesson questions & problems
67–68 ANOVA lessons
- One-way ANOVA, two-way ANOVA
69–75 Probability and Distributions
- Random variables, binomial, Poisson, normal, lognormal, Weibull, beta
76–80 Time series forecasting
- Moving averages, ratio-to-moving-average, Winters method, special events
81–85 Monte Carlo, simulation, resampling
- Stock prices, asset allocation, gambling, sporting events
86–95 Advanced business applications
- Sensitivity analysis, stock options, customer value, inventory, queuing theory, demand estimation, pricing
96–97 Macros, LET and LAMBDA functions
- Lesson questions & problems
0 - Hands-on LAB Activities
1. Describe Core Azure Services
- Creating a Virtual Machine in Azure
- Creating Azure Container Instances
- Creating a Web App in Azure
- Creating an App Service Plan
- Creating and Configuring VNet Peering
- Creating an Azure Load Balancer
- Creating an Azure ExpressRoute
2. Describe Core Solutions and Management Tools on Azure
- Creating a Function App
- Creating an Azure Internet of Things Central Application
- Creating Internet of Things Hub and Adding a Device
3. Describe General Security and Network Security Features
- Creating an Azure Key Vault
- Creating a Network Security Group and Adding a Rule to It
4. Describe Identity, Governance, Privacy, and Compliance Features
- Creating Azure Databricks
0
