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 will cover the basic principles of Microsoft Excel. This course is perfect for beginners who want to gain a comprehensive understanding of Excel and learn how to navigate the software with confidence. Throughout the course, you will learn about the different types of data such as text data, numerical data, formulas, and functions. You will learn how to set up spreadsheets and develop your skills to present your work in a clear and professional manner. With our expert guidance, you will learn how to create and develop purchase orders, bank statements, and compile sales figures.
In addition, you will learn how to manipulate data by inserting rows, columns, and sheets. You will also learn how to move, copy and delete data fields. Our practical exercises will give you hands-on experience working with Excel, and by the end of the course, you will have the confidence to apply your skills in a professional setting. Our expert trainers have extensive experience working with Excel and will guide you through the course with engaging lectures and practical exercises. By the end of the day, you will have a solid understanding of the basic principles of Excel, and the skills to navigate the software and complete a range of functions.
Available Course Dates 2024/25 - Excel Beginner
December 2024: Fully Booked
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 an ideal training programme for participants who already have a basic understanding of Excel, and want to further their knowledge and skills in this powerful spreadsheet tool. Our one-day course is designed to provide learners with a comprehensive understanding of the latest features in Excel, and how to use them effectively to streamline their work and improve their productivity. Throughout our one-day course, participants will learn about more complex formulas and functions, including how to use the latest next-generation functions to make calculations faster and more efficient. They will also learn about advanced data analysis techniques, including how to use improved conditional formatting features to make data easier to understand and interpret.
Our one-day course will also cover advanced analysis tools, such as pivot tables, that enable participants to manipulate and summarise data quickly and easily. They will also learn about lookup functions and filtering options, which can be used to extract specific data from large datasets. Overall, the Intermediate Microsoft Excel course in Bridgend is a must for anyone who wants to become proficient in using the latest features of Excel to improve their work processes and efficiency. By the end of the course, learners will have gained the necessary skills and knowledge to become confident and efficient users of this powerful tool.
Available Course Dates 2024/25 - Excel Intermediate
December 2024: Fully Booked
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 a comprehensive training programme designed to provide participants with the necessary skills and knowledge to manipulate and analyse data using advanced Excel functions. Our one-day course aims to equip learners with the proficiency to process large amounts of data in a more efficient and streamlined manner. Throughout our one-day course, participants will gain an in-depth understanding of the advanced features of Excel, including how to normalise data, import data using queries, and prepare and analyse data using 'What If' functions and scenario building. These topics will enable learners to make sense of data and gain insights into its meaning, identifying trends and patterns that can be used to make informed business decisions.
Furthermore, the course will cover the process of recording macros and creating icons on toolbars to run them. This will enable participants to automate repetitive tasks and increase their efficiency in data processing. Finally, learners will gain the ability to use analysis tools to forecast figures based on a range of scenarios. This knowledge will allow them to anticipate potential outcomes and make decisions that can positively impact their business or organisation. Overall, the Advanced Microsoft Excel course in Bridgend is an essential training programme for professionals who want to become proficient in data analysis and processing.
Available Course Dates 2024/25 - Excel Advanced
December 2024: Fully Booked
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.