Courses for Everyone
Our Excel Intermediate Level 2 course is designed for the experienced user of Excel who wants to examine the more advanced and sophisticated features of Microsoft Excel. This Excel training course aims to develop skills in higher-level data analysis, formula building, formatting and automation features.
Macro building is covered but Visual Basic for Applications (VBA) is not.
Our courses are highly practical and interactive. All courses take place in our Exeter training suite, we supply laptops for use during the session. We limit the class size to 8 to ensure our coach has time to deal with any specific queries you may have.
This course will equip you to utilise the advanced functions of Excel and is the highest level of Excel training that we offer as part of our open course training programme – further tuition can be provided, please contact the office for bespoke training details.
During this course, you will be manipulating data from external sources, including the use of Power Query. You’ll also create a pivot table built on more than one set of data. A large number of useful built-in functions will be explained together with; text concatenation, advanced database capabilities, grouping and outline modes. We’ll also take a detailed look at Data Validation and working with formulae in conditional formatting.
N.B. VBA is not covered on this course
Why upskill in Microsoft Excel?
Microsoft Excel, the spreadsheet programme included in the Microsoft Office suite of applications, is commonly used for analysing, sorting, reporting and storing data. Many organisations choose to use Excel because its spreadsheets are simple to use and highly visual.
Upskilling your team with Excel training will provide them with the ability to organise and manage data more efficiently, saving precious time which can be devoted to other projects. Our Excel training courses provide effective tips, techniques and formulas that will help individuals make the best use of Excel in your organisation.
Acquiring in-depth knowledge of working with Microsoft Excel functions and formulas will enable delegates to use Excel efficiently in their daily work life.
We offer Excel training at three levels:
A knowledge of subjects covered on our Excel Intermediate course is ideally required for this programme. The course is designed for those who want to build on their existing Excel skills and learn additional tasks including both formulaic and commands.
Anyone who has successfully completed our Excel Intermediate course who wishes to learn additional capabilities of this powerful application.
Talk to us about building a tailored programme of learning to suit your team's unique development needs.
Call us on
01392 409 198