Microsoft Excel 2013 Data Analysis and Business Modeling 1st Edition by Wayne Winston ISBN B00JDMPO7U 9780735669130

Microsoft Excel 2013 Data Analysis and Business Modeling 1st Edition by Wayne Winston – Ebook PDF Instant Download/Delivery. B00JDMPO7U ,9780735669130
Full download Microsoft Excel 2013 Data Analysis and Business Modeling 1st EditionN after payment

Product details:
ISBN 10: B00JDMPO7U
ISBN 13: 9780735669130
Author: Wayne Winston

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook.

Solve real business problems with Excel—and sharpen your edge

• Summarize data with PivotTables and Descriptive Statistics
• Explore new trends in predictive and prescriptive analytics
• Use Excel Trend Curves, multiple regression, and exponential smoothing
• Master advanced Excel functions such as OFFSET and INDIRECT
• Delve into key financial, statistical, and time functions
• Make your charts more effective with the Power View tool
• Tame complex optimization problems with Excel Solver
• Run Monte Carlo simulations on stock prices and bidding models
• Apply important modeling tools such as the Inquire add-in

Microsoft Excel 2013 Data Analysis and Business Modeling 1st Edition Table of contents:

1. Introduction to Business Modeling and Data Analysis with Excel

• Overview of Excel as a Tool for Data Analysis and Business Modeling
• Key Features of Excel 2013 for Business and Data Analysis
• Basics of Excel Functions and Formulas for Business Applications
• An Introduction to Data Types and Organizing Data in Excel

2. Descriptive Statistics in Excel

• Introduction to Descriptive Statistics
• Using Excel to Calculate Means, Medians, and Modes
• Measures of Dispersion: Range, Variance, and Standard Deviation
• Data Visualization with Charts and Graphs
• Using PivotTables for Summarizing and Analyzing Data

3. Data Analysis and Trend Analysis

• Working with Large Datasets in Excel
• Sorting, Filtering, and Grouping Data
• Analyzing Data Trends and Identifying Patterns
• Using Excel’s Trendline Functionality and Forecasting Tools
• Regression Analysis in Excel

4. Simulation Modeling with Excel

• Introduction to Simulation Models
• Using Excel for Monte Carlo Simulation
• Simulating Business Processes and Decision-Making Scenarios
• Using the Data Table and Scenario Manager for Sensitivity Analysis
• Excel Add-Ins for Advanced Simulation Techniques

5. Optimization and Linear Programming

• Understanding Optimization and Its Role in Business Decision Making
• Linear Programming and the Solver Add-In
• Solving Optimization Problems with Excel’s Solver Tool
• Sensitivity Analysis in Linear Programming Models
• Using Excel for Network Flow and Transportation Problems

6. Financial Modeling with Excel

• Building Basic Financial Models in Excel
• Time Value of Money (TVM) Calculations: Present and Future Values
• Loan Amortization and Debt Schedules
• Building Forecasting Models for Financial Statements
• Risk Analysis in Financial Modeling

7. Time Series Forecasting and Analysis

• Understanding Time Series Data and Trends
• Using Excel for Moving Averages and Exponential Smoothing
• Regression Models for Time Series Forecasting
• Forecasting Techniques for Sales and Demand Planning
• Analyzing Seasonality and Cyclical Patterns in Time Series Data

8. Data Visualization and Reporting

• Creating Dynamic Charts and Graphs in Excel
• Advanced Charting Techniques: Sparklines, Heat Maps, and Combo Charts
• Using Excel’s Power View and Power Map for Enhanced Data Visualization
• Creating Dashboards for Business Reporting
• Using Conditional Formatting for Visual Analysis

9. Decision Analysis and Sensitivity Analysis

• Introduction to Decision Analysis Methods
• Decision Trees and Decision Matrix in Excel
• Sensitivity Analysis with Excel’s Data Tables and Scenario Manager
• Monte Carlo Simulation for Decision Making
• Using the Risk Management Add-In for Uncertainty Analysis

10. Advanced Business Modeling Techniques

• Using Excel for Nonlinear Programming and Optimization Problems
• Financial and Economic Forecasting Models
• Inventory and Supply Chain Modeling with Excel
• Markov Chains and Queuing Models in Excel
• Building Stochastic Models in Excel

11. Macros and VBA for Automating Business Models

• Introduction to Macros and VBA (Visual Basic for Applications)
• Writing Simple VBA Code to Automate Repetitive Tasks
• Creating Custom Functions and Automating Data Analysis
• Developing Complex Models and Reporting Tools Using VBA
• Debugging and Troubleshooting VBA Code

12. Case Studies in Business Modeling and Data Analysis

• Case Study 1: Forecasting Sales Using Time Series Data
• Case Study 2: Financial Modeling for Investment Decision Making
• Case Study 3: Optimization of Supply Chain Operations
• Case Study 4: Risk Analysis in Business Scenarios
• Case Study 5: Decision-Making Model for Capital Budgeting

13. Conclusion and Next Steps

• Key Takeaways for Using Excel for Business and Data Modeling
• Resources for Further Learning and Exploration of Excel’s Advanced Features
• Final Thoughts on Mastering Excel for Business Decision Making

People also search for Microsoft Excel 2013 Data Analysis and Business Modeling 1st Edition:

microsoft excel data analysis and business modeling

microsoft excel 2019 data analysis and business modeling

microsoft excel 2013 data analysis and business modeling

microsoft excel data analysis and business modeling by wayne winston