Böcker av Mike Girvin

This book is about Power Query and M Code. Power Query and the functional language M Code (M) are the heart and soul of Microsoft's power data analysis tools: Excel, Power BI Desktop and Dataflows. The beautiful data driven and insightful PivotTables, Power BI solutions and Dashboards that you create usually require that you use Power Query and M Code to get, transform and load the data before you create the final reports and visuals. For many data analysis jobs, using the SQL language to perform ETL (extract, transform and load) is the preferred tool. Maybe even R or Python. But if you use Power BI or Excel, you better also be masterful with M Code and Power Query. Together, they give you the power to connect to multiple data sources, structuring your data with ease, and load to the worksheet, the data model in Excel or Power BI or Dataflow's Data Hub. As an accountant, professor, data analyst, author, Excel MVP and YouTuber for about 20 years, my specialty is in telling stories with videos and books to make complicated things less complicated and to inspire you to have fun with the power you can gain over data.

Array Formulas have been around since the beginning of Excel. The author wrote a whole book about them back in 2012. Array Formulas were powerful, but complicated. Then Microsoft invented the new Worksheet Calculation Engine in Microsoft 365 Excel and just like that, 40 years of Excel worksheet formula methods changed overnight. Dynamic Spilled Array Formulas, born inside this new calc engine, can now spill results from a single cell and dynamically update when new source data changes. Now we don't have to lock most cell references; no need to manually copy most formulas, editing formulas is now a simple task, and insane old school filtering, sorting and unique list formulas are a thing of the past with new Array Functions like FILTER, SORT and UNIQUE. Microsoft also gave us the LET function which eliminates duplicate formula elements by allowing us to define variables within the formula itself. In addition, Microsoft gave us the LAMBDA function which allows us to define re-usable functions without using VBA code. There are also LAMBDA Helper Functions like BYROW which solves the problem of " how do I spill an aggregate total?" Does all this sound too good to be TRUE? Too good is no

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.