Excel 2016 in Easy Steps by Price, Michael -- Read -- Imperial Library of Trantor

Index

Title Copyright Contents 1 Introduction

The Spreadsheet Concept Microsoft Excel Microsoft Office 2016 System Requirements Getting Office 2016 Excel 2016 and Windows 10 The Office 2016 Ribbon Exploring Excel 2016 Excel Online App

2 Begin with Excel

The 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 Macros 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-If 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)

Back Cover

← Prev
Back
Next →

← Prev
Back
Next →