Excel 2016 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. 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!
Record details
ISBN:9781840786514
ISBN:1840786515
Physical Description:print 192 pages : color illustrations ; 23 cm.
Publisher:Leamington Spa, Warwickshire, United Kingdom :In Easy Steps Limited,[2016]
Content descriptions
Formatted Contents Note:
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).
Book
