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.
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
Grouping and Outlining Data
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.