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

ebook ∣ Business Skills

By Wayne Winston

cover image of Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)

Sign up to save your library

With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.

   Not today

Format

ebook

ISBN

9780137613663

Series

Business Skills

Author

Wayne Winston

Publisher

Pearson Education

Release

17 December 2021

Share

Subjects

Business Computer Technology Nonfiction

Find this title in Libby, the library reading app by OverDrive.

Download Libby on the App Store Download Libby on Google Play

Search for a digital library with this title

Title found at these libraries:

Loading...

Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's 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 Excel—and 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

    • Format

    ebook

    ISBN

    9780137613663

    Series

    Business Skills

    Author

    Wayne Winston

    Publisher

    Pearson Education

    Release

    17 December 2021

    Share

    Subjects

    Business Computer Technology Nonfiction
    Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)