Best Spreadsheet Books
When we talk about learning Excel, we almost always think of videos and written tutorials. While these are great ways to learn Excel, you can also consider using Excel books to level up your Excel learning.
1. Excel 2019 All-in-One For Dummies
Author: by Greg Harvey
Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functionsincluding formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions.
The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources.
2. Excel Formulas & Functions For Dummies (For Dummies (Computers))
Author: by Ken Bluttman
Put the power of Excel functions to work in your formulas There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas?
Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions. With this book, you’ll learn to apply the power of Excel functions and formulas to make your work and other tasks easier.Compare 15-year vs.
30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel.
Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel. Step-by-step instruction on Excel’s 150 most useful functions Each function is illustrated by helpful, real-world examples 85 specialized functions are described in abbreviated form Includes Excel’s must-know functions This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel’s powerful built-in functions.
3. Excel Formulas (Quick Study Computer)
Author: by Inc. BarCharts
Guide to developing and using functions and formulas in Excel. This clear and concise coverage of the ins and outs of formula creation and use touches on many forms of math from statistics & trig to financial math. The sheer volume and wealth of information in these 6 pages is equal to 30 pages or more from your average book on the same subject.
Includes screen shots.
4. Excel Tips & Tricks (Quick Study Computer)
Author: by Inc. BarCharts
Excel Tips & Tricks A handy resource for beginning, intermediate or advanced Excel users, this 3-panel (6-page) guide is jam-packed with information and helpful, time-saving hints on Microsoft’s award-winning spreadsheet software. Featuring easy-to-see screen captures and icons, this guide is an ideal next-to-the-monitor reference.
5. Excel 2019 Bible
Author: by Michael Alexander
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers.
Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019’s new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.
6. 101 Most Popular Excel Formulas (101 Excel Series)
Author: by John Michaloudis
Learn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus Many More! With this book, you’ll learn to apply the must know Excel Formulas & Functions to make your data analysis & reporting easier and will save time in the process.
With this book you get the following: 101 Ready Made Formulas Covering: LOOKUP, LOGICAL, MATH, STATISTICAL, TEXT, DATE, TIME & INFORMATION Easy to Read Step by Step Guide with Screenshots Downloadable Practice Workbooks for each Formula with Solutions New Excel Formulas For Excel 2019 & Office 365 You also get a FREE BONUS downloadable PDF version of this book!
This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Excel Formulas FAST & stand out from the crowd!
7. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Author: by Marco Russo
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization.
You’ll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services.
Want to leverage all of DAX’s remarkable capabilities? This no-compromise deep dive is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel Master core DAX concepts, including calculated columns, measures, and calculation groups Work efficiently with basic and advanced table functions Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations Use calculation groups and calculation items Use syntax of variables (VAR) to write more readable, maintainable code Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters Master advanced optimization techniques, and improve performance in aggregations Optimize data models to achieve better compression Measure DAX query performance with DAX Studio and learn how to optimize your DAX
8. Python for Excel: A Modern Environment for Automation and Data Analysis
Author: by Felix Zumstein
While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. In fact, it’s the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein-creator of xlwings, a popular open source package for automating Excel with Python-shows experienced Excel users how to integrate these two worlds efficiently.
Excel has added quite a few new capabilities over the past couple of years, but its automation language, VBA, stopped evolving a long time ago. Many Excel power users have already adopted Python for daily automation tasks. This guide gets you started.
Use Python without extensive programming knowledgeGet started with modern tools, including Jupyter notebooks and Visual Studio codeUse pandas to acquire, clean, and analyze data and replace typical Excel calculationsAutomate tedious tasks like consolidation of Excel workbooks and production of Excel reportsUse xlwings to build interactive Excel tools that use Python as a calculation engineConnect Excel to databases and CSV files and fetch data from the internet using Python codeUse Python as a single tool to replace VBA, Power Query, and Power Pivot
9. Excel: Pivot Tables & Charts (Quick Study Computer)
Author: by Inc. BarCharts
Among the many data analyzing features to be found in Microsoft’s Excel software, PivotTables and PivotCharts are two of the most useful. Find out how they can work for you with our jam-packed 3-panel guide, which features step-by-step instructions and full-color screen shots for easy reference.
10. EXCEL 2021 FOR BEGINNERS: THE COMPLETE DUMMY TO EXPERT PRACTICAL GUIDE WITH EXAMPLES THAT TEACHES EVERYTHING YOU NEED TO KNOW ABOUT MICROSOFT EXCEL … (EXCEL DUMMIES TO MASTER COURSE 2021)
Author: by JAMES JORDAN
EXCEL 2021 MADE EASY JUST FOR YOU! Microsoft has added over a hundred new features and enhancements to Excel over the past years! The tools outlined in this guide book are among those that offer some of the greatest opportunities to all levels of Excel users to improve their efficiency and proficiency.
Therefore, as you gain access to these tools and others sure to follow be sure to consider how you and your team members can and should take advantage of them to boost productivity. This book is specially made for business men, corporate bodies, organization, individuals, etc.
Who are looking for a means of learning Excel from basics to advanced (formulas, functions, VBA, Macros,etc.Level. In this Excel 2021 guide, you’ll:Learn How to Analyze the Quality of Your Data with Power QueryLearn How to use Dynamic Array(FILTER, SORT, RANDARRY, SEQUENCE, SORTBY, and UNIQUE)Learn How to enter basic formulas and calculations in excelLearn How to select, activate and edit cells in excelLearn How to Create and manage workbooks and worksheetsLearn How to create a spreadsheet in wordLearn How to create charts in excel: types and examplesLearn How to format an excel tableLearn powerful and essential Excel Formulas and FunctionsLearn How to Illustrate using XLOOKUPLearn How to Automate Data Analysis with Excel’s Ideas FeatureGet familiar with Worksheet designFind out how to work with charts and graphicsUse Excel for data management, analysis, modeling, and visualizationBasic and Professional Excel tips and tricksAnd Lots moreClick the Buy Now button to get a copy!
11. Learn Microsoft Office 2019: A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook
Author: by Linda Foulkes
Get to grips with the complete range of Office 2019 applications, explore solutions to common challenges, and discover best practices for working productively Key Features Explore MS Office to enhance productivity and boost your professional development Get up and running with the new and improved features in Microsoft Office 2019 Discover how to overcome common challenges when working with Office 2019 applications Book Description Learn Microsoft Office 2019 provides a comprehensive introduction to the latest versions of Microsoft Word, Excel, PowerPoint, Access, and Outlook.
With the help of illustrated explanations, this Microsoft Office book will take you through the updated Office 2019 applications and guide you through implementing them using practical examples. You’ll start by exploring the Word 2019 interface and creating professional Word documents using elements such as citations and cover pages, tracking changes, and performing mail merge.
You’ll then learn how to create impressive PowerPoint presentations and advance to performing calculations and setting up workbooks in Excel 2019, along with discovering its data analysis features. Later chapters will focus on Access 2019, assisting you in everything from organizing a database to constructing advanced queries.
12. Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
Author: by Rob Collie
Holy Macro! Books
Microsoft Power BI, including Power Pivot and Power Query, are a set of free add-ons to Excel that allow users to produce new kinds of reports and analyses that were simply impossible before. This book, printed in full-gorgeous color, gives you an overview of Power BI, Power Pivot and Power Query, and then dives into DAX formulas, the core capability of Power Pivot.
Always from the perspective of the Excel audience. Written by the world’s foremost Power BI bloggers and practitioners, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce.
This book includes lessons on: difference between calculated columns and measureshow formulas can be reused across reports of completely different shapeshow to merge disjointed sets of data into unified reportshow to make certain columns in a pivot behave as if the pivot were filtered while other columns do nothow to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar.
13. Excel VBA Programming For Dummies 5th Edition
Author: by Michael Alexander
Take your Excel programming skills to the next level To take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
Inside, you’ll find an overview of the essential elements and concepts for programming with Excel. In no time, you’ll discover techniques for handling errors and exterminating bugs, working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, readers will be creating Excel applications custom fit to their unique needs!
Fully updated for the new Excel 2019 Step-by-step instructions for creating VBA macros to maximize productivity Guidance on customizing your applications so they work the way you want All sample programs, VBA code, and worksheets are available at dummies. Com Beginning VBA programmers rejoice!
14. Microsoft Excel 2019 Data Analysis and Business Modeling (Business Skills)
Author: by Wayne Winston
Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tablesand how to effectively build a relational data source inside an Excel workbook.
15. Excel 2019 For Dummies
Author: by Greg Harvey
The bestselling Excel book on the market now in a new edition covering the latest version of Excel! Excel is the spreadsheet and data analysis tool of choice for people across the globe who utilize the Microsoft Office suite to make their work and personal lives easier.
It is estimated that 1 in 7 people on the planet use Microsoft Office! If you’re one of them, and want to get up to speed on the latest changes in Excel, you’ve come to the right place. Excel 2019 For Dummies has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand.
It includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing webpage, pivot tables, pivot charts, formulas and functions, Excel data analysis, sending worksheets via e-mail, and so much more!
16. 101 Best Excel Tips & Tricks (101 Excel Series)
Author: by John Michaloudis
Learn the Best Excel Tips & Tricks Ever: FORMULAS, MACROS (VBA), PIVOT TABLES, FORMATTING, DATA, MICROSOFT OFFICE 365 plus Many More! With this book, you’ll learn to apply the must know Excel features and tricks to make your data analysis & reporting easier and will save time in the process.
With this book you get the following: 101 Best Excel Tips & Tricks To Advance Your Excel Skills & Save You Hours New Excel Tips & Tricks for Microsoft Office 365 Easy to Read Step by Step Guide with Screenshots Downloadable Practice Excel Workbooks for each Tip & Trick You also get a FREE BONUS downloadable PDF version of this book!
This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Microsoft Excel FAST & stand out from the crowd!