IT Training and Consultancy

Excel Training

MaximITy has a dedicated Centre of Excellence training room where we offer hands-on training and coaching to help organisations learn how to use their business software better. We provide everything from introductory level to advanced Excel training and our small class sizes allow us to give individual focus to delegates. We carry out a Training Needs Analysis prior to each course to ensure people are on the most appropriate course for them, and we also follow up with a feedback analysis report that can be used for ongoing learning support.

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 contact us if you are interested in finding out how we could help you with your staff training and development needs.

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

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