Desktop Certifications     Microsoft     Microsoft Office Specialist: Associate (Office 365 and Office 2019)     MO-200: Microsoft Excel (Excel and Excel 2019)

---

Delve into data manipulation techniques with Excel 2019 for Windows. In this course, learners can explore various ways to insert, edit, and manipulate data. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. 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. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose a data range.

---

---

Objectives

Excel 2019 for Windows: Inserting & Manipulating Data select cells in Excel 2019 input data in Excel 2019 insert special characters in Excel 2019 edit multiple Excel 2019 worksheets simultaneously delete items in your Excel 2019 spreadsheet undo and redo actions in Excel 2019 create automatic data series in Excel 2019 use the Excel 2019 Flash Fill feature insert dropdown menus in Excel 2019 use the spell check tool in Excel 2019 configure spell check and AutoCorrect options in Excel 2019 transfer data in Excel 2019 copy and paste data in Excel 2019 move data from one Excel 2019 worksheet to another use the Excel 2019 Paste Special tools transpose a data range in Excel 2019 consolidate your data in Excel 2019