

It will introduce you to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. This course will teach you how to work with large worksheets in Microsoft Excel 2021, and use multiple worksheets and workbooks efficiently.

Textbook: Excel 2021 Level 1, Student Manual EXEL2165-L1-R10-S For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2021. the instructor will provide an online test preparation application for this course. This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2021 (exam). Finally, you will review workbooks for spelling errors, modify page setup, and print worksheets. In addition, you will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. You will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. You will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. You will create and modify charts, and work with graphics. This course will familiarize you with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2021, including identifying Excel window components, navigating worksheets, and downloading templates.
