Excel 2019 in easy steps

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 2019 or new to the spreadsheet concept, use this guide to learn the key features constructively and get more out of Excel 2019 - in easy steps!

Author Notes

Michael Price is an accomplished author, IT journalist and systems consultant with a wide experience of computing systems ranging from mainframes to personal computers. He's also a successful author with several best-selling In Easy Steps books to his credit, including earlier editions of Excel in easy steps.

1 Introduction	p. 7
The Spreadsheet Concept	p. 8
Microsoft Excel	p. 10
Microsoft Office 2019	p. 11
System Requirements	p. 12
Getting Office 2019	p. 13
Excel 2019 and Windows 10	p. 14
The Office 201 9 Ribbon	p. 16
Exploring Excel 2019	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 & Trig Functions	p. 98
Random Numbers	p. 100
Statistical Functions	p. 101
Engineering Functions	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
Recommended Chart Type	p. 126
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
Tempiates	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

Available:*

Bound With These Titles

On Order

Summary

Summary

Author Notes

Table of Contents