Monday, December 17, 2018
Advanced MS Excel 2013
8:30:00 AM - 8:30:00 AM
 
Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.

Intermediate MS Word 2016
8:30:00 AM - 8:30:00 AM
 
In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents. You will: •Organize content using tables and charts. •Customize formats using styles and themes. •Insert content using quick parts. •Use templates to automate document formatting. •Control the flow of a document. •Simplify and manage long documents. •Use mail merge to create letters, envelopes, and labels.