Practice customizing the Excel environment; creating advanced formulas, analyzing data with functions and conditional formatting, organizing and analyzing datasets and tables, visualizing data with basic charts, and analyzing data with PivotTables, Slicers, and PivotCharts. Prerequisite: Excel Level 1 or equivalent.
Required Text:
Title: Microsoft Excel for Office 365: Part 2 Book ID: 091137S Logical Operations. If you are using the digital book you will need to order the book 24 hours in advance to ensure you receive it in time for class.