Microsoft Excel 2019 - Level II

This course introduces Excel functionality for enhancing your worksheets for presentation purposes or for printing. Students will learn how to use the Page Setup tools to adjust their worksheets with custom margins, page orientation, page breaks, and headers and footers. They will learn how to sort large spreadsheets; how to filter data and create advanced filters; how to group and summarize data; and how to insert subtotals. How to manage data within multiple worksheets and workbooks and how to link that data with formulas and named cells will also be covered, as well as a few more functions, including the IF function and the DATE and PMT functions. Prerequisite: Excel I or equivalent knowledge