Intermediate Excel Course

INTERMEDIATE EXCEL
CEI-500

This continuing education course is designed to provide students with skills to prepare workbooks and create custom views, sort worksheet rows, freeze headings, and split worksheet windows. Topics will include modifying changes, formatting and customizing charts, and using drawing tools to add graphics. Students will learn how to use office templates, create custom templates, and work with tables, lists, and outlines.
Skills learned will include:

• Sort and filter spreadsheets
• Format data into a graphically pleasing table
• Apply conditional formatting
• Choose between charting techniques
• Track table changes and add comments for multiple users
• Using the ribbon, backstage, tell me, views, pin, templates, versions, saving, auto recover, and sharing