Excel 2019 Functions: 70 Top Excel Functions Made Easy (Excel 2019 Mastery)
$5.99
Price: $5.99
(as of May 21,2023 18:36:05 UTC – Details)
Excel is an incredibly powerful tool, but understanding all the functions it offers can be a daunting task. That’s where Excel 2019 Functions comes in! This book provides a detailed walkthrough of 70 of the most useful Excel functions, complete with tips to help you maximize the power of Excel through their use.
For each function, the book offers a detailed description, the arguments it requires, and fitting examples to demonstrate its use. Whether you’re dealing with simple calculations or building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.
Excel 2019 Functions covers all the essential functions and provides insights into the newer functions introduced in Excel 2016 and 2019, like the IFS function, that enable you to create more powerful formulas with less syntax.
This book is ideal for both beginners and experienced Excel users as it provides a great reference guide for Excel functions. By the time you complete this guide, you’ll understand how functions work in Excel, how to find the right functions, and how to combine them to solve complex problems.
The book comes with downloadable Excel practice files for all examples, so you can follow the tutorials without needing to create the examples from scratch. With Excel 2019 Functions, you’ll learn how to:
- Find and enter functions in Excel.
- Use lookup and reference functions to find and reference values in your formulas.
- Use logical functions to execute conditional statements and calculations.
- Deploy IFS functions in place of convoluted nested functions for more efficient and robust formulas.
- Use a wide array of date and time functions to address all kinds of date calculations.
- Manipulate text strings with text functions.
- Carry out financial calculations with special financial functions.
- And much more…
If you want to leverage the full power of Excel functions, then click the ‘Add to Cart’ button on the right-hand side of the page to get started today!
From the Publisher
| Content | Beginning | Intermediate to Advanced | Intermediate | Intermediate to Advanced | Beginning to Advanced | Beginning to Advanced |
|---|---|---|---|---|---|---|
| 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 | x | |||||
| 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 | x | x | ||||
| 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 | x | |||||
| 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 | x | |||||
| 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 | x | |||||
| 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 | x |
Downloadable practice files are available for all examples.
Excel 2019 Functions comes in e-book, paperback, and hardcover formats.
Publisher : Independently published (February 7, 2019)
Language : English
Paperback : 205 pages
ISBN-10 : 1796379948
ISBN-13 : 978-1796379945
Item Weight : 10 ounces
Dimensions : 6 x 0.47 x 9 inches
User Reviews
Be the first to review “Excel 2019 Functions: 70 Top Excel Functions Made Easy (Excel 2019 Mastery)”
Related Products
$5.99
There are no reviews yet.