Delve into configuring the spell check and autoCorrect options transferring, and copying and pasting data. Explore how to create automatic data series use the Flash Fill feature, and insert dropdown menus. The course continues by demonstrating how to edit multiple worksheets simultaneously delete items in a spreadsheet and how to use the undo and redo actions. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters.

Begin by learning how to select cells in order to apply changes to individual or multiple cells. In this course, learners can explore various ways to insert, edit, and manipulate data. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Saving Workbooks Exercise as well as the associated materials in the Resources section.ĭelve into data manipulation techniques with Excel 2019 for Windows. The course concludes by showing how to create an accessible document, and how to protect your document or restrict all access with a password.

Discover how to check for compatibility issues edit your document properties and check for personal information in your document. Examine how to set your print area adjust your print page layout, and then print your document. Learn how to insert headers and footers, useful if you have additional information to insert into a spreadsheet. Next, observe how to save your worksheet or workbook as an Excel version or pdf and recover unsaved documents. This leads into how to manage worksheets, which are used in Excel to manage different sets of data within a workbook. During this course, you will begin by learning how to create and open a document, and then learn how to use document templates. Create a new spreadsheet and workbook, with Excel 2019.

Excel office 2019