Companies Home Search Profile

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)

Download pdf

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)

Category

Data Analysis

Excel

Excel Analytics

Microsoft Office 365

Author

Wayne Winston

Publication

Microsoft Press

0 View

Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winstons hands-on, scenario-focused guide helps you use todays Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts.

Solve real problems with Microsoft Exceland build your competitive advantage

Quickly transition from Excel basics to sophisticated analytics
Use recent Power Query enhancements to connect, combine, and transform data sources more effectively
Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA
Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music
Build more sophisticated and compelling charts
Use the new XLOOKUP function to revolutionize your lookup formulas
Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries
Illuminate insights from geographic and temporal data with 3D Maps
Improve decision-making with probability, Bayes theorem, and Monte Carlo simulation and scenarios
Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics
Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook

'

Download pdf

ISBN-10

0137613660

ISBN-13

978-0137613663

Publisher

Microsoft Press

Price

0

File Type

PDF

Page No.

1168

Wayne Winston

Discover more of the author’s books, see similar authors, read author blogs and more ...

About the Author

Wayne L. Winston is Professor Emeritus of Decision Sciences at the Indiana University School of Business. He has also taught at the University of Houston and Wake Forest. He has won more than 40 teaching awards and taught Excel modeling and analytics at many Fortune 500 companies, accounting firms, the U.S. Army, and the U.S. Navy. He is a two-time Jeopardy! champion, and also is a co-developer of a player tracking system utilized by Mark Cuban and the Dallas Mavericks.

Similar Books

Essential Office 365 Second Edition: The Illustrated Guide to using Microsoft Office

Essential Office 365 Second Edition: The Illustrated Guide to using Microsoft Office

Kevin Wilson

Microsoft Office 365

Microsoft Office 365 and SharePoint Online Cookbook: An all-in-one guide to Microsoft 365 workloads, including SharePoint, Microsoft Teams, Power Platform, and more, 2nd Edition

Microsoft Office 365 and SharePoint Online Cookbook: An all-in-one guide to Microsoft 365 workloads, including SharePoint, Microsoft Teams, Power Platform, and more, 2nd Edition

Nate Chamberlain

Microsoft Office 365

Microsoft Security, Compliance, and Identity Fundamentals Exam Ref SC-900: Familiarize yourself with security, identity, and compliance in Microsoft 365 and Azure

Microsoft Security, Compliance, and Identity Fundamentals Exam Ref SC-900: Familiarize yourself with security, identity, and compliance in Microsoft 365 and Azure

Dwayne Natwick

Microsoft Azure

Microsoft 365 Fundamentals Guide: Over 100 tips and tricks to help you get up and running with M365 quickly

Microsoft 365 Fundamentals Guide: Over 100 tips and tricks to help you get up and running with M365 quickly

Gustavo Moraes

Microsoft Office 365

ISE Microsoft Office 365: In Practice, 2021 Edition

ISE Microsoft Office 365: In Practice, 2021 Edition

Randy Nordell

Microsoft Office 365

Teach Yourself VISUALLY Microsoft 365 (Teach Yourself VISUALLY (Tech))

Teach Yourself VISUALLY Microsoft 365 (Teach Yourself VISUALLY (Tech))

Paul McFedries

Microsoft Office 365

Windows 365 For Dummies (For Dummies (Computer/Tech))

Windows 365 For Dummies (For Dummies (Computer/Tech))

Rosemarie Withee

Office For Seniors For Dummies

Office For Seniors For Dummies

Faithe Wempen

Microsoft Office

Microsoft 365 For Dummies (For Dummies (Computer/Tech))

Microsoft 365 For Dummies (For Dummies (Computer/Tech))

Jennifer Reed

Microsoft Office 365

Office 365 All-in-One For Dummies (For Dummies (Computer/Tech))

Office 365 All-in-One For Dummies (For Dummies (Computer/Tech))

Matt Wade

Microsoft Office 365

Microsoft 365 Portable Genius

Microsoft 365 Portable Genius

Lisa A. Bucki

Microsoft Office 365

Mastering Microsoft Teams: Creating a Hub for Successful Teamwork in Office 365

Mastering Microsoft Teams: Creating a Hub for Successful Teamwork in Office 365

Christina Wheeler

Microsoft Office 365

Advances in Intelligent Data Analysis XX: 20th International Symposium on Intelligent Data Analysis, IDA 2022, Rennes, France, April 20–22, 2022, Proceedings (Lecture Notes in Computer Science, 13205)

Advances in Intelligent Data Analysis XX: 20th International Symposium on Intelligent Data Analysis, IDA 2022, Rennes, France, April 20–22, 2022, Proceedings (Lecture Notes in Computer Science, 13205)

Tassadit Bouadi

Artificial Intelligence

Cohesive Subgraph Search Over Large Heterogeneous Information Networks (SpringerBriefs in Computer Science)

Cohesive Subgraph Search Over Large Heterogeneous Information Networks (SpringerBriefs in Computer Science)

Yixiang Fang

Large-Scale Scientific Computing: 13th International Conference, LSSC 2021, Sozopol, Bulgaria, June 7–11, 2021, Revised Selected Papers (Lecture Notes in Computer Science)

Large-Scale Scientific Computing: 13th International Conference, LSSC 2021, Sozopol, Bulgaria, June 7–11, 2021, Revised Selected Papers (Lecture Notes in Computer Science)

Ivan Lirkov

Data Architecture

Biomedical Image Registration, Domain Generalisation and Out-of-Distribution Analysis: MICCAI 2021 Challenges: MIDOG 2021, MOOD 2021, and Learn2Reg 2021, ... Notes in Computer Science Book 13166)

Biomedical Image Registration, Domain Generalisation and Out-of-Distribution Analysis: MICCAI 2021 Challenges: MIDOG 2021, MOOD 2021, and Learn2Reg 2021, ... Notes in Computer Science Book 13166)

Marc Aubreville

Designing Data Spaces: The Ecosystem Approach to Competitive Advantage

Designing Data Spaces: The Ecosystem Approach to Competitive Advantage

Boris Otto

Data Architecture

Complex Data Analytics with Formal Concept Analysis

Complex Data Analytics with Formal Concept Analysis

Rokia Missaoui

Multilayer Networks: Analysis and Visualization: Introduction to muxViz with R

Multilayer Networks: Analysis and Visualization: Introduction to muxViz with R

Manlio De Domenico

Statistics for Data Scientists: An Introduction to Probability, Statistics, and Data Analysis (Undergraduate Topics in Computer Science)

Statistics for Data Scientists: An Introduction to Probability, Statistics, and Data Analysis (Undergraduate Topics in Computer Science)

Maurits Kaptein

Software Testing

Healthcare Monitoring and Data Analysis using IoT: Technologies and applications (Healthcare Technologies)

Healthcare Monitoring and Data Analysis using IoT: Technologies and applications (Healthcare Technologies)

Jyotir Moy Chatterjee

Internet Of Things

Handbook of Big Data Analytics: Methodologies (Computing and Networks)

Handbook of Big Data Analytics: Methodologies (Computing and Networks)

Vadlamani Ravi

Python Natural Language Processing Cookbook: Over 50 recipes to understand, analyze, and generate text for implementing language processing tasks

Python Natural Language Processing Cookbook: Over 50 recipes to understand, analyze, and generate text for implementing language processing tasks

Zhenya Antic

Natural Language Processing

Hands-On Big Data Analytics with PySpark: Analyze large datasets and discover techniques for testing, immunizing, and parallelizing Spark jobs

Hands-On Big Data Analytics with PySpark: Analyze large datasets and discover techniques for testing, immunizing, and parallelizing Spark jobs

Rudy Lai

Excel-VBA: From Solving Mathematical Puzzles to Analysing Complex Engineering Problems

Excel-VBA: From Solving Mathematical Puzzles to Analysing Complex Engineering Problems

Tariq Muneer

Using Excel 2019: The Step-by-step Guide to Using Microsoft Excel 2019 (2) (Using Microsoft Office)

Using Excel 2019: The Step-by-step Guide to Using Microsoft Excel 2019 (2) (Using Microsoft Office)

Kevin Wilson

Hands-On Financial Modeling with Excel for Microsoft 365: Build your own practical financial models for effective forecasting, valuation, trading, and growth analysis, 2nd Edition

Hands-On Financial Modeling with Excel for Microsoft 365: Build your own practical financial models for effective forecasting, valuation, trading, and growth analysis, 2nd Edition

Shmuel Oluwa

Financial Modeling

Excel in Complex Variables with the Complex Variable Boundary Element Method

Excel in Complex Variables with the Complex Variable Boundary Element Method

Bryce Willkins (editor)

Microsoft Excel Functions and Formulas: With Excel 2021 / Microsoft 365

Microsoft Excel Functions and Formulas: With Excel 2021 / Microsoft 365

Brian Moriarty

Excel Formulas and Functions

Guerrilla Data Analysis Using Microsoft Excel: Overcoming Crap Data and Excel Skirmishes

Guerrilla Data Analysis Using Microsoft Excel: Overcoming Crap Data and Excel Skirmishes

Oz du Soleil

Straightforward Statistics with Excel

Straightforward Statistics with Excel

Chieh-Chen Bowen

Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis

Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis

Hong Zhou

Excel Formulas and Functions

Essential Excel 2019: A Step-By-Step Guide

Essential Excel 2019: A Step-By-Step Guide

David Slager

Excel All-in-One For Dummies (For Dummies (Computer/Tech))

Excel All-in-One For Dummies (For Dummies (Computer/Tech))

Greg Harvey

Financial Modeling in Excel For Dummies

Financial Modeling in Excel For Dummies

Danielle Stein Fairhurst

Financial Modeling

Excel Macros For Dummies (For Dummies (Computer/Tech))

Excel Macros For Dummies (For Dummies (Computer/Tech))

Dick Kusleika

Bayesian Analysis with Excel and R (Addison-Wesley Data & Analytics Series)

Bayesian Analysis with Excel and R (Addison-Wesley Data & Analytics Series)

Conrad Carlberg

Other Authors' Books

Other Publishing Books

Microsoft Teams Step by Step

Microsoft Teams Step by Step

Joan Lambert

Microsoft Teams

Microsoft Defender for Cloud (IT Best Practices - Microsoft Press)

Microsoft Defender for Cloud (IT Best Practices - Microsoft Press)

Yuri Diogenes

Cloud Computing

Microsoft Azure Sentinel: Planning and implementing Microsoft's cloud-native SIEM solution (IT Best Practices - Microsoft Press)

Microsoft Azure Sentinel: Planning and implementing Microsoft's cloud-native SIEM solution (IT Best Practices - Microsoft Press)

Yuri Diogenes

Microsoft Azure

Code: The Hidden Language of Computer Hardware and Software

Code: The Hidden Language of Computer Hardware and Software

Charles Petzold

Computer Skills

Exam Ref AZ-900 Microsoft Azure Fundamentals

Exam Ref AZ-900 Microsoft Azure Fundamentals

Jim Cheshire

Microsoft Azure

Begin to Code with JavaScript

Begin to Code with JavaScript

Rob S. Miles

Begin to Code with C#

Begin to Code with C#

Rob S. Miles

Windows Internals, Part 2 (Developer Reference)

Windows Internals, Part 2 (Developer Reference)

Mark E. Russinovich

Developing Microservices Architecture on Microsoft Azure with Open Source Technologies (IT Best Practices - Microsoft Press)

Developing Microservices Architecture on Microsoft Azure with Open Source Technologies (IT Best Practices - Microsoft Press)

Arvind Chandaka

Microsoft Azure

Programming ML.NET (Developer Reference)

Programming ML.NET (Developer Reference)

Dino Esposito

Software Development

Exam Ref MS-100 Microsoft 365 Identity and Services

Exam Ref MS-100 Microsoft 365 Identity and Services

Orin Thomas

Microsoft Office 365

Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)

Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)

Tracy Syrstad

Microsoft Office 365

User Reviews

Log in first to post a comment

Rating

0

0

0

0

0

average 0

Total votes0