NEW IT Courses - September Newsletter 2025

• You will learn the process of building a professional looking "Front End" for your Excel workbooks & worksheets.
• Main Topics:
  • Formula & Functions Overview
  • Table Management
  • Charts & Graphs
  • Hyperlinks
  • Pivot Tables
  • Shapes & Control Buttons
  • Introduction to Macros
  • Protection
• 1 Day Course

• You'll cover the basics of recording, running, and editing macros,a s well as introducing the VBA language suitable for both beginners and those with some Excel experience.
• Main Topics:
  • Overview
  • Essentials
  • Recording
  • Editing a Macro
  • Visual Basic Editor (VBE)
  • Customise a Macro
  • Course Excercises
  • Playback
• 1 Day Course

• Excel Power Query is a data connection and data transformation application that enables users to import and reshape data from various sources, including Excel workbooks, databases, and online services, into a format suitable for analysis and reporting.
• Main topics:
  • What is Power Query?
  • Using the Power Query editor
  • Data Transformation Tools
  • Advanced Data Transformations
  • Analysing Data
  • Project - Create an Excel Dashboard
• 1 Day Course

Power Bi

• Power Bi is a business intelligence tool that enables users to visualise and analyse data from various sources, turning it into interactive dashboards and reports.
• 1 Day Course

Microsoft Word

• Word Foundation - Introduction to the skills required to create a simpe professional looking short documents. (1 Day Course)
• Word Intermediate - This course focuses on creating professional looking short documents. (1 Day Course)
• Word Advanced - This course is for proficient users of Word, who typically use it everyday. (1 Day Course)
• Designing Forms & Mail Merging - This course provides key users with the skills to create sophisticated form templates. (1 Day Course)

Microsoft PowerPoint

• PowerPoint Foundation - This course will provide all the skills necessary to generate a professional looking PowerPoint presentation from scratch. (1 Day Course)
• PowerPoint Advanced - This course reveals all the extra features of the PowerPoint program. (1 Day Course)

Microsoft Access

• Access Foundation - Introduction to the fundamental skills required to build and use a simple Access database. (1 Day Course)
• Access Intermediate - It covers both the theory and practicalities of table design. (1 Day Course)
• Access Working with Queries - This course will explain the theory and practical elements of select, multi-table and action queries. (1 Day Course)
• Access VBA Programming - This course focuses on the practical design and development issues relating to the production of bespoke systems. (2 Day Course)