Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
94
result(s) for
"COMPUTERS Desktop Applications Spreadsheets."
Sort by:
Excel 2016 formulas
\"Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel; Create and use formulas that have the power to transform your Excel experience; Leverage supplemental material online, including sample files, templates, and worksheets from the book.\"--Www.amazon.com.
Book
Microsoft® Excel Functions and Formulas (4th Edition)
In this completely updated edition covering Excel 2016 and previous versions, this book demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. With over 250 Excel worksheet examples, files, and added video tutorials, the book is an excellent resource for all Excel users who want to understand, create, and apply formulas. Experienced users will also find this book an excellent reference for many of the program's advanced formulas and functions. The text is easy to understand with numerous step-by-step instructions and the actual, ready to use, Excel screenshots of the input and output from the formulas. A CD-ROM accompanies the book with video tutorials, worksheet files of examples for numerous functions, formulas, and all the figures from the text.
eBook
Microsoft® Excel® 2016 - Programming by Example with VBA, XML, and ASP
This book is a practical, how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2016, this book provides information on performing automatic operations on files, folders, and other Microsoft Office and Web applications. Thirty chapters loaded with illustrated, hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed.
eBook
Excel 2013 for dummies
The bestselling Excel book - completely updated for Excel 2013!As the world's leading spreadsheet application, Excel has an enormous user base.The release of Office 2013 brings major changes to Excel, so Excel For Dummies comes to the rescue once more!.
eBook
PowerPivot Alchemy
Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow \"patterns\" for dozens of common analysis, reporting, and dashboarding needs. Three \"bonus\" chapters introduce you to the newer members of the \"Power BI\" family – Power Query, Power View, and Power Map. Whether you are starting your transformation from \"old school\" Excel User to Modern Data Professional or a veteran of the Power BI arts, this book will dramatically expand your data superpowers.
eBook
Excel 2016 All-in-One For Dummies
Excel has undergone a massive makeover, and each of the mini-books in this guide covers one important area of Excel 2016. If you're new to Excel, Harvey covers all the essentials, then branches out into information on worksheets, charts and graphs, and ways to maintain and analyze the data you create.
eBook
Financial modeling : an introductory guide to Excel and VBA applications in finance
This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and.
eBook