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.