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.
Among the many data analyzing features to be found in Microsofts 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.
Created as a book for a first-time or beginning Excel user, it is designed to be a comprehensive, yet accessible and easy to understand introduction to using and mastering Microsoft Excel 2019 and previous versions. Starting with the basics of what spreadsheets are, and progressing through the foundational concepts and features of Excel, the book ......
Microsoft Excel Functions & Formulas 4/e 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.
Designed as a project and case-oriented approach to learning Excel, the emphasis of this book is on learning by doing. The book presents a series of progressively reinforcing problem sets, which allow the exploration of real-life business problems.
Excel VBA in easy steps has an easy-to-follow style that will appeal to anyone who wants to get more from the popular Microsoft Excel Office application using VBA programming (Visual Basic for Applications). Excel VBA in easy steps begins by explaining how to record and edit macro procedures to manipulate Excel ......
Quick and easy 6-page laminated guide with locations of functions and how to perform them in Excel 2016. Whether you are a beginner or experienced user, the advanced version is more coverage of the most popular and useful functions that users may even discover and use for the first time. Curtis Frye, author of multiple books on Excel, creator of ......
Quick and easy 6 page laminated guide focuses on creating and using formulas efficiently and effectively in Excel 2016. Whether you are a beginner or experienced user, formulas are Excel's superpower that can be yours. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his ......
Quick and easy 6-page laminated guide focuses on creating and using pivot tables efficiently and effectively in Excel 2016. Whether you are a beginner or experienced user, pivot tables offer flexibility, doubling down on Excel's power. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate ......
Whether you are a beginner or experienced user, learn about new features in this version or discover and use some of Excel's functions for the first time. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for ......
Make powerful data analysis simple with our newest Excel guide. Quickly select and move data fields between rows and columns, reorder data fields, summarize data, filter data, and display the results graphically in a PivotChart. Use your data to get results and get one step closer to being an Excel power user.
Explains essential business math and how to create equations and spreadsheets in Microsoft (R) Excel to compute that math. More than a guide to using Excel, written by a professor that teaches the course Business Math with Spreadsheets, this well-rounded coverage includes screenshots, Excel equations and an explanation of the math. Great for ......
Excel is more than just handy software for making spreadsheets. If you are an Excel superuser, or looking to become one, you probably know that Excel offers high-level functions, slicers, and table features for analyzing and viewing data. Keep up to date on how to perform complex functions in the newest version of Excel with our Excel 2013 ......
Unleash the power of the newest version of Excel with this new addition to our Office Tips & Tricks line of QuickStudy (R) guides. Go beyond the basics of Excel and learn time-saving tricks and best practices, including using conditional formatting, referencing cells, and more, bringing your Excel spreadsheets to the next level.
Whether you are learning about Excel 2013's new features, making sure you know how to perform tasks from previous versions, or getting to know the software for the first time, this new addition to our line of Office guides will help keep you up to date. As always, screen shots, icons, and color-coded boxes organize information in the format you ......
Because Excel 2010 has many more features than Excel 2007 or XP, our 3-panel (6-page) guide will be a handy resource for beginning, intermediate or advanced end-users of the software. Jam-packed with information and helpful, time-saving hints, this guide features easy-to-read tables, screen captures and icons that are sure to make it an ideal ......