“Elevate your team, Transform your business, Empower excellence”
Your trusted training provider
At Castle HR & Training Solutions, we understand the importance of investing in your team's development. That's why we offer a comprehensive range of training courses designed to elevate your team and equip your staff with the skills they need to excel. From Excel proficiency to customer service and bespoke services our courses are tailored to meet the unique needs of your business.
Our courses
-
For those with limited experience who want to understand and master the basic functions of Excel.
Course Overview:
Overview of Excel
Create a Spreadsheet
Formatting worksheets
Referencing
Formulas
Charting
Databasing
-
Those who are using Excel daily and wish to extend their knowledge, have attended the Introduction Course, or wish to be more proficient at data management. You will be shown hints, tips, and shortcuts to help you use Excel more efficiently.
Course overview
Building Spreadsheets
Working with Multiple Worksheets and Workbooks
Using the IF function
Documenting and Auditing
Pivot Tables
-
Those that already have proficient skills in Excel have attended the Intermediate Course or those wishing to perform more complex tasks. The course looks at automating repetitive processes and performing more complex tasks quickly.
Course Overview:
Referencing
V Lookup
H Lookup
X Lookup
Pivot Tables
Pivot Table Calculations
Pivot Charts
Pivot Table Slicers
Macros
-
Learn how to use Excel's advanced formulas and functions to perform complex calculations, analyse financial data.
Course overview
Sparkline Charts
SUMIFS
What-If Analysis
Conditional Formatting
Linking multiple worksheets with formulas
Creating, editing and running Macros
Count IF
Sum IF
Count IF with Wildcard
Nested IF function
Linking worksheets & Maintating links
Sheet & Cell Protection
Data Validation
Conditional formatting
-
This course is designed for individuals currently in a customer service role or transitioning into one. It is suitable for anyone looking to enhance or refresh their knowledge and skills in this field.
Course overview
Understanding Customer Needs:
Communication Skills Enhancement:
Problem-Solving and Conflict Resolution:
Product and Service Knowledge
Building Customer Relationships
-
For those with limited experience who want to understand and master the basic functions of Google Sheets.
Create a spreadsheet
Formatting Worksheets
Formulas
Charting
Databasing
Referencing
-
We can also design, create and deliver tailored solutions to suit your business requirements. Contact us to earn more about how we can really add value and support your business.
Meet our Trainer
Moira Cherry
Moira brings over 20 years of experience in Training and Development. Specialising in writing and delivering bespoke training courses for one-to-one or group training. Moira has supported global businesses align growth and people development plans as well as supported SMEs with additional training and upskilling across the Yorkshire region.