Intro -- Excel® 2016 Formulas -- About the Authors -- About the Technical Editor -- Credits -- Contents at a Glance -- Table of Contents -- Introduction -- Part I: Understanding Formula Basics -- Chapter 1: The Excel User Interface in a Nutshell -- The Workings of Workbooks -- Worksheets -- Chart sheets -- Macro sheets and dialog sheets -- The Excel User Interface -- The Ribbon -- Backstage View -- Shortcut menus and the mini toolbar -- Dialog boxes -- Customizing the UI -- Task panes -- Customizing onscreen display -- Numeric formatting -- Stylistic formatting -- Protection Options -- Securing access to the entire workbook -- Limiting access to specific worksheet ranges -- Protecting the workbook structure -- Chapter 2: Basic Facts About Formulas -- Entering and Editing Formulas -- Formula elements -- Entering a formula -- Pasting names -- Spaces and line breaks -- Formula limits -- Sample formulas -- Editing formulas -- Using Operators in Formulas -- Reference operators -- Sample formulas that use operators -- Operator precedence -- Nested parentheses -- Calculating Formulas -- Cell and Range References -- Creating an absolute or a mixed reference -- Referencing other sheets or workbooks -- Copying or Moving Formulas -- Making an Exact Copy of a Formula -- Converting Formulas to Values -- Hiding Formulas -- Errors in Formulas -- Dealing with Circular References -- Goal Seeking -- A goal seeking example -- More about goal seeking -- Chapter 3: Working with Names -- What's in a Name? -- A Name's Scope -- Referencing names -- Referencing names from another workbook -- Conflicting names -- The Name Manager -- Creating names -- Editing names -- Deleting names -- Shortcuts for Creating Cell and Range Names -- The New Name dialog box -- Creating names using the Name box -- Creating names from text in cells -- Naming entire rows and columns.
