Excel 2019 Basics · A Quick and Easy Guide to Boosting Your Productivity With Excel (Excel 2019 Mastery) by George, Nathan -- Read -- Imperial Library of Trantor

Index

Contents Title Copyright 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

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.5 Quick Sum with the Status Bar 6.4 The AutoSum Tool 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

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 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 9.4 Date Functions

DATE Function DATEDIF Function DAYS Function

9.5 Find Data with VLOOKUP 9.6 Manipulate Text

LEN Function MID Function

9.7 Accessing More Functions in Excel