Course Rating
Out of 187 verified reviews
Recent Feedback
"Attended the Excel Beginner session and it was a great day, I learned many things that I will be able to use to save time in work."
Loraine - BBC
"Well, last week I completed an Excel course with Computer Training Wales. It was a very practical training session with lots of hands-on learning. Enjoyable and the class size was small (two delegates) to one trainer."
Paul - Cardiff Council
"Attended Excel Introduction and it was an excellent course. There was only two people to Daniel the trainer. Overall, this was a great introduction course and I hope to come back for Excel Intermediate in the future."
Jo - Wales Millennium Centre
"The Microsoft Excel course has been great to attend, our training needs have been met time and time again and as an organisation we feel confident on how to perform our jobs. We can craft excellent spreadsheets and forms."
Joanne - South Wales Police
Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ
Course Overview - Excel Beginner
Join us for our one-day course in Bridgend, where we'll introduce you to the fundamental principles of Microsoft Excel. Perfect for beginners, this course will help you gain a solid understanding of Excel and navigate the software with ease. Throughout the day, you'll learn about working with different types of data, including text, numbers, formulas, and functions. You'll discover how to set up spreadsheets and present your work in a clear, professional format.
You'll also learn how to efficiently manipulate data, including inserting rows, columns, and sheets, as well as moving, copying, and deleting data fields. Our practical, hands-on exercises will give you valuable experience working with Excel, allowing you to confidently apply your skills in a professional setting. Led by trainers with extensive expertise, this course combines engaging instruction with interactive practice to ensure you finish the day with a strong understanding of Excel's core principles and a readiness to tackle a variety of tasks.
Available Course Dates 2025 - Excel Beginner
January 2025: 6th, 20th, 21st, 27th, 28th
February 2025: 3rd, 4th, 10th, 17th, 18th, 24th, 25th
March 2025: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th, 31st
April 2025: 1st, 7th, 8th, 14th, 15th, 22nd, 28th, 29th
May 2025: 6th, 12th, 13th, 19th, 20th, 27th
June 2025: 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th
Course Content - Excel Beginner
- Set up a spreadsheets from new
- Enter data, formulas & functions
- Explore the user interface elements
- Getting going with formulas/functions
- Data Analysis toolkit
- Creating, opening & saving a workbook
- Conditional formatting
- Utilising Excel help
- Replicate formulas & functions
- Range names and how they are applied
- Turning your figures into charts
- Formatting charts
- Autopilot in Excel
- ChatGPT in Excel
Who is this course for?
This course is designed for individuals at the beginner level who are eager to grasp the fundamentals of Microsoft Excel or those who have some self-taught knowledge but seek to enhance their proficiency. It caters to individuals from various backgrounds, including students, professionals, and anyone interested in improving their digital skills.
Whether you're stepping into the world of spreadsheet software for the first time or looking to refine your existing knowledge, this course provides a solid foundation. By the end of the session, you will be equipped with the essential skills to navigate Excel confidently and efficiently tackle day-to-day tasks, making it ideal for anyone keen on boosting their productivity and effectiveness in handling data and calculations.
Course Rating
Out of 135 verified reviews
Recent Feedback
"I can't recommend the Excel session highly enough, the pace was great and I can't believe all of the things learned in one-day. Starting with basic formulae we quickly move on to charts, macros and complex statements. What a well put together session."
Julie - NHS Wales
"We sent three members of staff onto a Microsoft Excel Intermediate session on Thursday and the feedback has been brilliant. Computer Training Wales sessions have up-skilled our staff and the standard was excellent."
Jean - Bridgend County Borough Council
"The trainer was great to get on with and I learned a lot within the space of one-day. I hope to come back for Excel advanced probably at the end of this year. Highly recommended and this was a great session."
Steve - Welsh Local Government Association
"Really enjoyed the course, showed me how enormous excel is. Learned some really helpful tools which will make my life a lot easier."
Billy, Administrative Assistant
"Such a great way to learn Microsoft Excel. My company in Cardiff needed me to learn Excel skills, but I hadn't used it since school. Well, I am now a confident user and can handle whatever is asked of me."
Helen - HSBC
Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ
Course Overview - Excel Intermediate
Our Intermediate Microsoft Excel course is perfect for participants with a basic understanding of Excel who are eager to expand their knowledge and skills in this powerful spreadsheet tool. This one-day programme offers a comprehensive exploration of Excel's latest features, teaching you how to use them effectively to streamline tasks and boost productivity. During the course, you'll dive into more advanced formulas and functions, including next-generation tools designed to make calculations faster and more efficient. You'll also learn advanced data analysis techniques, such as leveraging enhanced conditional formatting to make complex data easier to understand and interpret.
The course also covers powerful analysis tools like pivot tables, enabling participants to quickly manipulate and summarise data. You'll gain expertise in using lookup functions and filtering options to extract precise information from large datasets. The Intermediate Microsoft Excel course in Bridgend is an essential step for anyone looking to master Excel's advanced features and improve their workflow efficiency. By the end of the day, you'll have the skills and confidence to use Excel proficiently and effectively tackle a range of professional tasks.
Available Course Dates 2025 - Excel Intermediate
January 2025: 6th, 20th, 21st, 27th, 28th
February 2025: 3rd, 4th, 10th, 17th, 18th, 24th, 25th
March 2025: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th, 31st
April 2025: 1st, 7th, 8th, 14th, 15th, 22nd, 28th, 29th
May 2025: 6th, 12th, 13th, 19th, 20th, 27th
June 2025: 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th
Course Content - Excel Intermediate
- Absolute cell references
- Naming cells and ranges
- Referring to named cells and ranges
- Editing named cells and ranges
- Datatypes
- Setting up workbooks with group editing
- Using VLOOKUP, HLOOKUP & XLOOKUP statements
- Editing lookups and ensuring accuracy
- Linking spreadsheets and workbooks
- Analysing data with conditional formatting
- Databases in Excel
- Sorting data numerically and alphabetically
- Filtering data for range & precision analysis
- Setting up data validation
- Pivot tables and charts
- Attaching security to a spreadsheet
- Selective protection
- Setting up and utilising templates
- Creating and formatting charts
- Adding trend lines to the chart
- Utilising custom chart types
- Autopilot in Excel
- ChatGPT in Excel
Who is this course for?
This Intermediate Microsoft Excel course is for individuals who are already proficient in the basic features of Microsoft Excel. If you're comfortable navigating Excel and have a basic understanding of its functionalities, this course will help you elevate your skills to the next level.
Whether you've attended a beginner's course or have acquired Excel skills through practical experience, this intermediate-level course will deepen your understanding and proficiency in using Excel for data analysis, reporting, and more complex tasks. It's perfect for those looking to expand their knowledge and maximise their productivity with Excel.
Course Rating
Out of 116 verified reviews
Recent Feedback
"Had a great session on Saturday mornings Microsoft Excel. It was both interactive and enjoyable. I would highly recommend Computer Training Wales to anyone looking to improve their Office skills."
Michael - Admiral Insurance
"Computer Training Wales provided an excellent service and delivered a great inhouse course for my team of administrators. Excellent day rates and I can't recommend them highly enough to anyone in the South Wales region."
Andy - Siemens
"Our team needed to learn data analysis skills and the course was excellent at teaching this. We all feel much more confident with using Microsoft Excel for the range of analytical skills that will be required of us."
Mary - Swansea Building Society
Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ
Course Overview - Excel Advanced
The Advanced Microsoft Excel course in Bridgend is an in-depth training programme designed to equip participants with the skills and expertise to analyse and manipulate data using advanced Excel functions. This one-day course is tailored to help learners efficiently process large datasets with streamlined techniques. During the session, participants will explore advanced features such as data normalisation, importing data through queries, and using 'What If' functions for scenario building. These tools will empower learners to interpret data, uncover trends, and make informed business decisions based on actionable insights.
In addition, the course will introduce participants to recording macros and creating custom toolbar icons, enabling them to automate repetitive tasks and boost productivity. Learners will also gain proficiency in using advanced analysis tools to forecast figures across various scenarios, providing the ability to predict potential outcomes and make impactful decisions. The Advanced Microsoft Excel course in Bridgend is an invaluable programme for professionals looking to master data processing and analysis, paving the way for improved efficiency and smarter decision-making in their organisations.
Available Course Dates 2025 - Excel Advanced
January 2025: 6th, 20th, 21st, 27th, 28th
February 2025: 3rd, 4th, 10th, 17th, 18th, 24th, 25th
March 2025: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th, 31st
April 2025: 1st, 7th, 8th, 14th, 15th, 22nd, 28th, 29th
May 2025: 6th, 12th, 13th, 19th, 20th, 27th
June 2025: 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th
Course Content - Excel Advanced
- Text functions in Excel
- Count functions
- New Excel formulas
- Create a pivot table reports from new
- Analysing data with pivot tables
- Manipulating pivot tables
- Formatting pivot tables
- Creating pivot charts
- Using power pivot
- Trace cell precedents & cell dependents
- Autopilot in Excel
- Goal seek
- Creating single input data tables
- Setting up scenarios for What-If?
- Consolidating data by position
- Group and outline features
- Importing text files
- Advanced data analysis techniques
- Sparklines
- Transforming data
- Transforming data from picture
- ChatGPT in Excel
Who is this course for?
This course is aimed at learners who have a good grounding in Excel either from experience or attending our Intermediate Microsoft Excel training course. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Microsoft Excel and would like to fill in gaps in your knowledge.
Microsoft Excel Artificial Intelligence Course
Course Rating
Out of 46 verified reviews
Recent Feedback
"A thought-provoking and enriching experience that has sparked my interest in AI."
Greg, Personal Assistant
"This course has opened my eyes to the immense possibilities of AI, and I'm eager to delve deeper into this field."
Michelle, HR Assistant
Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ
Course Overview - Excel Artificial Intelligence
Embark on a transformative journey and unlock the immense potential of cutting-edge Artificial Intelligence (AI) tools in Microsoft Excel for Data Analysis. In this comprehensive course, you will delve into the revolutionary AI Analyse Data tools and explore the data Insight tools within Microsoft Office, revolutionising the way advanced data analysis is performed.
The course goes beyond traditional data analysis methods, empowering you with advanced techniques that can be applied to unravel even the most intricate and challenging data sets. Whether you're working with healthcare data, business analytical data, operational data, or sales data, you will discover how AI tools can enhance your analysis and provide actionable insights.
Gone are the days of tedious and time-consuming data analysis. With the aid of AI technology, you will experience the joy of seamlessly navigating through complex data, extracting meaningful patterns, and gaining valuable insights with remarkable ease. By harnessing the power of AI, you will be equipped to make informed decisions swiftly, propelling your organisation forward.
Course Content - Excel Artificial Intelligence
- Analyse Data Tools in Excel
- Cloud AI analysis with Microsoft Cloud Platform
- Analyse Data Command
- Advanced Data Analysis
- Advanced Chart Analysis
- Talking to Your Data with Microsoft Insights
- Artificial Intelligence Tools in Office
Who is this course for?
This course is designed for professionals and data analysts who want to leverage cutting-edge AI tools in Microsoft Excel for data analysis. It is suitable for individuals who have a basic understanding of Excel and are looking to enhance their skills by incorporating advanced AI techniques into their data analysis workflows. Whether you work in healthcare, business analytics, operations, sales, or any other field that requires data analysis, this course will provide you with the knowledge and techniques to extract valuable insights from complex data sets using AI tools.