Wednesday, April 17, 2019
Intermediate MS Excel 2016
8:30:00 AM - 8:30:00 AM
 
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: •Work with functions. •Work with lists. •Analyze data. •Visualize data with charts. •Use PivotTables and PivotCharts.

Advanced MS Excel 2013
8:30:00 AM - 8:30:00 AM
 
Students will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.