Microsoft Excel – Advanced Level

Description

Some skills have become important for personal effectiveness and business process efficiency – Microsoft Excel stands out as one of them. This course offers the need to optimize efficiency, productivity and accuracy with Microsoft Excel. From the basic use to the complex modeling application, there is knowledge and productivity to be gained.

It is a 2-day instructor-led course that provides the participant with the necessary knowledge and skill to become a proficient user of Microsoft Excel while equipped with the use of its advanced functionalities.  Training will be facilitated by experienced, qualified and tested Microsoft Office Trainers.

Learning Outcomes                                                                                                                                                                                                                              Upon successful completion of this course students will be able to demonstrate and efficiently use the following:

• Demonstrate working knowledge of MS Excel advanced formatting techniques and presentation styles.
• Automate recurring processes
• Clean and prepare data for analysis, and learn how to work with dates and financial function
• Know which features and functions should be used for various high-level tasks
• Use Charts and Other graphics to present data
• Improve efficiency in the use of Excel at work

Course Modules

• Introduction to Excel Advanced
• Using Text to Columns
• The Paste Special Function
• Data Validation
• Subtotals and Grouping
• Consolidating Data
• Scenario Analysis
• Data Tables in Scenario Analysis
• What-if Analysis
• Mats and Trig Functions
• Text Functions in Excel
• Using Lookup Functions
• V-Lookups
• H-Lookups
• Using Statistical Functions
• Database Functions
• Formula Auditing and Error Tracing
• Hyperlinks in Excel
• Linking Data
• Understanding Pivot Tables
• Using Pivot Charts
• Workbook Properties
• Protecting and Sharing Worksheets
• Data Encrypting and Finalising Workbooks
• Understanding & Using Macros
• Custom Number Formats in Excel
• Using Custom Lists
• Working with Templates
• Tracking Changes in Excel
• Merging and Comparing Excel Workbooks
• Dashboards, Form Control & Power View
• PowerPivot -Intro

Mode of Delivery

• Virtual Class with instructor-led class exercises and project-based/assignments learning methodology
• 9hours of learning sessions
• Course material and Course Certificate will be issued
• Course video available on demand
• Face- to- Face learning option is available