There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.
This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.
With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.
Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.
This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.
Excel Custom Functions can be used like any other native functions or user defined functions in Excel. This book shows the process of creating Excel Custom Functions.
Learn Power BI Dashboarding Techniques by Watching A Pro!
This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.
A book for people who use Excel 40+ hours per week. Illustrated in full color.