Excel Books

Published 03-21-2022

When you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 4th Edition shows you how to make the most of your data, including dynamic reports and visualizations. It also shows you methods for automating your reporting so you don't have to manually crunch the numbers every week, month, quarter, or year.

Published 03-07-2022

Looking for ready-made Excel macros that will streamline your workflow? Look no further! Excel Macros For Dummies, 3rd Edition helps you save time, automate, and be more productive, even with no programming experience at all. This updated edition includes more than 70 of the most productive, time-saving macros, and automations that take your Excel productivity to the next level, and much more.

Published 02-14-2022

Excel Power Pivot & Power Query For Dummies, 2nd Edition provides a solid foundation in using Excel to transform your data. Use Power Query to get your data into Excel, and then enrich that data using Power Pivot. Integrate your data from multiple platforms, improve business intelligence, and analyze at a higher level when you follow the step-by-step guides in this book.

Published 01-31-2022

Excel Data Analysis For Dummies, 5th Edition explains in depth how to use Excel as a tool for analyzing big data sets. You'll discover how to mine and analyze critical data in order to make more informed business decisions. Also, learn how to clean up large datasets, perform financial calculations, and much more.

Published 01-18-2022

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, 6th Edition introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.

Published 12-27-2021

Stunned by statistics? Exhausted by Excel? Relax! Statistical Analysis with Excel For Dummies, 5th Edition shows you how to use the world's most popular spreadsheet program to crunch numbers and interpret statistics, even if you've never taken a statistics or advanced math course.

Published 12-27-2021

Financial Modeling in Excel For Dummies, 2nd Edition is your comprehensive guide to learning how to create informative, enlightening financial models. This updated edition shows you how to stay on budget, read financial reports in Excel, and build a forecast without needing to be a math wizard.

Published 12-27-2021

This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program. Great for a beginner or someone looking to refresh or expand their knowledge of Excel.

Published 12-06-2021

You don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas & Functions For Dummies, 6th Edition show you how to transform this unassuming program into the most useful tool in your toolbox.

Published 11-29-2021

This volume includes eight books in one, filled with everything you need to use Excel to its fullest. Use this as an easy-to-navigate and understand guide for all of your Excel questions. Learn how to create and use basic worksheets, create formulas and functions, charts and graphs, and much more.