MS Excel (Intermediate Level)
Introduction
You already know how to get Microsoft® Office Excel 2019 to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret and present to others. But Microsoft® Office Excel 2019 is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organisational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Microsoft® Office Excel 2019 to provide the answers for you and that is exactly what this course aims to help you do.
Course Objectives
By the end of this course, you will be able to:
- Leverage the power of data analysis and presentation in order to make informed, intelligent organisational decisions
- Work with functions
- Work with lists
- Analyse data
- Visualise data with charts
- Use PivotTables and PivotCharts
Methodology
Pre-Requisite
To ensure success, students should have completed Logical Operations’ Microsoft® Office Excel 2019 (Basic Level) or have the equivalent knowledge and experience
- Training is hands-on using easy-to-follow step-by-step instructions
- Instructor-Led Training (ILT) on live exercises of each topic
Who Should Attend?
This course is designed for students who already have foundational knowledge and skills in Microsoft® Office Excel 2019 and who wish to begin taking advantage of some of the higher-level functionality in Microsoft® Office Excel to analyse and present data.
Training Delivery
- Face to Face Training
or
- Remote Training via Zoom Platform
- Day One
- Day Two
Day One
MODULE 1: WORKING WITH FUNCTIONS
MODULE 2: WORKING WITH LISTS
MODULE 3: ANALYSING DATA
Day Two
MODULE 4: VISUALISING DATA WITH CHARTS
MODULE 5: USING PIVOTTABLES & PIVOTCHARTS
You May Also Be Interested In
Be Updated on the latest HR & Training Best Practices
2
Stay Updated to the Latest HR News & Training Trend
Subscribe to Our Newsletter
By providing your information above, you consent to receive marketing emails from PM Resources Sdn Bhd, which will include the latest news and updates related to our businesses. Our privacy policy contains information how we store and process your data.
