Our Excel Intermediate Level 2 course is designed for the experienced user of Excel. The delegate will want to examine the more advanced and sophisticated features of Microsoft Excel. This Excel training course aims to develop skills in higher-level, such as data analysis, formula building, formatting, and automation features.
Macro building is covered but Visual Basic for Applications (VBA) is not.
Our Excel Intermediate Level 2 course 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.
Use of:
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
or Enquire Now
The quickest way to learn Excel is to use the Help function in the Excel programme itself. There are also plenty of helpful videos online if you are looking for help with a specific function. You should be able to do some of the basics in a couple of hours.