We are a certified MOS training facility and all of our trainers are MOS certified.
This class will prepare you for the MOS WORD and EXCEL Expert Certifications. Topics for Word include: Modifying Templates, Compare/Combine Documents, Prepare documents for review, Track changes, Manage comments, Create styles, Indexes, Table of Contents, Table of Figures, Work with Forms - creating and editing, Create and edit Quickparts, Building Blocks, Create Custom Templates, Prepare a document for Accessibility, plus a few more topics to get you MOS ready! Topics for the Excel Expert include: Advanced functions (VLOOKUP, HLOOKUP, INDEX, CONCAT, SUMIFS, COUNTIFS, AVERAGEIFS, IF, AND, OR, etc), Managing workbooks, Protecting workbooks/worksheets, Troubleshooting formulas, Range names, Advanced charting, Smartart, Pivottables, PivotCharts, plus a whole lot more!
Word and Excel Knowledge comparable with Word and Excel MOS Specialist certification
1 week before the class begins