Excel Data Analysis
EN
Action & Adventure 5 years ago 1446
Description
Master business modeling and analysis techniques with Microsoft Excel
2016, and transform data into bottom-line results. Written by
award-winning educator Wayne Winston, this hands on, scenario-focused
guide helps you use Excel’s newest tools to ask the right questions and
get accurate, actionable answers. This edition adds 150+ new problems
with solutions, plus a chapter of basic spreadsheet models to make sure
you’re fully up to speed.
Solve real business problems with Excel—and build your competitive advantage
- Quickly transition from Excel basics to sophisticated analytics
- Summarize data by using PivotTables and Descriptive Statistics
- Use Excel trend curves, multiple regression, and exponential smoothing
- Master advanced functions such as OFFSET and INDIRECT
- Delve into key financial, statistical, and time functions
- Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts)
- Make charts more effective by using Power View
- Tame complex optimizations by using Excel Solver
- Run Monte Carlo simulations on stock prices and bidding models
- Work with the AGGREGATE function and table slicers
- Create PivotTables from data in different worksheets or workbooks
- Learn about basic probability and Bayes’ Theorem
- Automate repetitive tasks by using macros
Open the next page to download PDF.
Note : This digital document is brought to you by Find Popular Books. It is intended for strictly personal use and cannot be sold under any circumstances.
Similar Free eBooks
Ask for books
It's 100% Free, just send us the name of book and we get it for you.
Copyrights
If FindPopularBooks® has shared your copyrighted book or your personal information.Contact us to let us know. You will receive an answer within 3 working days.
A big thank you for your understanding!
ADVERTISMENT