Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel

by Nathan George

Overview

A Step-By-Step Approach to Learning Excel Fast

Excel 2019 Basics covers all you need to quickly get up to speed in creating spreadsheets to provide solutions for your data. If you are new to Excel and the thought of spreadsheets makes your head spin, then you've come to the right place. This book will hold your hand through a step-by-step process in becoming skilled with Excel. If you already have some Excel skills and you want to skill-up on more advanced topics like functions, Excel tables, pivot tables, and charts, then you've also come to the right place. Excel 2019 Basics goes beyond introduction topics and covers topics like functions, Excel tables, and analysing your data with charts. The aim of this book is to guide you from beginner to being skilled with Excel within a few short hours.

Learn Excel Quicker by Avoiding Unnecessary Fillers

This book cuts to the chase without the unnecessary verbosity seen in many other Excel books. You don't need to get through a wall of text to learn how to quickly carry out various tasks in Excel. Hence, Excel 2019 Basics focuses on providing direct instructions for how to complete tasks with screenshots where necessary to illustrate the concepts.

In this book, you'll learn how to:

• Add, name, copy and move worksheets.
• Freeze and unfreeze panes (rows and columns).
• Use AutoFill and Flash Fill to automate repetitive tasks.
• Move and copy data.
• Format cells, ranges and tables.
• Create formulas for different types of calculations.
• Use absolute and relative cell references.
• Use AutoSum to quickly automate calculations.
• Use functions like IF, DATE, DATEDIF, LEN, MID, VLOOKUP, and XLOOKUP.
• Work with Excel tables, including applying table styles.
• Easily filter and sort your data.
• Dynamically analyze your data with Pivot Table tools that can carry out automated data summaries in seconds that would have taken hours to do manually!
• Use the Quick Analysis tool to generate charts and sparklines with just a few clicks.
• Secure your workbook data and design with a password.
• Use many more Excel features...

Product Details

ISBN-13:	9781916211308
Publisher:	Gtech Publishing
Publication date:	08/16/2019
Series:	Excel 2019 Mastery , #1
Pages:	234
Product dimensions:	6.00(w) x 9.00(h) x 0.49(d)

About the Author

Nathan George is a computer science graduate with several years' experience in the IT services industry in different roles which included Excel VBA programming, Excel training, and providing end-user support to Excel power users. One of his main interests is using computers to automate tasks and increase productivity. As an author, he has written several technical and non-technical books.

Table of Contents

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.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 Manipulate Text

• LEN Function
• MID Function

9.7 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

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