Course Rating
Out of 122 verified reviews
Recent Feedback
"Attended the Excel Beginner session and it was a fantastic experience. I acquired valuable insights that will undoubtedly boost my productivity at work."
Loraine, HR Assistant
"Last week, I completed an Excel course with IT Training Wales. It was a highly practical training session with abundant hands-on learning. I thoroughly enjoyed it, and the small class size (two delegates to one trainer) was ideal."
Paul, Recruitment Specialist
"I attended the Excel Introduction course, and it was outstanding. With only two participants, Daniel, the trainer, provided excellent guidance. Overall, it was an exceptional introductory course, and I look forward to returning for the Excel Intermediate level in the future."
Ahmed, Training Manager
"The Microsoft Excel course has been a valuable experience for our organisation. It consistently addresses our training needs, and we now feel confident in performing our roles. Thanks to this course, we can create excellent spreadsheets and forms."
Joanne, Team Leader
Course Overview - Excel Beginner
Join us for our one-day Excel course in Swansea, where we will explore the fundamental principles of Microsoft Excel. This course is tailored for beginners looking to establish a strong foundation in Excel and develop the skills to navigate the software with confidence. Throughout the course, you will gain knowledge about various data types, including text, numbers, formulas, and functions. You will learn how to create spreadsheets and enhance your abilities to present your work in a professional and clear manner.
Moreover, you will discover how to manipulate data by adding rows, columns, and sheets. You will become proficient at moving, copying, and deleting data fields. Our hands-on exercises will provide you with practical experience in working with Excel. By the end of the course, you will be well-prepared to apply your skills in a professional setting. Our expert instructors, with their extensive experience in Excel, will deliver engaging lectures and guide you through the course with practical exercises. As the day concludes, you will have a strong grasp of Excel's fundamental principles and the ability to navigate the software while performing a variety of functions.
Course Dates 2025 - Excel Beginner
January: 6th, 20th, 21st, 27th, 28th
February: 3rd, 4th, 10th, 17th, 18th, 24th, 25th
March: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th, 31st
April: 1st, 7th, 8th, 14th, 15th, 22nd, 28th, 29th
May: 6th, 12th, 13th, 19th, 20th, 27th
June: 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th
Course Content - Excel Beginner
Who is this course for?
This course is designed for individuals who are new to Microsoft Excel and need to grasp the basics, as well as for those who have some self-taught knowledge but wish to enhance their Excel skills for daily tasks.
Course Rating
Out of 84 verified reviews
Recent Feedback
"I can't recommend the Excel session highly enough, the pace was great, and I can't believe all the things learned in one day. Starting with basic formulae, we quickly moved on to charts, macros, and complex statements. What a well-put-together session."
Julie, Logistics Coordinator
"We sent three members of staff to a Microsoft Excel Intermediate session on Thursday, and the feedback has been brilliant. IT Training Wales sessions have up-skilled our staff, and the standard was excellent."
Jean, Inventory Specialist
"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, Technical Support
"Really enjoyed the course, showed me how enormous Excel is. Learned some really helpful tools which will make my life a lot easier."
Billy, Procurement Officer
"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, HR Assistant
Course Overview - Excel Intermediate
The Intermediate Microsoft Excel course is the ideal programme for participants who have completed our Beginners to Excel course and wish to further expand their knowledge and skills in this powerful spreadsheet tool. This course aims to provide learners with a comprehensive understanding of the latest Excel features and how to effectively utilise them to streamline their work and enhance productivity. Over the duration of this one-day course, participants will explore more advanced formulas and functions, including the latest next-generation functions to expedite calculations and improve efficiency. They will also delve into advanced data analysis techniques, including the utilisation of enhanced conditional formatting features for better data comprehension and interpretation.
The course will also encompass advanced analysis tools, such as pivot tables, allowing participants to manipulate and summarise data quickly and efficiently. Additionally, they will learn about lookup functions and filtering options, which are invaluable for extracting specific data from large datasets. In summary, the Intermediate Microsoft Excel course is a crucial step for those seeking proficiency in harnessing the latest Excel features to enhance their work processes and efficiency. Upon completing the course, learners will have acquired the skills and knowledge to become confident and adept users of this robust tool.
Course Dates 2025 - Excel Intermediate
January: 6th, 20th, 21st, 27th, 28th
February: 3rd, 4th, 10th, 17th, 18th, 24th, 25th
March: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th, 31st
April: 1st, 7th, 8th, 14th, 15th, 22nd, 28th, 29th
May: 6th, 12th, 13th, 19th, 20th, 27th
June: 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th
Course Content - Excel Intermediate
Who is this course for?
This Intermediate Microsoft Excel course is intended for individuals who have completed the beginners' level course or are already proficient in the basic features of Microsoft Excel.
Course Rating
Out of 45 verified reviews
Recent Feedback
"Attended the Saturday morning Microsoft Excel session, and it was both interactive and enjoyable. I highly recommend IT Training Wales to anyone looking to enhance their Office skills."
Michael, Database Administrator
"IT Training Wales provided an outstanding service and conducted a fantastic in-house course for my team of administrators. Their day rates are excellent, and I can't recommend them highly enough to anyone in the Swansea region."
Andy, Virtual Assistant
"Our team needed to acquire data analysis skills, and the course was excellent in teaching us just that. We all feel much more confident using Microsoft Excel for the variety of analytical tasks required of us."
Milly, Technical Support
Course Overview - Excel Advanced
The Advanced Microsoft Excel course is a comprehensive training programme designed to provide participants with the skills and knowledge necessary to manipulate and analyse data using advanced Excel functions. This one-day course aims to equip learners with the proficiency to process large amounts of data more efficiently and effectively.
Throughout the course, participants will gain an in-depth understanding of advanced Excel features. This includes normalising data, importing data using queries, and preparing and analysing data with 'What If' functions and scenario building. These topics enable learners to make sense of data, identify trends and patterns, and make informed business decisions.
The course also covers recording macros and creating icons on toolbars for automation of repetitive tasks. This enhances efficiency in data processing. Participants will also learn to use analysis tools to forecast figures based on various scenarios, enabling them to anticipate potential outcomes and make impactful decisions for their business or organisation.
In summary, this Advanced Microsoft Excel course is essential for professionals seeking proficiency in data analysis and processing.
Course Dates 2025 - Excel Advanced
January: 6th, 20th, 21st, 27th, 28th
February: 3rd, 4th, 10th, 17th, 18th, 24th, 25th
March: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th, 31st
April: 1st, 7th, 8th, 14th, 15th, 22nd, 28th, 29th
May: 6th, 12th, 13th, 19th, 20th, 27th
June: 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th
Course Content - Excel Advanced
Who is this course for?
This course is tailored for participants who already possess a solid foundation in Excel, either through practical experience or by completing our Intermediate Microsoft Excel training. If your work involves extensive data manipulation and analysis within Excel, this course will be of great benefit to you. It is also well-suited for individuals who rely on Microsoft Excel for the majority of their daily tasks and wish to bridge any knowledge gaps in their proficiency.
