What You’ll Learn

Microsoft Excel 2016 Level 3 builds on the skills taught in Microsoft Excel 2016 Level 1 and Level 2 classes. In this course, students learn how to work with individual cells for styles and formula content, filter the contents of a spreadsheet, create and edit charts, perform statistical functions, sort worksheets, and work with pivot tables.

Career Options

After this course, students will be able to customize cell appearance, understand and use different types of cell addresses as needed, create and edit charts and pivot tables, and sort worksheets. The resulting spreadsheets become robust analysis and presentation tools, suitable for any entry-level business professional.

Class Details

Students should have intermediate skills with Excel.

• Working in multiple worksheets within a workbook
• Building and formatting simple tables
• Using more advanced formulas
• Using more advanced function tools