Course Details

Classes for level 2 - MS Excel 2010 is done by us. Users who have a good understanding and knowledge of Microsoft Excel and those who are keen to further their working knowledge of Microsoft Excel, would benefit from this course.

Objectives :

• Understand the intermediate functions of Microsoft Excel 2010, and how it is different from the previous versions
• Understand how to navigate efficiently to the relevant tools within the Microsoft Excel Chart Basics
• Prepare and format Microsoft Excel sheets and work with multi worksheets
• Be able to format various chart styles
• Proficiently use Advanced Charting
• Be able to use different viewing options
• Be able to use all advanced formatting and display options
• Be able to consolidate data and formatting charts
• Be able to insert pivot tables and charts into your Excel sheets
• Be able to secure, protect, and customise your workbook
• Understand how to use macros and be able to use all logical and statistical functions
• Understand advanced financial functions including all Lookup functions
• Understand and utilise advanced data management