Microsoft Excel Pro is a comprehensive training course that prepares you to master advanced Excel® skills and take the Microsoft Excel Pro competency assessment. With hands-on simulations and real-world scenarios, you’ll learn to create and manage spreadsheets, analyze data, and automate tasks in Microsoft Excel®, equipping you for roles in business, finance, and administration, as well as the Microsoft Office Specialist (MOS) Excel associate-level certifications.
Skills Learned
- Data management: Build and manage spreadsheets for organizing and analyzing data.
- Data analysis: Use formulas, functions, and pivot tables to analyze and summarize data.
- Visualization: Create charts and graphs to present data effectively.
- Automation: Automate tasks with macros and advanced formulas.
Competency Assessment Details
- Included with the course: Microsoft Excel Pro competency assessment is integrated into the course
- Launch date: December 19, 2023
- Assessment format: Performance-based tasks that simulate real-world scenarios
- Question count: Up to 5 scenario questions
- Task count: Up to 25 tasks in the assessment
- Time limit: 50 minutes
- Score range: 200 – 2000
- Passing score: 1424
- Recommended experience: No prior experience is required; this course is designed for you, whether you are a beginner or an intermediate learner
Schedule Dates
Course Content
- Import data into workbooks from external sources.
- Navigate, format, and customize worksheets and workbooks.
- Manage workbook options, properties, and versions.
FAQs
Microsoft Excel Pro is a training course designed to help you master Microsoft Excel® skills and prepare for the Pro Certified Competency Assessment. It also prepares you for the Microsoft Office Specialist (MOS) Excel Associate and Expert level certifications.
Flexible Training Options to Meet Your Needs
We know the importance of flexibility in the success of learning and professional development. This is the reason CounselTrain provides a variety of delivery options for all IT training offered in the UAE to ensure access and convenience for each learner.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.
