Microsoft Excel is a key part of many careers and jobs. Any job with high levels of Excel use in Finance, Accounts, Projects and numerous other roles now requires advanced-level skills in Excel. Many employers will test their new employees on Excel skills and will not hire staff who fail to demonstrate Excel skills. Our Advanced Excel Course will enable you to gain the specialist skills in Excel needed to make a difference in so many careers.
Advanced Excel Course
To enable students to gain advanced skills in Excel and to gain CPD Accredited Certification in Advanced Excel to build career profiles.
Course Format
This online course is delivered using a virtual tutor who can instruct you, correct your errors, and give you practical exercises. The training is offered on a live server. This is a state-of-the-art learning system. This standard of interactive learning will enable you to gain more practical confidence to take the skills back to your workplace. This is available to you on a flexible basis, with a flexible start date and the ability to study at any time that suits you.
Course Content
- Pivots Tables
- Pivot Charts
- Advanced Formulas (VLookup, Date Functions and many more)
- IF statements, AND and OR
- Nested, Arrays and Conditions Formulas
- Scenarios, Goal Seek
- Other advanced functions
- Auditing and Error Checking
- Templates and themes
- Protecting workbooks
- Sharing workbooks
Dates and Duration
The course lasts for six months but can be completed earlier. It can be taken online from anywhere.
Course Requirements
You should have intermediate-level skills or, more significantly, be able to take the advanced course. Please order either the Intermediate Course or the Beginner Level Courses, if needed.
Excel Course Benefits
- Microsoft Certified Academy delivers training; this ensures that standards are high and that teaching methods/materials meet this high standard.
- A live server with a Virtual Tutor enables learners to receive instruction and interactive learning.
- The system replicates having a personal tutor.
- CPD Standards Certificate in Advanced Excel is issued on successful completion
- Certification and qualification issued on completion to build your CV and Career Profile
- The training is efficient, with numerous exercises to ensure you remember these details.
Certification
You will be issued a CPD Accredited Certificate in Advanced Excel.
