Microsoft Office Training in Swansea

This instructor-led, live training in Swansea (online or onsite) is aimed at This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimise their presentations.

By the end of this training, participants will be able to:

• Automate the creation of text-based content in PowerPoint slides using DeepSeek.
• Generate data-driven visuals and infographics powered by DeepSeek models.
• Use AI to summarize long reports and turn them into presentation-ready slides.
• Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations.

Excel is a spreadsheet application used for data entry, analysis, reporting, and automation.

This instructor-led, live training (online or onsite) is aimed at beginner-level to advanced-level users who wish to build confidence and proficiency across Excel’s essential, intermediate, and advanced capabilities.

Upon completion of this training, participants will be prepared to:

• Work confidently with spreadsheets, formulas, and formatting.
• Use intermediate tools such as tables, charts, and conditional logic.
• Apply advanced functions, data analysis features, and automation techniques.
• Create professional worksheets that support business decision-making.

Format of the Course

• Instructor-led demonstrations and guided explanations.
• Extensive workbook exercises and hands-on practice.
• Practical lab activities using real-world spreadsheet scenarios.

Course Customisation Options

• For tailored coverage based on your department’s workflows, please contact us to arrange a customised version of this course.

This instructor-led, live training in Swansea (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to master Microsoft Word, Excel, and PowerPoint for enhanced document creation, data analysis, and presentations.

By the end of this training, participants will be able to:

• Effectively create, format, and manage documents in Microsoft Word.
• Utilize Excel for data entry, analysis, and visualization.
• Design engaging and professional presentations in PowerPoint.
• Leverage collaboration features across Microsoft Office applications.

Excel is a widely used spreadsheet application for data organization, analysis, and automation.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Excel users who wish to apply Excel for inventory control, budgeting, reporting, and automation using real-world datasets.

By the end of this training, participants will be able to:

• Use formulas such as SUMIF, IF, VLOOKUP, and SUMIFS for inventory and purchasing scenarios.
• Handle and analyze large datasets of 5,000+ rows efficiently.
• Create and interpret pivot tables for monthly and accumulated tracking.
• Automate repetitive reporting tasks using macros.
• Track material purchases versus consumption with structured templates.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customisation Options

• To request a customised training for this course, please contact us to arrange.

This instructor-led, live training in Swansea (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.

By the end of this training, participants will be able to:

• Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting for data analysis.
• Create and manage pivot tables and charts for data visualization.
• Use tools like Power Query, Power Pivot, and perform data analysis.
• Automate tasks using macros and VBA to streamline workflows.

This instructor-led, live training in Swansea (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Swansea (online or onsite) is aimed at data analysts or anyone who wishes to learn how to use Excel for creating data models for data analysis.

By the end of this training, participants will be able to:

• Learn to analyze and solve any business problems using structured problem-solving tools.
• Navigate Excel tools with ease.
• Set up, format, and present data effectively.
• Understand the logical structure and apply correct functions to Excel models.

Microsoft Word is a powerful word-processing application used to create, format, and manage professional documents.

This instructor-led, live training (online or onsite) is aimed at beginner-level to advanced-level users who wish to develop comprehensive skills in creating, editing, formatting, and automating documents in Microsoft Word.

Upon completion of this course, participants will be equipped to:

• Create professional documents with consistent formatting.
• Use intermediate features such as styles, templates, and collaboration tools.
• Apply advanced tools including mail merge, references, and automation.
• Enhance productivity by leveraging Word’s advanced layout and document management capabilities.

Format of the Course

• Engaging demonstrations and guided instruction.
• Extensive practical exercises and skill-building tasks.
• Real-time document creation and refinement in a live environment.

Course Customisation Options

• If you require a tailored version of this training, please contact us to discuss customisation options.

The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.

Excel is a popular spreadsheet program created by Microsoft. Jest used to store, organize and analyze data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array consisting of cells arranged in rows and columns. It allows you to create multiple sheets in one file, which allows you to organize different data sets. 2. Calculations and Formulas: Allows you to perform a variety of mathematical, statistical and logical calculations using formulas. It has a wide set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: Provides tools for formatting data, including changing font, color, style, and creating charts, pivot tables and diagrams. 4. Sorting, Filtering and Grouping: Allows you to sort data according to specific criteria. Allows you to filter data to display only selected information. Possibility to group data depending on needs. 5. Data analysis: Tools for performing advanced analyzes such as scenario analysis, trends, forecasting, and creating macros. 6. Data Sharing: Enables real-time data sharing and collaboration, allowing multiple users to work on the same data simultaneously. 7. Task automation: Ability to create macros and automate tasks using the programming language VBA (Visual Basic for Applications). Excel is widely used in various fields, from business to science and education. Its comprehensive features enable data analysis, creation of reports, budgets, schedules, data management and many other applications.

This instructor-led, live training in Swansea (online or onsite) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Write an advanced object-oriented application
• Convert text files
• Use of external data sources
• Use external libraries

This instructor-led, live training in Swansea (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

This instructor-led, live training in Swansea (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.

By the end of this training, participants will be able to:

• Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
• Use DAX formulas in Power BI for complex calculations.
• Create and use visualizations and charts for particular analysis cases.
• Import with Power View to move from Excel based Power BI to independent Power BI.

Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions: 

What has happened?

• processing and analyzing data
• producing informative data visualizations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimizing processes

Automate workflows and build robust desktop applications with VBA across Microsoft Excel and Access. This comprehensive VBA training covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data.

This instructor-led, live training (online or onsite) is aimed at beginner-level data analysts who wish to use Excel for data analysis and reporting.

By the end of this training, participants will be able to:

• Create and manage spreadsheets in Excel.
• Format and organize data for clarity and efficiency.
• Use formulas and functions to automate calculations.
• Visualize data using charts, tables, and conditional formatting.
• Collaborate and share workbooks securely in Microsoft 365.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customisation Options

• To request a customised training for this course, please contact us to arrange.

Excel training for financial analysis covers the advanced spreadsheet techniques that finance professionals need — from lookup functions, search formulas, and Pivot Charts through conditional formatting, external data workflows, and Securities analysis. Dives into practical approaches to evaluating time value of money concepts, identifying market trends, building financial forecasting models, and leveraging Excel's complete analytical toolkit for complex financial computations and reporting.

 Analysing Financial Data in Excel equips financial analysts and accountants with advanced techniques for automating complex calculations and reports. Covers core principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and external data integration. Dives into Goal Seek, Solver, Analysis ToolPak, and VBA macros for automating recurring workflows. Helps professionals transform raw figures into actionable financial insights and accurate forecasts for strategic planning.

The course participants will be able to efficiently perform a variety of calculations in a transparent way to arrange and present their results, use multiple mechanisms to facilitate and accelerate the creation of spreadsheets, as well as protect the calculations and their results against unauthorized persons

Participants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.

Course participants will learn how to create a clean, professional-looking documents (including official correspondence of all kinds - official and official), as well as make full use of the basic mechanisms enabling the transparent flow of information in both the shorter and longer documents.

Master advanced document workflows with Microsoft Word's full feature set. Master custom styles, mail merge from external databases, macro recording, and template creation. Participants learn section-level layout control, dynamic tables of contents, indexes, hyperlinks, content controls, document comparison, and version tracking. Equips professionals to build automated reporting systems, standardized enterprise templates, cross-referenced documents, and SharePoint-integrated workflows.

Advance your VBA skills to the intermediate level with coverage of custom interfaces, complex data types, conditional logic, looping constructs, and professional debugging techniques. This hands-on Excel VBA training teaches robust error handling, performance optimization, VBA UserForms, and workflow automation through real-world exercises — bridging the gap from basic macros to advanced automation solutions for data analysts, reporting professionals, and business users seeking enterprise spreadsheet capabilities.

Master Microsoft Excel with this professional training course designed to enhance your spreadsheet efficiency and productivity. Learn essential skills including editing worksheets, managing workbooks, building complex formulas with powerful functions, formatting cells, creating professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. Ideal for business analysts, accountants, data handlers, and office professionals seeking to advance their Excel proficiency from intermediate to expert level. Boost your data analysis capabilities, streamline reporting workflows, and unlock the full power of Microsoft Excel for better decision-making and workplace productivity.

This instructor-led, live training in Swansea (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

 Mastering PowerPoint beyond the basics reveals how to build polished, scalable presentations that command attention. Dives into slide and handout master customisation, template creation, SmartArt for visual process mapping, and deep Excel integration for live-linked data dashboards and charts. Equips professionals with power-user workflows across add-ins like Office Timeline and Poll Everywhere to accelerate complex deck production, streamline review cycles, and deliver impactful business presentations.

PowerPoint professionals seeking polished presentations can benefit from advanced slide design techniques that transform basic content into visual stories. This course dives into core principles of slide composition, chart and infographic creation, and image editing, while building practical skills in visually distributing elements, emphasizing key information, and personalizing the working environment. Professionals walk away with actionable strategies for crafting clean, compelling slides and delivering confident presentations with structured public speaking techniques.

Objective:

Improving the ability to prepare an attractive presentation using PowerPoint and other tools

Addressees:

Sales representatives, consultants, research and teaching staff, managers, teachers, corporate employees, SMEs and public institutions, for which the challenge is to stand in front of a group of people, say to them, arousing interest

This instructor-led, live training in Swansea (online or onsite) is aimed at beginner-level to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks.

By the end of this training, participants will be able to:

• Use Excel formulas and functions to perform calculations and data manipulation.
• Use Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
• Use Excel charts and graphs to create and customize data visualizations.
• Use Excel data validation and conditional formatting to ensure data quality and highlight data insights.
• Use Excel data import and export features to connect to external data sources and share data with others.

This 1 day training session is designed for people who use SharePoint as power users who perform as SharePoint site owner and/or Site Collection administrators

Course objectives:

• Configure site navigation
• View site activity reports
• Customize lists and libraries
• Work with Site Columns and Site Content Types
• Configure Check out/in, Content Approval and Versioning
• Create and modify pages and web part pages

This 1 day training session is designed for people who use SharePoint as users and want to understand some of the advanced features of the tool. Delegates should attend this course if they need to understand functions such as; team collaboration, document management and social features of Microsoft SharePoint 2013

This course is designed for

• SharePoint Site Owners and users

Course objectives:

• Manage Sites and Site Collections
• Add users and groups and manage site, list, folder and item security
• Add and configure web parts
• Configure site options including theme, title, description and icon

Creating compelling financial slide decks bridges the gap between complex numbers and executive-level communication through PowerPoint. Explores design strategies spanning slide structuring, treemap and sunburst visualizations, budget chart layouts, and simplified reporting tables that highlight key financial metrics. Guides participants to master Excel integration for dynamic data, selective number emphasis, and confident financial storytelling that earns stakeholder buy-in.