Excel 2016 / Michael Price & Mike McGrath.

Enhanced descriptions from Syndetics:

Excel 2016 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include:

Creating, editing and manipulating worksheets
Formulas, Functions and Pivot Tables
Handy templates to give you a head start
Macros for everyday tasks to save time
Charts to get an overview of your data
Linking workbooks for automatic updates
Using the Excel Online app to share and collaborate on spreadsheets and workbooks
Adding images and illustrations to your spreadsheet to impress your colleagues!


Whether you're upgrading to Excel 2016 or new to the spreadsheet concept, use this guide to learn the key features constructively and get more out of Excel 2016 - in easy steps !

Table of contents provided by Syndetics

• 1 Introduction (p. 7)
• The Spreadsheet Concept (p. 8)
• Microsoft Excel (p. 10)
• Microsoft Office 2016 (p. 11)
• System Requirements (p. 12)
• Getting Office 2016 (p. 13)
• Excel 2016 and Windows 10 (p. 14)
• The Office 2016 Ribbon (p. 16)
• Exploring Excel 2016 (p. 18)
• Excel Online App (p. 20)
• 2 Begin with Excel (p. 21)
• The Excel Window (p. 22)
• Create a Workbook (p. 24)
• Add Data to the Worksheet (p. 25)
• Build the Worksheet (p. 26)
• Fill Cells (p. 28)
• Complete the Worksheet (p. 29)
• Format the Text (p. 30)
• Format the Numbers (p. 31)
• Print the Worksheet (p. 32)
• Insert, Copy and Paste (p. 34)
• Excel Help (p. 35)
• Contextual Help (p. 36)
• Excel File Formats (p. 37)
• 3 Manage Data (p. 39)
• Use Existing Data (p. 40)
• Import Data (p. 42)
• Navigate the Worksheet (p. 44)
• Scroll with the Wheel Mouse (p. 46)
• Keystrokes and Touch (p. 47)
• Sort Rows (p. 48)
• Find Entries (p. 49)
• Filter Information (p. 50)
• Remove Duplicate Entries (p. 52)
• Check Spelling (p. 53)
• Freeze Headers and Labels (p. 54)
• Hide Columns or Rows (p. 55)
• Protect a Worksheet (p. 56)
• 4 Formulas and Functions (p. 57)
• Number Formats (p. 58)
• Text Formats (p. 60)
• Relative References (p. 61)
• Absolute References (p. 62)
• Name References (p. 63)
• Operators (p. 64)
• Calculation Sequence (p. 65)
• Functions (p. 66)
• AutoSum (p. 68)
• Formula Errors (p. 69)
• Add Comments (p. 70)
• 5 Excel Tables (p. 71)
• Create an Excel Table (p. 72)
• Edit Tables (p. 74)
• Table Styles (p. 75)
• Table Totals (p. 76)
• Count Unique Entries (p. 77)
• Structured References (p. 78)
• Calculated Columns (p. 79)
• Insert Rows (p. 80)
• Custom Sort (p. 82)
• Print a Table (p. 83)
• Summarize a Table (p. 84)
• Convert to a Range (p. 86)
• 6 Advanced Functions (p. 87)
• Function Library (p. 88)
• Logical Functions (p. 89)
• Lookup/Reference Functions (p. 90)
• Financial Functions (p. 92)
• Date & Time Functions (p. 94)
• Text Functions (p. 96)
• Math SL Trig Functions (p. 98)
• Random Numbers (p. 100)
• Other Functions: Statistical (p. 101)
• Other Functions: Engineering (p. 102)
• Excel Add-ins (p. 103)
• Evaluate Formula (p. 104)
• 7 Control Excel (p. 105)
• Audit Formulas (p. 106)
• Protect Formulas (p. 108)
• Check for Errors (p. 109)
• Backup (p. 111)
• AutoSave and AutoRecover (p. 112)
• Startup Switches (p. 113)
• Create a Shortcut (p. 114)
• Ribbon Key Tips (p. 115)
• Using Key Tips (p. 116)
• Collapse the Ribbon (p. 118)
• Quick Access Toolbar (p. 119)
• Mini Toolbar (p. 120)
• Print Worksheets (p. 121)
• 8 Charts (p. 123)
• Create a Chart (p. 124)
• Default Chart Type (p. 125)
• Change Chart Layout (p. 127)
• Legend and Data Table (p. 128)
• Change Chart Type (p. 129)
• Pie Chart (p. 130)
• 3-D Pie Chart (p. 132)
• 3-D Column Chart (p. 133)
• Share Price Data (p. 134)
• Line Chart (p. 135)
• Stock Chart (p. 136)
• Mixed Types (p. 137)
• Print Charts (p. 138)
• 9 Macros in Excel (p. 139)
• Macros (p. 140)
• Create Macros (p. 141)
• Record a Macro (p. 142)
• Apply the Macro (p. 144)
• View the Macro (p. 145)
• Macro to Make a Table (p. 146)
• Edit the Macro (p. 148)
• Use the Macro (p. 149)
• Create Macros with VBA (p. 150)
• Add Macros to the Toolbar (p. 152)
• Debug Macros (p. 154)
• 10 Templates and Scenarios (p. 155)
• Templates (p. 156)
• Online Templates (p. 158)
• More Excel Resources (p. 160)
• What-If Analysis (p. 162)
• Summary Reports (p. 164)
• Goal Seek (p. 166)
• Optimization (p. 167)
• Project Worksheet (p. 168)
• Solver (p. 169)
• 11 Links and Connections (p. 171)
• Link to Workbooks (p. 172)
• Create External References (p. 174)
• Styles of Reference (p. 176)
• Source Workbook Changes (p. 177)
• Apply the Updates (p. 178)
• Turn Off the Prompt (p. 179)
• Save Workbook Online (p. 180)
• Using the Excel Online App (p. 182)
• Excel in Word (p. 184)
• Publish as PDF (or XPS) (p. 186)
• Index (p. 187)

Author notes provided by Syndetics