Online Excel Training

Registration Details

Please choose your subscription plan		Price
	Monthly Subscription	£ 9.99/Month
	3 Month Subscription	£ 24.99/3 Month

First Name:		*
Surname:		*
Email:		*
House No./Name:		*
Street:		*
Town:		*
County:		*
Postcode:		*
Country:		*
Company Name:
Choose password:		* (at least 6 characters)
Confirm password:		*
	Please tick to confirm you have read, understood and accept our Terms & Conditions.

excel syllabus icon

Our Syllabus

Lesson 1 Data Entry & Basic Formulas Lesson 2 Inserting & Deleting Columns and Rows Lesson 3 Deleting Data Lesson 4 Formatting Text Lesson 5 Inserting Shapes Lesson 6 Simple Copy & Paste Data Lesson 7 Advanced Copy & Paste Data Lesson 8 Cut and Paste Data Lesson 9 Absolute Formula vs. Relative Formula Lesson 10 Creating Pie Charts Lesson 11 Inserting a Screen Shot Lesson 12 Using the Format Painter Lesson 13 Formatting Numeric Data Lesson 14 Using the Fill Option Lesson 15 Using the Sort Function Lesson 16 Using the Find & Replace Function Lesson 17 Inserting a Text Box Lesson 18 Creating Bar Charts Lesson 19 Inserting Special Symbols Lesson 20 Using Spark Lines Lesson 21 Creating Headers & Footers Lesson 22 Conditional Formatting Lesson 23 Inserting Word Art Lesson 24 Freezing Panes Lesson 25 Creating a Table Lesson 26 Using Styles Lesson 27 Text Alignment Lesson 28 Word Wrap

Intermediate(Worksheet manipulation, Pivot tables, Lookup tables and Goal Seek)

Lesson 29 Merging Cells Lesson 30 Fill Colour Lesson 31 Using the Clipboard Lesson 32 Using on-screen Formula Lesson 33 Linking Sheets Lesson 34 Linking Workbooks Lesson 35 Creating a Workspace Lesson 36 Organising Sheets Lesson 37 Using a Named space Lesson 38 Inserting Comment boxes Lesson 39 Removing Duplicate Values Lesson 40 Protecting a Workbook Lesson 41 Using the Thesaurus & Spell Checker Lesson 42 Splitting the Excel Window Lesson 43 Using the Group Function Lesson 44 Tracing Precedents & Dependents Lesson 45 Text to Columns Lesson 46 Consolidating Data Ranges Lesson 47 Data Validation Lesson 48 Show Formulas and error check Lesson 49 Setting the Watch Window Lesson 50 Setting the Sheet Background Lesson 51 Arranging Objects Lesson 52 Using 'Print Preview and 'Print Area' options Lesson 53 Arranging Windows Lesson 54 Creating a Pivot Table Lesson 55 Using a 'Slicer' Lesson 56 Creating a Lookup Table Lesson 57 Goal seek

Advanced(Macros – Creation, design and use of:)

Lesson 58 Creating a simple Macro Lesson 59 Importing Access Data Lesson 60 Importing from a text file Lesson 61 Inserting a Command Button Lesson 62 Inserting a Spin Control Lesson 63 Inserting a Combo Box Lesson 64 Inserting Radio Buttons Lesson 65 Inserting a Checkbox Lesson 66 Inserting a Label Lesson 67 Inserting a List Box Lesson 68 Inserting an Image Control Lesson 69 Inserting a Text Box Lesson 70 Using the Toggle Button Lesson 71 Inserting a Scroll Bar Slider Lesson 72 Relative vs. Absolute Cut and Paste Macros Lesson 73 Pinning a Macro to the Quick Access Toolbar Lesson 74 Creating a User Form Lesson 75 Database Macro Lesson 76 Sorting and Filtering a Pivot Table Lesson 77 Grouping in Pivot Tables Lesson 78 Pivot Table Macro Lesson 79 Pivot Charts Lesson 80 Pivot Chart Macro Lesson 81 Autosum

Lesson 1 Data Entry & Basic Formulas Lesson 2 Inserting & Deleting Columns and Rows Lesson 3 Deleting Data Lesson 4 Formatting Text Lesson 5 Inserting Shapes Lesson 6 Simple Copy & Paste Data Lesson 7 Advanced Copy & Paste Data Lesson 8 Cut and Paste Data Lesson 9 Absolute Formula vs. Relative Formula Lesson 10 Creating Pie Charts Lesson 11 Inserting a Screen Shot Lesson 12 Using the Format Painter Lesson 13 Formatting Numeric Data Lesson 14 Using the Fill Option Lesson 15 Using the Sort Function Lesson 16 Using the Find & Replace Function Lesson 17 Inserting a Text Box Lesson 18 Creating Bar Charts Lesson 19 Inserting Special Symbols Lesson 20 Using Spark Lines Lesson 21 Creating Headers & Footers Lesson 22 Conditional Formatting Lesson 23 Inserting Word Art Lesson 24 Freezing Panes Lesson 25 Creating a Table Lesson 26 Using Styles Lesson 27 Text Alignment Lesson 28 Word Wrap

Intermediate(Worksheet manipulation, Pivot tables, Lookup tables and Goal Seek)

Lesson 29 Merging Cells Lesson 30 Fill Colour Lesson 31 Using the Clipboard Lesson 32 Using on-screen Formula Lesson 33 Linking Sheets Lesson 34 Linking Workbooks Lesson 35 Creating a Workspace Lesson 36 Organising Sheets Lesson 37 Using a Named space Lesson 38 Inserting Comment boxes Lesson 39 Removing Duplicate Values Lesson 40 Protecting a Workbook Lesson 41 Using the Thesaurus & Spell Checker Lesson 42 Splitting the Excel Window Lesson 43 Using the Group Function Lesson 44 Tracing Precedents & Dependents Lesson 45 Text to Columns Lesson 46 Consolidating Data Ranges Lesson 47 Data Validation Lesson 48 Show Formulas and error check Lesson 49 Setting the Watch Window Lesson 50 Setting the Sheet Background Lesson 51 Arranging Objects Lesson 52 Using 'Print Preview and 'Print Area' options Lesson 53 Arranging Windows Lesson 54 Creating a Pivot Table Lesson 55 Using a 'Slicer' Lesson 56 Creating a Lookup Table Lesson 57 Goal seek

Advanced(Macros – Creation, design and use of:)

Lesson 58 Creating a simple Macro Lesson 59 Importing Access Data Lesson 60 Importing from a text file Lesson 61 Inserting a Command Button Lesson 62 Inserting a Spin Control Lesson 63 Inserting a Combo Box Lesson 64 Inserting Radio Buttons Lesson 65 Inserting a Checkbox Lesson 66 Inserting a Label Lesson 67 Inserting a List Box Lesson 68 Inserting an Image Control Lesson 69 Inserting a Text Box Lesson 70 Using the Toggle Button Lesson 71 Inserting a Scroll Bar Slider Lesson 72 Relative vs. Absolute Cut and Paste Macros Lesson 73 Pinning a Macro to the Quick Access Toolbar Lesson 74 Creating a User Form Lesson 75 Database Macro Lesson 76 Sorting and Filtering a Pivot Table Lesson 77 Grouping in Pivot Tables Lesson 78 Pivot Table Macro Lesson 79 Pivot Charts Lesson 80 Pivot Chart Macro Lesson 81 Autosum