Excel 2019 Basics

Introduction

Who Is This Book For?

How to Use This Book

Assumptions

Practice Files

Improvements in Excel 2019

1. Getting Started with Excel

1.1 Creating a New Excel Workbook

1.2 The Excel User Interface

1.3 Using AutoSave

1.4 Customising the Ribbon

1.5 Getting Help in Excel

2. Entering and Editing Data

2.1 Entering and Editing Data Manually

2.2 Using AutoFill

2.3 Using Flash Fill

3. Design and Organise Workbooks

3.1 Adding New Worksheets

3.2 Moving and Copying Worksheets

3.3 Freezing Rows and Columns

3.4 Applying Themes to Your Worksheet

4. Organising Your Data

4.1 Copying, Moving and Deleting Data

4.2 Find and Replace Data

4.3 Sorting Data

4.4 Filtering Data

Applying a Custom Filter

Changing the Sort Order of a Filtered List

5. Formatting Cells

5.1 Arrange Cells, Rows and Columns

5.2 Applying Number Formats

5.3 Copy Cell Formatting

5.4 Conditional Formatting

6. Carrying out Calculations with Formulas

6.1 Operators in Excel

6.2 Entering a Formula

6.3 Calculating Percentages

6.4 The AutoSum Tool

6.5 Quick Sum with the Status Bar

6.6 Calculating Date and Time

6.7 Relative and Absolute Cell Reference

6.8 Using Data from Other Worksheets

7. Creating Data Validation Rules

How to Add a Data Validation Rule

How to Edit or Remove Data Validation Rules

8. Named Ranges

9. Working with Functions

9.1 How to Enter a Function

9.2 Aggregate Functions

SUM Function

AVERAGE Function

MAX, MIN, MEDIAN Functions

COUNT Function

9.3 Conditional Functions

IF Function

Nested IF Functions

Advanced IF Functions

9.4 Date Functions

DATE Function

DATEDIF Function

DAYS Function

9.5 Find Data with VLOOKUP

9.6 Find Data with XLOOKUP

Vertical Lookup

Horizontal Lookup

Simultaneous Vertical and Horizontal Lookup

Return Multiple Values with Horizontal Spill

Return Multiple Values with Vertical Spill

9.7 Manipulate Text

LEN Function

MID Function

9.8 Accessing More Functions in Excel

10. Working with Tables

10.1 Create an Excel Table

10.2 Choosing a Table Style

10.3 Sorting Data in a Table

10.4 Filtering Table Data

10.5 Adding a Totals Row to Your Table

10.6 Removing Table Attributes

11. Introduction to Pivot Tables

11.1 Creating a Pivot Table

11.2 Filter and Sort a Pivot Table

12. Creating Charts

12.1 Creating a Chart via the Quick Analysis Tool

12.2 Creating a Chart via the Excel Ribbon

12.3 Customising Charts

Switching the X and Y Axes

Change the Data Source

Adding Axis Titles

Chart Styles

12.4 Creating Sparkline Charts

13. Printing Your Worksheet

14. Securing Your Workbook

Afterword: Next Steps

Appendix: Keyboard Shortcuts (Excel for Windows)

Glossary

Leave a Review

Other Books by Author