Textbook: Excel 2019 Level 2, Student Manual EXEL 2019-L2-R10-S. For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2019. For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2019. 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 2019 (exam). Finally, you will customize the Excel environment, and create and modify custom templates.
LEARN EXCEL ONLINE DATA ANALYSIS LEVEL HOW TO
In addition, you will learn how to create outlines and subtotals, and how to create and apply cell names. You will sort and filter data, and create and format tables. You will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. You will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. 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 2019, and use multiple worksheets and workbooks efficiently. Textbook: Excel 2019 Level 1, Student Manual EXEL 2019-L1-R10-S For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2019. the instructor will provide an online test preparation application for this course. 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 2019, including identifying Excel window components, navigating worksheets, and downloading templates.