EXCEL 2019: A Beginner’s Guide to Learn and Understand the Basics of Excel 2019

Introduction
CHAPTER 1: Getting Started
	1.1Introducing Excel
	1.2Worksheets and Workbooks
	1.3Create custom Toolbar for Easy Access
CHAPTER 2: Entering & Editing Data in a Worksheet
	2.1Types of Data
	2.2Entering Dates and Times into Your Worksheets
	2.3Modifying Cell Contents
	2.4Performing Basic Worksheet Operations
	2.5Working with Columns and Rows:
	2.6Working with Excel Ranges and Tables:
CHAPTER 3: Excel Files and Templates
	3.1Build a New Workbook
	3.2Opening an Existing Workbook:
	3.3Auto Recover:
	3.4Password-Protecting a Workbook:
	3.5Organizing Your Files:
	3.6Closing a Workbook:
	3.7Working with Templates:
	3.8Creating a Workbook from a Template:
	3.9Printing Your Work:
CHAPTER 4: Introducing Functions and Formulas
	4.1Using Functions in your Formulas:
	4.2Entering Formulas into Your Worksheets:
	4.3Inserting Functions into Formulas:
	4.4Using Formulas within a Table:
CHAPTER 5: Formulas for Common Mathematical Operations
	5.1Calculating Percent of Goal:
	5.2Calculating Percent Variance
	5.3Calculating Percent Variance with Negative Values:
	5.4Calculating a Running Total:
	5.5Dealing with Divide-by-Zero Errors:
	5.6Using Excel’s Conversion Functions:
Conclusion: