MICROSOFT EXCEL 2019 : DATA ANALYSIS AND BUSINESS MODELING

By:

WINSTON, WYNE L

Material type: Text

TextPublication details: NEW DELHI PHI LEARNING PRIVATE LIMITED 2022Edition: 1STDescription: XXVII+850 P. PaperbackISBN:

978-9389347180

Subject(s):

COMPUTER SCIENCE

DDC classification:

005.54 WIN

Online resources:

Click here to access online

Contents:

Data Analysis Microsoft Excel Business Modeling Microsoft Excel 2019 : Data Analysis and Business Modeling Microsoft Excel 2019

Summary: Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. • Solve real business problems with Excel—and build your competitive advantage • Quickly transition from Excel basics to sophisticated analytics • Use PowerQuery or Get & Transform to connect, combine, and refine data sources • Leverage Office 365's new Geography and Stock data types and six new functions • Illuminate insights from geographic and temporal data with 3D Maps • Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts • Use Excel trend curves, multiple regression, and exponential smoothing • Delve into key financial, statistical, and time functions • Master all of Excel's great charts • Quickly create forecasts from historical time-based data • Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams • Run Monte Carlo simulations on stock prices and bidding models • Learn about basic probability and Bayes' Theorem • Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook • Automate repetitive analytics tasks by using macros www.phindia.com/MicrosoftPressBooks/mspmain Your digital content includes: All the book’s practice and solution files— ready to download at MicrosoftPressStore.com

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Call number	Status	Date due	Barcode
Books	Tolani Maritime Institute	005.54 WIN (Browse shelf(Opens below))	Available		M14526

O:00786 06-DEC-2022 B:2022-23/317 06-DEC-2022

Data Analysis
Microsoft Excel
Business Modeling
Microsoft Excel 2019 : Data Analysis and Business Modeling
Microsoft Excel 2019

Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts.

• Solve real business problems with Excel—and build your competitive advantage

• Quickly transition from Excel basics to sophisticated analytics

• Use PowerQuery or Get & Transform to connect, combine, and refine data sources

• Leverage Office 365's new Geography and Stock data types and six new functions

• Illuminate insights from geographic and temporal data with 3D Maps

• Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts

• Use Excel trend curves, multiple regression, and exponential smoothing

• Delve into key financial, statistical, and time functions

• Master all of Excel's great charts

• Quickly create forecasts from historical time-based data

• Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams

• Run Monte Carlo simulations on stock prices and bidding models

• Learn about basic probability and Bayes' Theorem

• Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook

• Automate repetitive analytics tasks by using macros

www.phindia.com/MicrosoftPressBooks/mspmain

Your digital content includes: All the book’s practice and solution files— ready to download at

MicrosoftPressStore.com

There are no comments on this title.

to post a comment.