In Microsoft® Office Excel Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Upon successful completion of this course, students will be able to:

• create and apply templates.
• create and modify charts.
• work with graphic objects.
• calculate with advanced formulas.
• sort and filter data.
• use Excel with the Web.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel. Students can obtain this level of skill by taking the following course:  

Microsoft Excel Level 1