Excel Intermediate Level 1 course

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

A proficiency in basic Excel use is assumed. This course is designed for those who want to build on their existing Excel skills. 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.