Course Details

Modular training on MS Excel 2013 - Level 2 is done by us. This course is ideal for those who would like to be able to work comfortably with Microsoft Excel.

Objectives :

• Understand the intermediate functions of Microsoft Excel 2013, and how it differs from 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
• Inserting 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