IT COURSES

We run a select number of IT courses, focusing on what we know and love, meaning you can be assured that you will receive training which has passed our scrutiny and been quality tested.

We regularly update our courses in response to changes in the training subject and customer feedback.

We pride ourselves on delivering quality training that meets your needs and expectations.

  • Microsoft 365

  • Microsoft Excel - Introduction to Professional

  • Microsoft Word - Introduction to Professional

  • Microsoft PowerPoint - Introduction to Professional

  • Microsoft Dynamics 365

  • Microsoft Teams

DSC07749.jpg

MICROSOFT EXCEL INTRODUCTION

Get to grips with the basics of Microsoft Excel

Get to grips with the basics of Microsoft Excel in a relaxed training environment where your trainer will ensure you go home feeling confident and competent.

SUITABLE FOR:

  • Absolute Beginners

  • Those with a basic knowledge looking to build confidence and competence

Whether you have been using Excel for some time but still feel you need guidance or an absolute beginner with zero knowledge this course will get you using Excel in a basic competent way in just a day!

Whether you are an absolute beginner or have some familiarity of Excel, this course will ensure a basic level of competence and meaningful usage.

Our courses are designed to be run on PowerPoint, so you don’t have to look through a manual. This means the delegate can simply see what is happening on the screen and the trainer can help delegates in more meaningful way.

Public Courses and client on site

Key Learnings

cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png

An introduction to Excel

The Excel platform

Adding & editing data

Worksheets

Styles & themes

Basic formulas

Charts

Printing

Public Classes - £199 + VAT
Client Site - From £595 + VAT for up to 6 Delegates for full days training and support
Telephone: 07543 735000
E-mail: info@cognition-training.co.uk
20190627_091043.jpg

Public Courses and client on site

Key Learnings

cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png

Protecting workbooks

Relative & absolute formulas

Function commands

=IF and nested IF functions

=SUMIF

Sorting & filtering

Conditional formatting

Data validation and drop down lists

Charts

Linking worksheets and workbooks

Public Classes - £199 + VAT
Client Site - From £595 + VAT for up to 6 Delegates for full days training and support
Telephone: 07543 735000
E-mail: info@cognition-training.co.uk

MICROSOFT EXCEL INTERMEDIATE

Get Excel really working for you by learning some of the powerful features

Do you use Excel but still feel you need guidance and could benefit from a deeper level of knowledge?

Get Excel really working for you by learning some of the powerful features it has to offer, enabling you to design and edit workbooks as well as looking at some very useful (and easy to use once you know how!) formulas, which will set you apart from others.

SUITABLE FOR:

  • Those with a basic knowledge who want to move to the next level

This course will give you the skillset to get you using Excel in a more effective and efficient way in just a day!

Our trainer will ensure you get the time to build your confidence and competence and if required will dedicate extra time if required; it’s all part of the cost, such is our commitment to your training.

Our courses are designed to be run on PowerPoint, so you don’t have to look through a manual. This means the delegate can simply see what is happening on the screen and the trainer can help delegates in more meaningful way.

1.jpg

MICROSOFT EXCEL ADVANCED

Learn to use the most powerful features of Excel, enabling you to analyse data and solve complicated scenarios

Learn to use the most powerful features of Excel, enabling you to analyse data and solve complicated scenarios, as well as manipulate and transpose data in an efficient and meaningful manner.

SUITABLE FOR:

  • Those with a good knowledge of Excel who want to move up to the next level

  • Those wishing to use Pivot Tables, VLOOKUPs, macros and consider projections

  • Those who wish to analyse data, consider projections and work effectively

By the end of the day you will be on your way to becoming a real Excel guru!

Our trainer will ensure you get the time to build your confidence and competence and if required will dedicate extra time if required; it’s all part of the cost, such is our commitment to your training.

Our courses are designed to be run on PowerPoint, so you don’t have to look through a manual. This means the delegate can simply see what is happening on the screen and the trainer can help delegates in more meaningful way.

Public Courses and client on site

Key Learnings

cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png

Scenario manager

Goal seek

Data tables

Solver tool

Conditional formatting

Consolidate tasks

Pivot tables

LOOKUPS

Macros

Public Classes - £199 + VAT
Client Site - From £595 + VAT for up to 6 Delegates for full days training and support
Telephone: 07543 735000
E-mail: info@cognition-training.co.uk
Teams-in-Education-eBook-Blog-1.jpg

Public Courses and client on site

Key Learnings

cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
cognition-logo-3.png
What is Teams
Teams Platform
Searching
Chats
Teams
Channels
Files
Meetings
Public Classes - £199 + VAT
Client Site - From £595 + VAT for up to 6 Delegates for full days training and support
Telephone: 07543 735000
E-mail: info@cognition-training.co.uk

MICROSOFT TEAMS

Learn to use the features of Teams, enabling you to collaborate and work with greater effectiveness

Learning how to work Teams correctly is likely to transform your teamwork. With this course you will learn to use the most powerful features of Teams, enabling you to work in a new and enhanced way.

REASONS TO USE TEAMS:

  • Chat - A way to communicate without using unnecessary e-mails

  • Meetings - Schedule meetings or have ad-hoc meetings with ease

  • Improved collaboration and communication - share content and communication with a joined up approach

  • Fewer e-mails!

  • Stay connected with your team, contacts and content wherever you may be

Meeting Room Business

MICROSOFT DYNAMICS 365

Dynamics 365 helps you with all your Customer Relationship Management, Sales and Marketing requirements and is integrated with Office.

If you or your business has a D365 need, whether it be training, or consultancy then contact us as we can help.

On site – click here

Telephone: 07543 735000

E-mail: info@cognition-training.co.uk