LoveReading

Becoming a member of the LoveReading community is free.

No catches, no fine print just unadulterated book loving, with your favourite books saved to your own digital bookshelf.

New members get entered into our monthly draw to win £100 to spend in your local bookshop Plus lots lots more…

Find out more

Spreadsheet software

See below for a selection of the latest books from Spreadsheet software category. Presented with a red border are the Spreadsheet software books that have been lovingly read and reviewed by the experts at Lovereading. With expert reading recommendations made by people with a passion for books and some unique features Lovereading will help you find great Spreadsheet software books and those from many more genres to read that will keep you inspired and entertained. And it's all free!

Excel 2019 Business Basics & Beyond

Excel 2019 Business Basics & Beyond

Author: Chris Smitty Smith Format: Paperback / softback Release Date: 01/10/2019

Excel 2019 Power Programming with VBA

Excel 2019 Power Programming with VBA

Author: Michael Alexander, Dick Kusleika Format: Paperback / softback Release Date: 26/04/2019

Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce--and can help you take your career to the next level. Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office Excel 2019 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.

Excel Data Analysis For Dummies

Excel Data Analysis For Dummies

Author: Paul McFedries Format: Paperback / softback Release Date: 26/10/2018

Take Excel to the next level Excel is the world's leading spreadsheet application. It's a key module in Microsoft Office--the number-one productivity suite--and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you'll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and Pivot Charts Use Excel for statistical and financial functions and data sharing Get familiar with Solver Use the Small Business Finance Manager If you're familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.

Excel VBA Programming For Dummies

Excel VBA Programming For Dummies

Author: Michael Alexander, John Walkenbach Format: Paperback / softback Release Date: 19/10/2018

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! This easy-to-follow book makes it easier than ever to excel at Excel VBA!

Microsoft Power BI Dashboards Step by Step

Microsoft Power BI Dashboards Step by Step

Author: Errin O'Connor Format: Paperback / softback Release Date: 12/10/2018

Your hands-on guide to building effective Power BI dashboards Expand your expertise-and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you're an experienced business intelligence professional or manager, you'll get all the guidance, examples, and code you need to succeed-even if you've never used Power BI before. Successfully design, architect, and implement Power BI in your organization Take full advantage of any Microsoft Power BI platform, including Power BI Premium Make upfront decisions that position your Power BI project for success Build rich, live dashboards to monitor crucial data from across your organization Aggregate data and data elements from numerous internal and external data sources Develop dynamic visualizations, including charts, maps, and graphs Bring data to life with stunning interactive reports Ensure dashboard security and compliance Drive user adoption through effective training

Excelling in Life Windows Edition

Excelling in Life Windows Edition

Author: Andres Varhola Format: Paperback / softback Release Date: 10/09/2018

Excel 2016 Hands-On Lab

Excel 2016 Hands-On Lab

Author: Handz Valentin Huiza Format: eBook Release Date: 07/09/2018

The new way to learn Excel 2016 immediately, and now the ebook is constantly updated with new topics. Learn at your own pace with real "e;step by step"e; exercises to guarantee your learning. Do not forget to download the practice files for free. With Excel 2016 Handson-Lab you will learn to:- Learn the basics of Microsoft Excel 2016- Manage different types of data- Work with basic formulas and functions- Understand the use of text, logic, search and date and time functions- Use and convert ranges into tables- Insert new types of charts

Excel JavaScript UDFs

Excel JavaScript UDFs

Author: Suat M Ozgur Format: eBook Release Date: 01/07/2018

Excel users are used to build custom functions-called user-defined functions (UDFs)-in Windows and Mac versions of the application. UDFs can be simply written in Visual Basic Editor (VBE) using the Visual Basic for Applications (VBA) language.UDFs are not portable to Excel Online and Excel for iOS due to the missing VBA capability on these platforms. Therefore, Microsoft has improved the JavaScript API that was already being used for Office add-in development to allow developers to create custom functions attached to the add-ins. These custom functions can be used like any other native functions or UDFs in Excel. While Microsoft calls these functions JavaScript custom functions, they can also be called JavaScript UDFs, which is the name used in this book.This book shows the process of creating JavaScript UDFs in Excel in Developer Preview for Office Insider program subscribers.

Excel JavaScript UDFs

Excel JavaScript UDFs

Author: Suat M Ozgur Format: eBook Release Date: 01/07/2018

Excel users are used to build custom functions-called user-defined functions (UDFs)-in Windows and Mac versions of the application. UDFs can be simply written in Visual Basic Editor (VBE) using the Visual Basic for Applications (VBA) language.UDFs are not portable to Excel Online and Excel for iOS due to the missing VBA capability on these platforms. Therefore, Microsoft has improved the JavaScript API that was already being used for Office add-in development to allow developers to create custom functions attached to the add-ins. These custom functions can be used like any other native functions or UDFs in Excel. While Microsoft calls these functions JavaScript custom functions, they can also be called JavaScript UDFs, which is the name used in this book.This book shows the process of creating JavaScript UDFs in Excel in Developer Preview for Office Insider program subscribers.

MrExcel LIVe The 54 Greatest Excel Tips of All Time

MrExcel LIVe The 54 Greatest Excel Tips of All Time

Author: Bill Jelen Format: Paperback / softback Release Date: 01/04/2018