Excel Advanced
This course builds on the skills and concepts taught in Excel Beyond Basics course. Students will learn details of PivotTables – beyond SUM! They will create and apply Named Ranges. Students will work with backbone functions like IF, AND, OR, IFERROR, VLOOKUP, MATCH, and INDEX. Calculations with Dates and Date functions is an important part of this course. In addition, students will learn about data validation. Macros will expose the students to automation inside Excel. Finally, students will learn techniques of Data merging, Protection, Conditional Formatting, and Charting.