Microsoft Office Excel 2019 : Intermediate

This course will introduce students to Microsoft Office Excel 2019, and teach students about performing calculations, modifying a worksheet, formatting a worksheet, printing workbooks, managing workbooks, adding borders and colors to worksheets, and basic Excel customization.

This course will teach students about working with functions, working with lists, analyzing data, visualizing data with charts, using PivotTables and PivotCharts, working with graphical objects, and using array formulas.

This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.