Microsoft Excel 2010 /2007 for Business

Program Duration: 2 days

Audience: Anyone interested in using Microsoft Excel 2010 to create, edit, format, and display data in a worksheet. This program is especially effective for beginners, as well as intermediate users who want to sharpen their skills, work more efficiently and learn Excel 2010’s new functions and interface.

Program History: Introduced in 2012, this program was established to aid participants in understanding the basics, as well as the powerful capabilities of Microsoft Excel 2010. This program currently utilizes Microsoft Excel 2010, but the skills learned can be applied to Microsoft Excel 2007 and earlier versions of Microsoft Excel.

Program Description: This program is designed for anyone who wants to learn the basic and advanced skills of Microsoft Excel 2010. Participants will learn how to create, edit, format, and print Microsoft Office Excel 2010 worksheets. Enhanced functions for calculating data using functions and formulas, sorting and filtering data, using Pivot Tables and Pivot Charts for analyzing data, and customizing workbooks is also included in this program. This is an instructor lead course utilizing hands-on activities, collaborative learning and lecture to provide participants with a well-rounded program. During the course each participant will be provided the use of an individual computer pre-loaded with the Microsoft Excel 2010 software. The skills learned can be applied to Microsoft Excel 2007 and earlier versions of Microsoft Excel. A comprehensive manual is included with this program.

Program Contents:
• Excel 2010 User Interface And Ribbon
• Keyboard Shortcuts
• Create A Basic Worksheet
• Input Data
• Perform Calculations In An Excel Worksheet
• Format A Worksheet
• Modify An Excel Worksheet
• Manage Lists
• Protect And Secure Data
• Print The Content Of An Excel Workbook
• Create And Use Formulas And Functions
• Hide Data
• Sort and Filter Data
• Understand Absolute, Relative And Mixed Cell References
• Create Custom Conditional Formatting Rules
• Recording And Using Macros
• Organize Worksheet And Table Data Using Various Techniques
• Create And Modify Charts
• Analyze Data Using Pivot Tables And Pivot Charts
• Insert And Modify Graphic Objects In A Worksheet
• Import And Export Data