IT Training and Consultancy

Excel Online Training

Online, on demand training courses have the advantage that you can access help exactly when you need it, day or night, week day or weekend, home, office or abroad. Our comprehensive catalogue of short, focused online tutorials will really help you get to grips with using your software.

Find the training you need in 3 clicks, be up and running in less than 3 minutes.

Prices start from just £60 for a single user, annual subscription, so it won’t break the bank but it may cause a reduction in stress and an increase in efficiency!

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:

TEXOLINTROD

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

  • Auto Fill
  • AutoSum
  • Average
  • Calculations – Basic
  • Columns and Rows – Insert and Delete
  • Columns and Rows – Width and Height
  • Count
  • Entering and Editing Data
  • Flash Fill
  • Formatting – Align Wrap and Merge
  • Formatting – Borders
  • Formatting – Cells Styles
  • Formatting – Fonts
  • Formatting – Numbers
  • Insert copy and move data
  • Max and Min
  • Printing – Page Breaks
  • Printing – Page Layout
  • Printing – Page Setup
  • Printing – Set Print Area
  • Screen Views
  • The Formula Bar
  • Worksheets – Add, Delete and Rename
  • Worksheets – Copy and Move
  • What is a spreadsheet

MS Excel
Intermediate

MS Excel Advanced

MS Excel
Intermediate

 

Course Code:

TEXOLINTERM

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. These online courses will provide you with the practical knowledge of how to use spreadsheets to gain information back from data entered.

  • AVERAGEIFS
  • Calculations – Absolute Cells
  • Calculations – Date and Time
  • Calculations – Date Functions
  • Charts – Create a Chart
  • Charts – Data Source
  • Charts – Elements
  • Charts – Formatting
  • Charts – Overview
  • Charts – Sparklines
  • CONCAT
  • Conditional Formatting
  • Conditional Formatting – Icon Sets
  • Conditional Formatting – New Rules
  • CountIf
  • COUNTIFS
  • Creating Templates
  • Filtering Data
  • Find and Replace
  • Format as Table
  • Freeze Panes
  • Grouping Worksheets
  • Hiding Data
  • Hyperlinks
  • IF
  • IF with AND
  • IF with OR
  • IFS
  • Images
  • Linking worksheets
  • MAXIFS and MINIFS
  • Notes
  • Outlining Data
  • Pivot Tables
  • Pivot Tables – Analyze and Design Tabs
  • Pivot Tables – Pivot Charts
  • Pivot Tables – Recommended Pivot Tables
  • Pivot Tables – Timelines and Slicers
  • Quick Analysis
  • Remove Duplicates
  • Shapes
  • Sorting Data
  • Split Screens
  • Subtotals
  • SUMIF
  • Text to Columns
  • Threaded Comments

MS Excel Advanced

 

Introduction to Excel Integrated Reporting

MS Excel
Advanced

 

Course Code:

TEXOLADVANC

Anyone who has a good understanding of Excel. These online courses are designed for those who need to perform advanced data manipulation and analysis.

  • Assigning Macros
  • Data Consolidation
  • Excel Options – Advanced
  • Excel Options – Formulas
  • Forecast Sheets
  • Goal Seek
  • HLOOKUP
  • Introduction to Macros
  • Manage Scenarios
  • Pivot Table – Edit Data
  • Pivot Table – Use External Data
  • Pivot Tables – Customising
  • Pivot Tables – Formatting
  • Pivot Tables – Grouping
  • Protecting data
  • Scenario Reports
  • Scenarios
  • VLOOKUP

Introduction to Excel Integrated Reporting

 

Excel Integrated Reporting Workshop