Machine generated contents note: 1. Introduction -- Spreadsheet Concept -- Microsoft Excel -- Microsoft Office 2016 -- System Requirements -- Getting Office 2016 -- Excel 2016 and Windows 10 -- Office 2016 Ribbon -- Exploring Excel 2016 -- Excel Online App -- 2. Begin with Excel -- Excel Window -- Create a Workbook -- Add Data to the Worksheet -- Build the Worksheet -- Fill Cells -- Complete the Worksheet -- Format the Text -- Format the Numbers -- Print the Worksheet -- Insert, Copy and Paste -- Excel Help -- Contextual Help -- Excel File Formats -- 3. Manage Data -- Use Existing Data -- Import Data -- Navigate the Worksheet -- Scroll with the Wheel Mouse -- Keystrokes and Touch -- Sort Rows -- Find Entries -- Filter Information -- Remove Duplicate Entries -- Check Spelling -- Freeze Headers and Labels -- Hide Columns or Rows -- Protect a Worksheet -- 4. Formulas and Functions -- Number Formats -- Text Formats -- Relative References -- Absolute References -- Name References -- Operators -- Calculation Sequence -- Functions -- AutoSum -- Formula Errors -- Add Comments -- 5. Excel Tables -- Create an Excel Table -- Edit Tables -- Table Styles -- Table Totals -- Count Unique Entries -- Structured References -- Calculated Columns -- Insert Rows -- Custom Sort -- Print a Table -- Summarize a Table -- Convert to a Range -- 6. Advanced Functions -- Function Library -- Logical Functions -- Lookup/Reference Functions -- Financial Functions -- Date & Time Functions -- Text Functions -- Math & Trig Functions -- Random Numbers -- Other Functions: Statistical -- Other Functions: Engineering -- Excel Add-ins -- Evaluate Formula -- 7. Control Excel -- Audit Formulas -- Protect Formulas -- Check for Errors -- Backup -- AutoSave and AutoRecover -- Startup Switches -- Create a Shortcut -- Ribbon Key Tips -- Using Key Tips -- Collapse the Ribbon -- Quick Access Toolbar -- Mini Toolbar -- Print Worksheets -- 8. Charts -- Create a Chart -- Default Chart Type -- Change Chart Layout -- Legend and Data Table -- Change Chart Type -- Pie Chart -- 3-D Pie Chart -- 3-D Column Chart -- Share Price Data -- Line Chart -- Stock Chart -- Mixed Types -- Print Charts -- 9. Marcos in Excel -- Macros -- Create Macros -- Record a Macro -- Apply the Macro -- View the Macro -- Macro to Make a Table -- Edit the Macro -- Use the Macro -- Create Macros with VBA -- Add Macros to the Toolbar -- Debug Macros -- 10. Templates and Scenarios -- Templates -- Online Templates -- More Excel Resources -- What-lf Analysis -- Summary Reports -- Goal Seek -- Optimization -- Project Worksheet -- Solver -- 11. Links and Connections -- Link to Workbooks -- Create External References -- Styles of Reference -- Source Workbook Changes -- Apply the Updates -- Turn Off the Prompt -- Save Workbook Online -- Using the Excel Online App -- Excel in Word -- Publish as PDF (or XPS).