SMS-106     Microsoft® Excel 2010/2013/2016/2019/o365 - Advanced

• Overview
• Course Objectives
• Course Content
• For Whom
• Schedule and Hours

<

>

In this course, participant will build upon the essential Microsoft® Excel 2010/2013/2016 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables and data analysing tools.

After completing this course, participant will be able to

• Manage big database effectively.
• Apply proper advanced formula and function.
• Troubleshooting complex errors
• Link and Embed Data from other sources.
• Working with Complex Analysis

• Lookup, Reference, and Information Functions
• Working with Logical Functions - Advanced Formula Writing and Troubleshooting
• Analysing Data with Conditional Formatting​
  
• Working with Complex Functions
• Analysing Data Using Pivot Table
• Data Analysis and Dashboard Reporting in Excel
• Scenarios and Goal Seeking​
  
• Automating Tasks with Macros​
  
• Working in the Cloud with Office 365 

Participant who have basic skills with Microsoft® Excel 2010/2013/2016 who wish to learn more advanced skills or who wish to learn the topics covered in this course in the interface.

This is a ​2-days programme.
​
This course runs from 9:00am – 5:00pm with an hour for lunch and periodic short breaks.
 
This is an intensive session designed to include as much discussion as possible. Lunch and breaks provide an opportunity for further questioning and discussion with the instructors.

We are HRD Corp (Human Resource Development Corporation) Registered Training Provider.
​All of our training modules are claimable under HRD Corp.