This is a book about Microsoft 365 Excel, or Excel 365. No other version in history has as much power, as many features or more possibilities than does Excel 365. With a new formula calculations engine and many new built-in functions, creating formula solutions and business models in Excel 365 is dramatically easier than at any time in the history of spreadsheets. In addition, with the new data tools like Power Query, Power Pivot and Power BI, performing data analysis to make data driven decisions can be easily done on data with different structures, with different sources and on small and big data alike. With this exciting new Excel 365 version, we will learn three types for formulas: Worksheet, M Code and DAX, and we will learn three types of Reporting/Dashboarding tools: Standard PivotTables, Data Model PivotTables and Power BI Visualizations. This means that the New Excel 365 is the only app that matters in our age of analytics and data driven decisions.Who is this book/class for? Everyone. The book starts at the beginning and moves you to an advanced level by telling a logical story about how to use Excel to solve calculation-based problems and answer crucial questions.
1137370747
Microsoft 365 Excel: The Only App That Matters: Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight
This is a book about Microsoft 365 Excel, or Excel 365. No other version in history has as much power, as many features or more possibilities than does Excel 365. With a new formula calculations engine and many new built-in functions, creating formula solutions and business models in Excel 365 is dramatically easier than at any time in the history of spreadsheets. In addition, with the new data tools like Power Query, Power Pivot and Power BI, performing data analysis to make data driven decisions can be easily done on data with different structures, with different sources and on small and big data alike. With this exciting new Excel 365 version, we will learn three types for formulas: Worksheet, M Code and DAX, and we will learn three types of Reporting/Dashboarding tools: Standard PivotTables, Data Model PivotTables and Power BI Visualizations. This means that the New Excel 365 is the only app that matters in our age of analytics and data driven decisions.Who is this book/class for? Everyone. The book starts at the beginning and moves you to an advanced level by telling a logical story about how to use Excel to solve calculation-based problems and answer crucial questions.
14.99
In Stock
5
1
Microsoft 365 Excel: The Only App That Matters: Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight
532
Microsoft 365 Excel: The Only App That Matters: Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight
532eBook
$14.99
$19.99
Save 25%
Current price is $14.99, Original price is $19.99. You Save 25%.
Related collections and offers
14.99
In Stock
Product Details
| ISBN-13: | 9781615471560 |
|---|---|
| Publisher: | Holy Macro! Books |
| Publication date: | 04/01/2021 |
| Sold by: | Barnes & Noble |
| Format: | eBook |
| Pages: | 532 |
| Sales rank: | 315,609 |
| File size: | 136 MB |
| Note: | This product may take a few minutes to download. |
About the Author
From the B&N Reads Blog