Course Details

This Microsoft Excel 2019 : Level 2 - Intermediate 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 2019, 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