Description
If you have a basic understanding of Excel and wish to further your skills to become a proficient user of the software, then the Excel Expert course is ideal for you! The course covers advanced features of Excel that can be used to analyze and manipulate large sets of data efficiently.
Some of the course content covers:
- Prepare Workbooks for Collaboration; Use and Configure Language Options
- Advanced Conditional Formatting
- Look Up Data Using Functions, Advanced Date and Time Functions, and Perform Data Analysis
- Perform Logical Operations in Formulas
- Create and Modify Advances Charts, PivotTables, and PivotCharts
The Excel expert course aims to equip learners with the skills and knowledge needed to become proficient users of Excel and to help them work more efficiently and effectively with data.
|
Duration: |
1/2 Days (Training) + 1 Day (Certify Exam) |
|
Certify: |
1 x Stellietech Certificate of completion 1 x Official exam (Optional) |
|
Versions: |
2016 or 2019/365 |
|
Time: |
Monday - Friday | 09:00 to 16:00 |
|
Booking: |
As soon you purchase the course, your facilitator will contact you to book you in for training days that best suit you. |
|
Official Exam: |
Internationally Accredited Microsoft Office Specialist (MOS) |
|
Exam Prep: |
Assessment, simulations and videos. |
- Manage Workbook Options and Settings
- Manage and Format Data
- Create Advanced Formulas and Macros
- Manage Advanced Charts and Tables
• Video-based Instructions
• Exercise labs
• Pre and Post assessments
• PDF workbook (includes fill-in-the-blanks, glossary terms & definitions, and many other resources to reinforce learning)
• Full-time training support when needed.
• Management/HR reporting (For organisations)
How does it work?
• Financial Analyst: Financial analysts use Excel to analyze financial data and make recommendations based on their analysis.
• Data Analyst: Data analysts use Excel to analyze large amounts of data and present their findings in a clear and concise manner.
• Project Manager: Project managers use Excel to track project progress, create schedules, and manage resources.
• Accountant: Accountants use Excel to manage financial data, create budgets, and prepare financial statements.
• Business Intelligence Analyst: Business intelligence analysts use Excel to analyze data from multiple sources and create dashboards that help their companies make informed decisions.
Why Get Certified
In a world where competition for jobs, pay increases, and academic success continues to increase, certifications enhance your skills and knowledge. Many employers view certification as a demonstration of your commitment to your profession and your willingness to go above and beyond to enhance your skills. This can lead to increased job opportunities and promotions. The Microsoft exams have been mapped to one set of revised objective domains to reflect the skills required in today’s modern workplace.
Upon successfully completing the exam
You will receive the internationally accredited certificate which will get sent to you directly from the certifying body in the USA. StellieTech will email you your E-Certificate in the meantime.
