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.
Microsoft Office Excel 2010 Intermediate
New and improved features can help you be more productive, but only if you can find them when you need them. Like the other Microsoft Office 2010 programs, Excel 2010 includes the Microsoft Office Fluent interface, which consists of a customizable visual system of tools and commands.
Approximate Duration: 4 Hours
Device Compatibility: Desktop/Laptop Computer, Tablet
Training Type: Interactive