SMS-105     Microsoft® Excel 2010/2013/2016 - Intermediate

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

<

>

In this course, participant will build upon the foundational 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 database effectively.
• Apply proper formula and function.
• Troubleshooting errors
• Link and Embed Data from other sources.
• Applying Conditional Formatting and Validation Rules.

• Customizing the Excel Environment
• Organizing and Analysing Datasets and Tables
• Creating Basic to Advanced Formulas
• Working with Statistical and Database Functions
  
• ​Manipulating Dates, Times, and Text
• Managing Workbooks
• Grouping and Outlining Data 
• Templates  ​
• Visualizing Data with Basic Charts 
  
  

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.