Spreadsheet software Books

Excel tips to skyrocket white-collar productivity.Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers...

Inspiring Excel tips designed to save 100 hours per year.Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book...

The essential guide for getting started with Power BI.Power BI is an amazing cloud-based business analytics service provided by Microsoft that allows people to transform data into rich, interactive visual reports that presents a 360-degree business view...

Learn favourite techniques from this group of twenty-two Excel MVPs. The Excel MVPs are friends and competitors who each pulled out their favourite tricks to impress you and their fellow MVPs.This book is written by twenty four Excel MVPs: Jon...

A simple walk-through of the common perils and pitfalls of financial modelling, this book examines the most common and necessary Excel functions, emphasizes the importance of a standardized and functional layout, explains accounting concepts simply, and...

Updating the previous edition's tips to include features in Office 365 and Excel 2019, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description,...

Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power...

Data analysis expressions (DAX) is the formula language of Power Pivot. Learning the DAX language is key to empower Excel users so they can take advantage of these new Business Intelligence (BI) capabilities. This volume clearly explains the concepts of...

Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an...