IT Training and Consultancy

Course Listing

MaximITy has a dedicated Centre of Excellence training room where we offer hands-on coaching to help organisations learn how to use their business software better. We provide everything from introductory level to advanced courses in products such as Excel, Word, Outlook, PowerPoint, Project, Visio, Sage and ACT. We have small class sizes with individual focus. A Training Needs Analysis is undertaken prior to each course.

MaximITy runs both standard scheduled courses as well as tailored courses at customer’s own premises or remotely via interactive live, web based training.

We also offer our clients the opportunity to continuously develop the skills of their company through our TixamTree Knowledge Scheme

Please scroll down our courses below or check the calendar to see what courses are scheduled to run in the next few weeks. We are always adding to our courses and if you don’t see exactly what you are looking for please contact us – we’re here to help you

COURSE
WHO FOR
WHAT WE COVER
WHAT NEXT

MS Excel
Introduction

 

Course Code:

TEXPINTROD

Anyone who is new to excel or just needs that little bit of extra help with the basics. This course is designed for those who need to know the fundamentals and will provide you with the practical knowledge of how to effectively use a spreadsheet.

  • What is a spreadsheet
  • Creating a worksheet
  • Entering text and numbers
  • Changing cell attributes
  • Entering formulae
  • Saving and closing a worksheet
  • Opening an existing worksheet
  • Printing and print options
  • Inserting columns and rows
  • Moving and copying
  • Relative and absolute references
  • Creating graphs
  • How to use Help
  • Your questions

MS Excel
Intermediate

MS Excel Advanced

MS Excel
Intermediate

 

Course Code:

TEXPINTERM

Anyone who already has a basic understanding of excel and would like to learn how to manipulate and interrogate data using advanced functions in excel. This course will provide you with the practical knowledge of how to use spreadsheets to gain information back from data entered.

  • 3D spreadsheets
  • Linking spreadsheets
  • Linking formulae across sheets and files
  • The formula wizard
  • Graph options
  • Data tables
  • Lookups
  • Pivot tables
  • Sort and filter
  • File management

MS Excel Advanced

 

Introduction to Excel Integrated Reporting

MS Excel
Advanced

 

Course Code:

TEXPADVANC

Anyone who has a good understanding of excel and has already applied the skills gained on the EXCEL INTERMEDIATE course. This course is designed for those who need to perform advanced data manipulation and analysis.

  • Indexing and matching data
  • Control boxes for adding selection boxes
  • Advanced conditional formatting based on formulae
  • Using named ranges and tables
  • Auditing formulae
  • Setting up data connections to external sources
  • Grouping data
  • Consolidating data
  • Using slicers
  • Basic macro recording
  • Protecting cells
  • Creating template workbooks

Introduction to Excel Integrated Reporting

 

Excel Integrated Reporting Workshop

MS Excel
Introduction

 

Course Code:

TWOPINTROD

Anyone who needs to use Microsoft Word to create and manage documents. The course is designed to provide you with the practical knowledge of how to effectively use the basic functions of a word processor.

  • Creating a document
  • Formatting text
  • Alignment options
  • Overtype vs insert
  • Margins and tabs
  • Saving a document
  • Printing and print options
  • Retrieving an existing document
  • Correcting mistakes
  • Spell check and thesaurus
  • Cut, paste and copy
  • Adding spreadsheets and graphs

MS Word
Intermediate

MS Excel
Intermediate

 

Course Code:

TWOPINTROD

This course is designed for anyone who has basic knowledge of Word but needs to make use of the some of the more advanced features.

  • Creating and using templates
  • Bullets, numbering and indents
  • Using colour for emphasis
  • Manipulating inserted images
  • Headers and footers
  • Standard letters and mail merge
  • Page styles and columns
  • Creating pages in Web format
  • Customising the toolbar

MS Office Workshop

MS PowerPoint Introduction

 

Course Code:

TPOPINTROD

This course is designed for anyone who has a little or no experience of PowerPoint and wants to use the product to create professional presentations.

  • Creating a presentation file
  • Entering text
  • Text formatting
  • Slide preview
  • Saving and closing a presentation
  • Opening an existing file
  • Adding new slides
  • Copying and moving objects
  • Presentation templates
  • Importing data from other sources
  • Tips on professional presentations
  • Printing

MS PowerPoint Intermediate

MS PowerPoint Intermediate

 

Course Code:

TPOPINTROD

This course is designed for anyone who has basic knowledge or has been on our INTRODUCTION TO POWERPOINT course and needs to create all singing and dancing impressive presentations.

  • Using organisation charts
  • The auto content wizard
  • Altering the slide master
  • Running a slide show
  • Animation techniques
  • Rulers and guides
  • Adding notes and sorting slides
  • Using autoshapes
  • Customising the toolbars to add commonly used functions

MS Project
Introduction

 

MS Office Workshop

MS Outlook

 

Course Code:

TOUPINTROD

This course is designed for anyone who is overwhelmed with emails and needs to manage the flow of information – clearly identifying what needs auctioning, filing or reading. Learn how to manage your diary, email and contacts effectively

  • Composing e-mails – etiquette and structure
  • Addressing e-mails
  • Sending and receiving e-mails
  • Filing and managing e-mails
  • Creating and managing contacts
  • Using the calendar to create appointments and tasks
  • Managing task lists
  • Sharing appointments and tasks
  • Delegating tasks and reporting progress

MS Word Intro

 

MS Word
Intermediate

MS Access
Introduction

 

Course Code:

TACPINTROD

This course is designed for anyone who needs to understand the basics of databases and database designs.

  • Database terminology explained
  • Creating a database
  • Working with tables
  • Designing forms
  • Entering data
  • Exporting information from Excel
  • Saving and opening databases
  • Finding data with filters
  • Designing and using basic reports

MS Access
Intermediate

MS Access
Intermediate

 

Course Code:

TACPINTERM

This course is designed for people who need to manage more complex databases.

  • Maintaining databases
  • Using query to analyse data from multiple databases
  • Adding graphics to reports
  • Using multiple sources for reports
  • Creating and using macros
  • Creating and using modules

MS Excel
Intermediate

MS Project
Introduction

 

Course Code:

TPRPINTROD

This course is designed for Project Managers and anyone who needs to track people, task or resource changes

  • What is MS Project?
  • Creating a project plan
  • Tasks, resources and time scales
  • Costs
  • Grouping Tasks
  • Task dependencies
  • Creating milestones
  • Printing your plan

MS Projec
Intermediate

MS Project
Intermediate

 

Course Code:

TPRPINTERM

This course is designed for anyone who needs to manage projects and create and provide detailed project reports. This course will suit Project Managers and anyone with basics MS Project knowledge who needs to learn more.

  • Changing views
  • Checking for bottlenecks
  • Managing your plan
  • Tracking changes
  • Reporting
  • Filtering
  • Creating Links

Project Management Skills

 

Effective Time Management

Introduction to
the Sage
Report
Designer

 

Course Code:

TEXPINTROD

This course is designed for anyone needs to analyse SAGE information, alter report layouts or manage report templates

  • The report designer layouts
  • Database structures
  • Designing reports
  • Adding logos
  • Adding filters and criteria
  • Changing text layouts and fields

Sage Report
Designer Workshop

 

MS Office workshop

Introduction to
Excel
Integrated
Reporting

 

Course Code:

TSAPREPORT

This course is designed for anyone wants to learn how to extract SAGE data automatically into EXCEL for further analysis.

  • Setting up the link between Sage and Excel
  • Inserting data ranges
  • Using Sage functions within Excel
  • Updating data ranges
  • Designing reports in Excel

Excel Integrated Reporting Workshop

Sales and
Purchase Order
Processing
modules

 

Course Code:

TSAPSOP&PO

This course is designed for anyone who needs to manage sales and purchase invoices and payments

  • Overview of Sage, navigation and integration
  • Setting up customer records
  • Setting up supplier records
  • Creating sales invoices
  • Posting purchase invoices
  • Managing customer payments and credit control
  • Managing supplier payments
  • Reports and statements
  • Invoice layout design

Sage Stock Controlp

 

Sage Project Control

 

Sage Accounts
Stage 1

Sage Stock
Control

 

Course Code:

TSAPSTOCK

This course is designed for anyone who need to manage stock or bills of materials (BOM).

  • Creating stock records
  • Creating a BOM
  • Managing stock in and out
  • Stock control for order processing
  • Reporting

Sage Project Control

 

Sales and Purchase Order Processing Modules

 

Sage Accounts
Stage 1

Sage Project
Control

 

Course Code:

TSAPPROJEC

This course is designed for anyone who needs to manage job profitability in a service environment.

  • Creating projects for job profitability
  • Setting up resources
  • Booking resources, costs and sales to projects
  • Managing multi-level projects
  • Reporting

Sage Sales and Purchase ledgers

 

Sage Accounts
Stage 1

Sage Payroll

 

Course Code:

TSAPPAYROL

This course is designed for anyone who needs to run payroll either weekly or monthly.

  • System setup
  • Setting up employees
  • Setting up pay elements
  • Processing a pay run
  • Reporting
  • Closing the payroll period
  • Processing payroll year end and updates
  • Linking to Sage accounts to process Payroll journals

Introduction to the
Sage Report
Designer

Sage50
Accounts Stage
1

 

Course Code:

TSAPSTAGE1

This course designed for organisations or individuals who needs to install and use Sage 60 for the first time.

  • Setting up
  • Defaults
  • Chart of Accounts (COA)
  • Customer and Supplier Records
  • Product Records
  • Product Categories

Sage 50 Accounts
Stage 2

Sage 50 Accounts
Stage 3

Sage 50 Accounts
Stage 4

Sage50
Accounts Stage
2

 

Course Code:

TSAPSTAGE2

Stage 2 is designed for organisations or individuals who use Sage 50 and have completed Stage 1.

  • Posting
  • Customer invoices and credit notes
  • Supplier invoicing and credit notes
  • Customer receipts and supplier payments
  • Invoicing – Adding your logo to invoice and credit note layouts
  • How to search for information using filters and find functions
  • Correcting mistakes – The audit trail
  • Backups

Sage 50 Accounts
Stage 3

Sage 50 Accounts
Stage 4

Sage50
Accounts Stage
3

 

Course Code:

TSAPSTAGE3

Stage 3 is designed for organisations or individuals who use Sage 50 and have completed Stage 1 and 2.

  • Posting
  • Bank receipts
  • Bank payments
  • Nominal journals
  • Checking
  • Bank reconciliation
  • Credit Control
  • Using the Communications tab correctly
  • Credit Control view layouts

Sage 50 Accounts
Stage 4

Sage50
Accounts Stage
4

 

Course Code:

TSAPSTAGE4

Stage 4 is designed for organisations or individuals who use Sage 50 and have completed Stage 1, 2 and 3.

  • How to carry out basic reporting techniques.
  • How to run reports to find out what customers owe the company and what monies are owed to suppliers.
  • How to use the Excel button for reporting within Sage and completing and submitting a VAT return.
  • Get practical experience help and advice on how to produce the best results based on your needs.

Sage Report
Designer Workshop

 

Sales & Purchase
Order Processing

All our courses are hands-on with extensive use of examples