Microsoft Excel Data Analysis and Business Modeling

Parents

05 Reporting
Microsoft Excel Data Analysis and Business Modeling

Children

01 Basic Worksheet Modeling
02 Range Names
03 lookup Functions
04 INDEX Function
05 MATCH Function
06 TExt Functions and Flash Fill
07 Dates and date function
08 Net Present Value Functions: NPV and XNPV
09 Internal Rate of Return: IRR, XIRR, and MIRR Functions
10 More Excel Financial Functions
11 Circular References
12 OIF, IFERROR, IFS, CHOOSE, SWITCH, and the IS Functions
13 Time and Time Functions
14 Paste Special Command
15 Three-Dimensional formulas and hyperlinks
16 Auditing Tool and the Inquire add-in
17 Sensitivity Analysis with Data Tables
18 Goal Seek Command
19 Using the Scenario Manager for sensitivity analysis
20 COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNT BLANK Functions
21 SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIIFS Functions
22 OFFSET Function
23 INDIRECT Function
24 Conditional Formatting
25 Excel tables and table slicers
26 Spin Buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes
27 Importing data from a text file or document
28 Power Query Editor
29 Excel's new data types
30 Summarizing data with histograms and Pareto charts
31 Summarizing Data with descriptive statistics
32 Sorting in Excel
33 Filtering Data and Removing Duplicates
34 Summarizing Data with database statistical functions
35 Array formulas and functions
36 Excel's new dynamic array functions
37 Validating Data
38 Using PivotTables and slicers to describe data
39 The Data Model
40 Power Pivot
41 Consolidating Data
42 Creating Subtotals
43 Basic Charting
44 Advanced Charting
45 Filled and 3D Maps
46 Sparklines
47 Estimating Straight-line relationships
48 Modeling Exponential Growth
49 The Power Curve
50 Using correlations to summarize relationships
51 Introduction to multiple regression
52 Incorporating qualitative factors into multiple regression
53 Modeling nonlinearities and interactions
54 Analysis of variance: One-way ANOVA
55 Randomized Blocks and two-way ANOVA
56 Using Moving Averages to understand time series
57 Ratio-to-moving-average forecast method
58 An introduction to probability
59 An Introduction to Random Variables
60 The binomial, hyper geometric, and negative binomial random variables
61 The Poisson and exponential random variable
62 The normal random variable and Z-scores
63 Making probability statements from forecasts
64 Using the lognormal random variable to model stock prices
65 Importing past stock prices, exchange rates, and cryptocurrency prices with the STOCKHISTORY function
66 An Introduction to optimization with Excel Solver
67 Using Solver to determine the optimal product mix
68 Using Solver to schedule your workforce
69 Using Solver to solve transportation or distribution problems
70 Using Solver for Capital budgeting
71 Using Solver for Financial planning
72 Using Solver to rate sports team
73 The Winters method and the Forecast Sheet Tool
74 Forecasting in the presence of special events
75 Warehouse location and the GRG Multistart and Evolutionary Solver Engines
76 Penalties and the Evolutionary Solver
77 The Traveling salesperson problem
78 Weibull and beta distributions: Modeling machine life and duration of a project
79 Introduction to Monte Carlo simulation
80 Calculating an optimal bid
81 Simulating stock prioces and asset-allocation modeling
82 Fun and Games: Simulating gambling and sporting-event probabilities
83 Using resampling to analyse data
84 Pricing stock options
85 Determining customer value
86 The economic order quantity inventory model
87 Inventory modeling with uncertain demand
88 Queuing Theory: the mathematics of waiting in line
89 Estimating a Demand Curve
90 Pricing products by using tie-ins
91 Pricing products by using subjectively determined demand
92 Nonlinear pricing
93 Use Analyze Data to find patterns in your data
94 Recording macros
95 The LET and LAMBDA functions and the LAMDA helper functions
96 Advanced Sensitivity analysis

Made with TheBrain