CODE: ITMS05
DURATION: 3 Days/5 Days
CERTIFICATIONS: CPD
This course builds on the foundational knowledge from Microsoft Office Excel 2021: Part 1, focusing on advanced techniques for analyzing large datasets and extracting actionable insights. You will learn to create sophisticated workbooks and worksheets that improve your ability to analyze data and present findings to decision-makers effectively. The course aims to enhance your skills in organizational intelligence, helping you answer complex questions by leveraging Excel’s powerful data manipulation tools. By the end of the course, you will be better equipped to drive data-driven decision-making and gain a competitive edge in your organization. Additionally, this course aligns with the Microsoft Office Specialist Program exam objectives, preparing you for both the Excel Associate (Office 365 and Office 2021): Exam MO-200 and the Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications.
This course is available in the following formats:
Virtual
Classroom
Request this course in a different delivery format.
Course Outcomes
Upon successful completion of this course, delegates will be able to:
Leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.
At the end of this course, you’ll understand:
This course is designed for delegates who already have foundational knowledge and skills in Excel 2021 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
✓ Modern facilities
✓ Course materials and certificate
✓ Accredited international trainers
✓ Training materials and workbook
✓ Access to online resources
