Price: $5.99
From the Publisher
Content
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
Downloadable Practice Files
✓
✓
✓
✓
✓
✓
Reader Level
Beginning Intermediate to Advanced Intermediate Intermediate to Advanced Beginning to Advanced Beginning to Advanced
This Book is Perfect For
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
eBook, Paperback, and Hard Cover eBook and Paperback eBook and Paperback eBook and Paperback eBook and Paperback eBook and Paperback
Content
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, Import/Export external data, Power Query Editor, Fix formula errors, Advanced conditional formulas, Financial functions, Macros, What-If Analysis, Pivot Tables, Pivot Charts, Slicers, and Worksheet Protection Lookup functions Like XLOOKUP and XMATCH, logical functions like IF and IFS, Math functions, Statistical functions, Date and Time functions like DATEDIF and EDATE, Text Functions like TEXTAFTER and TEXTSPLIT, Financial Functions like PV, FV And SYD
Downloadable Practice Files
✓
✓
✓
Excel Version
Excel for Microsoft 365 (as of 2023) Excel for Microsoft 365 (as of 2023) Excel for Microsoft 365 (as of 2023)
Reader Level
Beginner Intermediate to Advanced Intermediate
Ideal For
Business and Financial Professionals, Entrepreneurs, Students, Personal Finance Business and Financial Professionals, Power Users, Entrepreneurs, Data Analysts, and Students Business and Financial Professionals, Power Users, Entrepreneurs, Data Analysts, and Students
Available Formats
eBook, Paperback, and Hard Cover eBook and Paperback eBook and Paperback
Publisher : GTech Publishing (May 17, 2020)
Language : English
Paperback : 100 pages
ISBN-10 : 1916211364
ISBN-13 : 978-1916211360
Item Weight : 5.1 ounces
Dimensions : 6 x 0.23 x 9 inches
Price: $5.99
