Excel Intermediate
Continuation of the Microsoft Excel Beginning course. Using the Microsoft Office Suite, focus on the higher-level concepts of Microsoft Excel spreadsheet software. Use Excel tables to analyze and manipulate data; create data validations. Work with multiple worksheets; protect worksheets and workbooks; create and save custom views. Work with images and integrating Excel with other program data. Summarize and analyze data using subtotals, PivotTables, PivotCharts and PivotReports. Work with functions such as VLOOKUP, DSUM, GETPIVOTDATA. This course will use Microsoft Office 365/Excel 2019. Pre-requisite: Excel Beginning or consent of instructor, and competency in Windows including file management skills.