Excel Intermediate Level 1 course
Our Excel Intermediate Level 1 course is ideal for those who have a basic understanding of Microsoft Excel. If you find yourself using existing spreadsheets which have been created by someone else, this course can help you understand the functions that have been used. This Excel Intermediate Level 1 training course will develop your knowledge of Excel and teach you how to use more complicated functions. This will be useful if you spend much of your day using Excel. The shortcuts and key functions that will be taught during this course will enhance your experience with using Excel. Making long applications easier and quicker to master.
Our courses are highly practical and interactive giving you hands on training with Excel itself. Our in-person courses take place in our Exeter training suite, where we supply laptops that you will use during the session. We limit the class size to 8 delegates. This ensures that our coach has time to listen and deal with any specific queries you may have about Excel.
This course is designed for those who want to build on their existing Excel skills and it will also help develop your knowledge to be able to undertake more complex tasks. A proficiency in basic Excel use is assumed.
Please note, we offer Excel training at two other levels, Excel for Beginners and, the follow-up to this course, Excel Intermediate Level 2. Click the links below to find out more:
During this course you will learn;
- quick methods of navigating and selecting ranges in a worksheet, together with many other shortcuts which will save you a huge amount of time.
- naming ranges and using these in formulae together with a better understanding of building and using more complex built-in functions.
- working with Tables, Pivot Tables and Conditional Formatting.
Course Content
- Customizing Quick Access Toolbar
- Autofill – Fill By Example
- Flash Fill
- Working with Dates and Date Functions
- Statistical functions, Rounding
- Logical functions; IF, SUMIF, COUNTIF, IFERROR
- Range Names
- Linking to Word & External Workbooks
- Short Cuts
- Pivot Tables
- Database Functions, Multiple Sorts & Filters
- Working with Absolutes & Relative Cell References
- Conditional Formats
- Charting
- Using Lookup Function
- Working with Tables
- Formatting and Display techniques
- Viewing Techniques
- Sorting using Cell Colour
Why upskill in Microsoft Excel?
Microsoft Excel, the spreadsheet programme included in the Microsoft Office suite of applications, is used for analysing, sorting, reporting and storing data. Often, 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, allowing them to save precious time which can then 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.
Here at Crisp Professional Development, we offer Excel training at three levels:
- Excel for Beginners
- Excel Intermediate Level 1
- Excel Intermediate Level 2
This course is ideal for people who have been using Excel but wish to gain a better understanding of the capabilities of this powerful application.
Anyone who has successfully completed our Excel course for Beginners and feels ready to progress their skills will enjoy this course.
Related Courses
Delivery Options
In-Person Open Courses
Crisp Professional Development
Crisp Professional Development, Pynes Hill Business Centre,Exeter, Devon EX2 5JL
Select Ticket Quantity
Crisp Professional Development
Crisp Professional Development, Pynes Hill Business Centre,Exeter, Devon EX2 5JL
Select Ticket Quantity
Related Courses
Build your own bespoke training programme
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.