Description
Learn powerful productivityboosting tips and secrets that will speed up your work in Excel and remove some of those hairtearingout moments.
This course will cover the benefits of using tables to store listbased data. We will demonstrate how to create a table and add, delete, and modify data within a table. We will also discuss the advantages of using tables over traditional ranges, including automatic formatting, sorting, and filtering. We will demonstrate how to create a pivot table and show how to summarize and analyze large amounts of data using pivot tables. Learn various timesaving data entry shortcuts for entering data in Excel and how to use data across worksheets and workbooks, including how to use formulas to link data between worksheets, how to use 3D references to summarize data across multiple worksheets, and how to use external references to link data between workbooks. We will also cover how to use conditional formatting to automatically format cells based on their values. We will demonstrate how to create rules to highlight cells that meet certain criteria, such as values above or below a certain threshold, duplicate values, or cells that contain specific text. Lastly, we will cover how to protect your spreadsheets from accidental or intentional changes. We will demonstrate how to lock cells or ranges to prevent users from editing them and how to passwordprotect your workbook to prevent unauthorized access.
Date: 2023-05-09 Start Time: 1:00 PM ET End Time: 2:05 PM ET
Learning Objectives
* You will be able to describe how to reference data across multiple worksheets and workbooks.
* You will be able to discuss the benefits of using tables to store listbased data.
* You will be able to explain how to use conditional formatting to automatically format cells based on their values.
* You will be able to identify ways to protect your spreadsheets from accidental or intentional changes.