Microsoft Excel 2016 Functions And Formulas Quick Reference Card Windows Version(1st Edition)

Book details

Book Price $0 : Geared Toward The Intermediate To Advanced Excel 2016 User, This Example-rich 4-page Laminated Card/guide Provides Explanations And Context For Many Powerful Excel 2016 Spreadsheet Formulas And Functions. Step-by-step Instructions For Many Formula/function-related Features Such As Using Range Names, And Excel's Troubleshooting Features. Written With Beezix's Trademark Focus On Clarity, Accuracy, And The User's Perspective, This Guide Will Be A Valuable Resource To Improve Your Proficiency In Using Microsoft Excel 2016. This Guide Is Suitable As A Training Handout, Or Simply An Easy To Use Reference Guide. Topics Include: Controlling Order Of Precedence Conditionally Summing/Counting Data (SUMIF, COUNTIF) Being Precise (Rounding Functions) Improving Clarity With Range Names: Creating Names, Limiting Scope, Defining A Constant Or Formula For A Name, Managing Names, Indirectly Referring To A Named Range (INDIRECT) New Functions For Office 365, Mobile & Online (CONCAT, TEXTJOIN, IFS, MAXIFS/MINIFS, SWITCH) Merging Text And Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE) Changing Results: IF, AND, OR, NOT Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH) Error Recovery (ISNA, ISERROR) Array Formulas (Single Cell & Multi-Cell Arrays) Dates And Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE) Using A Formula For Data Validation Troubleshooting: Types Of Errors, Automatic Error Checking, Using The Error Checker, Showing/Hiding Formulas, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows. Examples: Summing Selected Data; Being Precise; Merging Text & Numers; Table Lookups; Table Lookups With IF And ISERROR; Dates & Times; Single- And Multi-Cell Arrays.This Guide Is One Of Multiple Titles Available For Excel 2016, Other Excel Titles Are: Excel 2016 Introduction (ISBN 1939791928); Excel 2016 Charts & Sparklines (ISBN 9781939791955); Excel 2016 Tables, PivotTables, Sorting, Filtering & Inquire (ISBN 9781939791962); Excel 2016 Business Analytics & Power BI (ISBN 9781944684143); Excel 2016 Advanced Features & Macros (ISBN 9781944684082). See more