Learn Excel Online

Learn Excel Online Learn Excel Online

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.

MS Excel Introduction

Course Code: TEXOLINTROD

WHO FOR?

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.

WHAT WE COVER

  • 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

WHAT NEXT?

MS Excel Intermediate

MS Excel Advanced

MS Excel Intermediate

Course Code: TEXOLINTERM

WHO FOR?

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.

WHAT WE COVER

  • 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

WHAT NEXT?

MS Excel Advanced

Introduction to Excel Integrated Reporting

MS Excel Advanced

Course Code: TEXOLADVANC

WHO FOR?

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

WHAT WE COVER

  • 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

WHAT NEXT?

Introduction to Excel Integrated Reporting

Excel Integrated Reporting Workshop