Full-size Image
Book Now Enquire Venues Brochure

Microsoft Excel Beginner

Course Rating

Course Ratings

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, BBC


"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, Cardiff Council


"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."

Jo, Wales Millennium Centre


"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, Swansea Police

Duration: 1 Day. Price: £195


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 2024 - Excel Beginner


July: Fully Booked

August: 6th, 7th, 13th, 14th, 20th, 21st, 27th, 28th

September: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th

October: 1st, 2nd, 8th, 9th, 15th, 16th, 22nd, 23rd, 29th, 30th

November: 5th, 6th, 12th, 13th, 19th, 20th, 26th, 27th

December: 3rd, 4th, 10th, 11th, 17th, 18th


Course Content - Excel Beginner

  • Creating a New Spreadsheet
  • Entering Data, Formulas & Functions
  • Managing Printing with Different Layouts
  • Exploring the User Interface Elements
  • Introduction to Formulas and Functions
  • Utilising the Excel Galleries
  • Using the Data Analysis Toolkit
  • Customising the Interface to Suit Your Needs
  • Working with Workbooks: Creating, Opening, and Saving
  • Creating Forms in Excel
  • Conditional Formatting for Data Highlighting
  • Making the Most of Excel Help and Resources
  • Recreating Formulas and Functions in Multiple Cells
  • Understanding and Applying Range Names
  • Preparing Data for Printing and Page Layout
  • Transforming Numerical Data into Visual Charts
  • Formatting Charts for Clarity and Visual Appeal


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.

Why Learn with IT Training Wales?


Learn with IT Training Wales for a comprehensive and tailored educational experience that aligns with the ever-evolving landscape of information technology. Our expert instructors bring industry expertise, ensuring that you acquire practical skills and knowledge crucial for success in today's dynamic IT environment. With a commitment to hands-on training, cutting-edge technologies, and personalised guidance, IT Training Wales empowers you to excel in your IT endeavors and stay ahead in the rapidly advancing tech industry.


Book Now Enquire Venues Brochure

Microsoft Excel Intermediate

Course Rating

Course Ratings

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, NHS Wales


"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, 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


"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

Duration: 1 Day. Price: £195


Course Overview - Excel Intermediate


The Intermediate Microsoft Excel course in Swansea 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 in Swansea 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 2024 - Excel Intermediate


July: Fully Booked

August: 6th, 7th, 13th, 14th, 20th, 21st, 27th, 28th

September: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th

October: 1st, 2nd, 8th, 9th, 15th, 16th, 22nd, 23rd, 29th, 30th

November: 5th, 6th, 12th, 13th, 19th, 20th, 26th, 27th

December: 3rd, 4th, 10th, 11th, 17th, 18th


Course Content - Excel Intermediate

  • Absolute Cell References
  • Naming Cells and Ranges
  • Referring to Named Cells and Ranges
  • Editing Named Cells and Ranges
  • Data Types
  • Setting Up Workbooks with Group Editing
  • Using VLOOKUP, HLOOKUP & XLOOKUP Statements
  • Editing Lookups and Ensuring Accuracy
  • Linking Spreadsheets and Workbooks
  • Utilising 'IF' Statements
  • IF Statements and Calculations
  • 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
  • Pivot 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


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.


Book Now Enquire Venues Brochure

Microsoft Excel Advanced

Course Rating

Course Ratings

Out of 15 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, Admiral Insurance


"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, Siemens


"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."

Swansea Building Society

Duration: 1 Day. Price: £195


Course Overview - Excel Advanced


The Advanced Microsoft Excel course in Swansea 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, the Advanced Microsoft Excel course in Swansea is essential for professionals seeking proficiency in data analysis and processing.


Course Dates 2024 - Excel Advanced


July: Fully Booked

August: 6th, 7th, 13th, 14th, 20th, 21st, 27th, 28th

September: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th

October: 1st, 2nd, 8th, 9th, 15th, 16th, 22nd, 23rd, 29th, 30th

November: 5th, 6th, 12th, 13th, 19th, 20th, 26th, 27th

December: 3rd, 4th, 10th, 11th, 17th, 18th


Course Content - Excel Advanced

  • Advanced text functions in Excel
  • Count functions and their applications
  • Exploring new Excel formulas
  • Creating pivot table reports from scratch
  • Data analysis with pivot tables and their manipulation
  • Formatting and customising pivot tables
  • Generating insightful pivot charts for data visualisation
  • Exploring advanced data visualisation techniques
  • Tracking cell precedents and cell dependents for data auditing
  • Utilising Goal Seek for scenario analysis
  • Creating single-input data tables for dynamic analysis
  • Setting up scenarios for What-If analysis
  • Data consolidation techniques based on position
  • Grouping and outlining data with Excel's features
  • Importing and working with text files in Excel
  • Mastering advanced data analysis techniques
  • Visualising trends with Sparklines
  • Transforming data efficiently
  • Converting picture data into usable Excel format
  • Recording macros for automating tasks
  • Creating buttons for running macros with ease
  • Customising access to Excel commands and features
  • Enhancing toolbars with custom icons
  • Creating a personalised tab for quick access to macros
  • Adding custom options to menus for streamlined macro execution


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.

Full-size Image