Objective: To learn how to work with filtered data, how to use additionalįormulas, and how to combine data from two different sources.
To download our free business simulation software, please go to our SourceForge page at. To watch this slideshow as a video, please go to our Vimeo page at. This channel has arranged the 36 video lessons into the order in which they are meant to be used with the simulator.
Over six rounds, the user or teams will have to make decisions on capital purchases, financing, production, financing, and human resources for a microbrewery. Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to use Microsoft Excel for data analysis, modeling, and decision making within real-world business scenarios Includes index 1.
Users will have an opportunity to apply the lessons in the Novus Business Simulator. The Novus Business and IT Program contains 36 business and IT training videos, covering basic finance, accounting, marketing, economics, business strategy, Word, Excel, and PowerPoint.
The Novus project is a combination of video tutorials designed to be used in conjunction with a free business simulation software program. The lesson teaches concepts through a combination of image-based slides and video tutorials. The objective of the lesson is for the user to be comfortable with calculating data variance, making informational comments, using advanced filtering techniques, and combining multiple sources of data. The topics covered include using Excel’s powerful formulas to help perform data analysis on both large and small amounts of data. Here we discuss how to create Data Model in Excel along with practical examples and a downloadable excel template. This lesson builds upon the concepts that were learned in the previous Excel lesson. Data Models also makes our analysis much simpler as compared to using a number of complicated formulae all across the workbook. Array Formulas and Functions - 73.Watch this with a 10-15 minute audiotrack at Pricing Products Using Subjectively Determined Demand - 71. Queuing Theory: The Mathematics of Waiting in Line - 68. Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder? - 67. The Economic Order Quantity Inventory Model - 66. Fun and Games: Simulating Gambling and Sporting Event Probabilities - 62. Simulating Stock Prices and Asset Allocation Modeling - 61. Introduction to Monte Carlo Simulation - 59. Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project - 58. The Poisson and Exponential Random Variable - 56. The Binomial and Hypergeometric Random Variables - 55. An Introduction to Random Variables - 54. Forecasting in the Presence of Special Events - 53.
Using Moving Averages to Understand Time Series - 51. Randomized Blocks and Two-Way ANOVA - 50. Analysis of Variance: One-Way ANOVA - 49.
Modeling Nonlinearities and Interactions - 48. : Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th edition : Wayne L. Incorporating Qualitative Factors into Multiple Regression - 47. Introduction to Multiple Regression - 46. Using Correlations to Summarize Relationships - 45. Estimating Straight Line Relationships - 42. Summarizing Data with Database Statistical Functions - 38. Summarizing Data with Descriptive Statistics - 36. Importing Data from the Web into Excel - 33. Importing Text or Microsoft Word Data into Excel - 32. Using Solver for Financial Planning - 30. Using Solver to Schedule Your Workforce - 28. Using Solver to Solve Transportation or Distribution Problems - 27. Using Solver to Determine the Optimal Product Mix - 26. An Introduction to Optimization with the Excel Solver - 25. The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions - 20. Creating and Using Spinners for Sensitivity Analysis - 19. Using the Scenario Manager for Sensitivity Analysis - 18. Sensitivity Analysis with Data Tables - 16. Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions - 11. Evaluating Investments with Net Present Value Criteria - 9. Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to use Microsoft Excel for data analysis, modeling, and decision making within real-world business scenariosġ.