We are passionate about empowering individuals to expand their knowledge and skills using Excel. Our training programs are designed to equip you with the expertise needed to thrive in today's data-driven world. Through our in-depth courses and workshops, you will develop a clear understanding of Excel’s built-in functions allowing you to work efficiently with your data and produce meaningful reports. Our hands-on approach to learning ensures that you not only grasp theories but also gain practical experience in implementing these new skills efficiently. 
 

Who will benefit from this course
 

This instructor led course is designed for experienced users of Excel.  We recommend that you have attended our building knowledge course or have the equivalent understanding.

Key elements of the course 

• Combine lookup, logical and conditional functions to enhance formulae
• Use database "D" functions to apply multiple criteria to formulae
• Use advanced filters to create tables of data 
• Expand conditional formatting by adding formulas
• Understand text functions to format, combine or split data cells
• Understand date functions to extract date elements
• Manipulate large sets of data using Pivot Tables or Pivot Charts
• Explore forecasting tools such as scenarios, goal seek, data tables and trend lines to charts
• Use simple macros to automate routine tasks 

Course Details

This is a one-day, tutor led, on-line course the dates for which are set out on the Course Schedule. It can also be run as a tailored, company specific course either on-line or at an organisation’s premises.