Microsoft Office Specialist Excel 2019 Courseware

This courseware covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs. Candidates are expected to demonstrate the correct application of the principal features of Microsoft Excel. A basic understanding of Microsoft Excel or a spreadsheet program along with basic computers skills is a must. The ideal candidates will be those who work in an environment where MS Excel is used on a regular basis to perform office functions. Course Outline    Chapter 1 Manage worksheets and workbooks  Import data into workbooks  Import data from .txt files  Import data from .csv files  Navigate within workbooks  Search for data within a workbook  Navigate to named cells, ranges, or workbook elements  Insert and remove hyperlinks  Format worksheets and workbooks  Modify page setup  Adjust ro