Mastering Excel 2019: An All-in-One Tutorial Resource
$9.95
Price: $9.95
(as of May 21,2023 11:29:19 UTC – Details)
If you want to learn Microsoft Excel quickly and easily, look no further than Mastering Excel 2019. This comprehensive guide covers all the basics, as well as more advanced topics, that you’ll need to know to use Excel for work, school, or personal use. Whether you’re a beginner, intermediate user, or a power user, this book has something for you.
Mastering Excel 2019 is also designed to be concise and easy to use. Author Mark Moore uses practical examples to show you how to perform tasks in Excel, with no unnecessary filler text. Additionally, the book is broken down into three parts: Excel 2019 Basics, Excel 2019 Advanced Topics, and Excel 2019 Functions. All three parts are organized together in this all-in-one guide, making it an indispensable resource for anyone who uses Excel.
By reading this book, you’ll learn how to do everything from creating basic and advanced formulas to using Excel tables to manipulating data. You’ll also learn how to create charts, deploy macros, analyze data visually, and much, much more.
Mastering Excel 2019 is also incredibly useful if you need to use data from external sources, like CSV text files or websites. The book even covers topics like pivot tables and pivot charts, password protection, and What-If Analysis tools.
If you’re ready to start mastering Excel 2019 today, scroll up and click on the Buy Now button on the top right-hand side of the page.
From the Publisher:
| Content | Excel 2019 Basics | Excel 2019 Advanced Topics | Excel 2019 Functions | All-In-One Tutorial and Reference Guide |
|---|---|---|---|---|
| Autofill, Flash Fill, Freezing rows/columns, Sort and Filter, Conditional Formatting, Relative/Absolute references, Validation rules, Named ranges, IF, VLOOKUP, XLOOKUP, and DATEDIF, Excel Tables, PivotTables, Charts, Printing, and Workbook security | ✓ | ✓ | ✓ | |
| Remove Duplicates, Consolidate Data, Work with External Data, Troubleshoot and fix formula errors, Advanced conditional formulas, Financial functions, Macros, What-If Analysis, Pivot Tables, Pivot Charts, and Worksheet Protection | ✓ | ✓ | ||
| Lookup and Reference functions like VLOOKUP, Logical Functions like IFS, Math Functions, Statistical Functions, Date And Time Functions like DATEDIF And EDATE, Text Functions like FIND, MID and TEXTJOIN, Financial Functions like PV, FV And SYD | ✓ | ✓ | ||
| Record and run Macros, Assign Macros to Buttons, Macro Security, Visual Basic for Applications (VBA) essentials, Variables, Program Flow, Debugging, Excel Object Model, Editing recorded Macros, User-Defined Functions, Useful Macro Examples | ✓ | |||
| XLOOKUP function, VLOOKUP function, Using INDEX and XMATCH for Lookups, FILTER function, SORT function, Error handling with IFNA and IFERROR, Evaluate and Fix Formula Errors, Multiple Examples per function | ✓ | ✓ | ||
| Contains all the powerful content from Excel 2019 Basics, Excel 2019 Advanced Topics, and Excel 2019 Functions. Fully organized as an All-in-One tutorial and reference guide | ✓ |
Additionally, Mastering Excel 2019 comes with downloadable practice files so you can learn hands-on.
| Downloadable Practice Files | Excel 2019 Basics | Excel 2019 Advanced Topics | Excel 2019 Functions |
|---|---|---|---|
| ✓ | ✓ | ✓ | ✓ |
| Reader Level | Excel 2019 Basics | Excel 2019 Advanced Topics | Excel 2019 Functions | All-In-One Tutorial and Reference Guide |
|---|---|---|---|---|
| Beginning | ✓ | ✓ | ||
| Intermediate | ✓ | ✓ | ✓ | |
| Intermediate to Advanced | ✓ | ✓ | ✓ | |
| Beginning to Advanced | ✓ |
| This Book is Perfect For | Excel 2019 Basics | Excel 2019 Advanced Topics | Excel 2019 Functions | All-In-One Tutorial and Reference Guide |
|---|---|---|---|---|
| Professionals, Business Owners, Students, Personal Finance | ✓ | ✓ | ||
| Professionals, Business Owners, Students, Personal Finance | ✓ | ✓ | ||
| Professionals, Business Owners, Students, Personal Finance | ✓ | ✓ | ||
| Professionals, Programmers, Students | ✓ | |||
| Professionals, Business Owners, Students | ✓ | |||
| Business and Financial Professionals, Data Analysts, Power Users, Entrepreneurs, Students | ✓ |
| Available Formats | Excel 2019 Basics | Excel 2019 Advanced Topics | Excel 2019 Functions | All-In-One Tutorial and Reference Guide |
|---|---|---|---|---|
| eBook, Paperback, and Hard Cover | ✓ | ✓ | ||
| eBook and Paperback | ✓ | ✓ | ✓ |
Publisher: GTech Publishing (December 21, 2020)
Language: English
Paperback: 537 pages
ISBN-10: 1916211380
ISBN-13: 978-1916211384
Item Weight: 2.01 pounds
Dimensions: 7.5 x 1.21 x 9.25 inches
User Reviews
Be the first to review “Mastering Excel 2019: An All-in-One Tutorial Resource”
There are no reviews yet.