Microsoft Office Excel 2010 Intermediate

This course is designed to introduce people to Microsoft Excel features to improve their productivity. The course will include how to plan and incorporate Financial Functions in workbooks using range names; create 3-D formulas, to include linking information from one worksheet to another; and the creation of Data Tables for analytical purposes. Students will also create a loan payment calculator, and an amortization schedule using financial functions in the process. In addition, students will develop, queryand filter an Excel Database. They will also create workbook templates, use the consolidation feature, and examine Smart Art graphics.