£149.00 for 12-months access. Home Page for Enrolment Link
This course is ideal for both new users to Excel and long term users who have had no formal training (often self-taught) and would like to make sure they are prepared for further levels. A general understanding of the personal computer and Windows would be useful. There are lots of useful time-saving tips.
Module 1 | Introduction and Welcome |
Lesson 1 | Welcome Message – Preview |
Lesson 2 | What you need – Preview |
Lesson 3 | Let’s Get Started |
Module 2 | Basic Navigation and Formatting |
Lesson 1 | Entering |
Lesson 2 | Navigating Data |
Lesson 3 | Selecting Data |
Lesson 4 | Shortcuts and Key tips |
Lesson 5 | Ctrl Shortcuts |
Lesson 6 | Fill Handle |
Lesson 7 | Resizing Columns and Rows |
Lesson 8 | New Rows and Columns |
Lesson 9 | Formatting |
Lesson 10 | Merge Cells |
Lesson 11 | Orientation – Preview |
Lesson 12 | Wrap Text |
Lesson 13 | Dates and Times |
Lesson 14 | Notes |
Lesson 15 | Move and Copy Worksheets |
Lesson 16 | Assignment |
Module 3 | Excel Formulas and Basic Maths |
Lesson 1 | Order of Calculations |
Lesson 2 | Basic Formulas |
Lesson 3 | Adding Ranges of Data |
Lesson 4 | Relative References |
Lesson 5 | Absolute References |
Lesson 6 | Assignment – Formulas-1 |
Lesson 7 | Assignment – Formulas-2 |
Module 4 | Basic Analysis |
Lesson 1 | Sort Data |
Lesson 2 | Filter |
Lesson 3 | Find |
Lesson 4 | Printing |
Lesson 5 | Show Formula |
Lesson 6 | Freeze Panes |
Lesson 7 | Aggregate Data |
Lesson 8 | Conditional Formatting |
Lesson 9 | Charts |
Lesson 10 | Final Assignment |
Lesson 11 | Completed |
£149.00 for 12-months access. Home Page for Enrolment Link
£149.00 for 12-months access. Home Page for Enrolment Link
This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques.
Module 1 | Introduction and Welcome |
Lesson 1 | Introduction to the course – Preview |
Lesson 2 | What you need Excel 2 |
Lesson 3 | Let’s Get Started |
Module 2 | Logic Functions |
Lesson 1 | Logic |
Lesson 2 | IF Function |
Lesson 3 | IF Return Number |
Lesson 4 | If Cell References |
Lesson 5 | IF Cell References 2 |
Lesson 6 | IF With Formulas |
Lesson 7 | IF with Formulas 2 |
Lesson 8 | IF Assignment |
Module 3 | New Functions |
Lesson 1 | Concatenate |
Lesson 2 | Unique Function |
Lesson 3 | Sort Function |
Lesson 4 | Sort an Array |
Lesson 5 | Unique Array Columns |
Module 4 | Logic Aggregate Functions |
Lesson 1 | Aggregate Functions |
Lesson 2 | CountIF |
Lesson 3 | SumIF and AverageIF |
Lesson 4 | Sumifs Averageifs Countifs |
Module 5 | Nested IF Functions |
Lesson 1 | Nested IF |
Lesson 2 | Nested IF Assignment Exam Results |
Lesson 3 | Nested IF Assignment Bonus Payment |
Lesson 4 | Nested IF Assignment Formula |
Lesson 5 | AND Function |
Lesson 6 | OR Function |
Lesson 7 | Not Function |
Lesson 8 | Assignment – Final Logic |
Module 6 | Dates and Times |
Lesson 1 | Date and Time Entries |
Lesson 2 | Date Calculations |
Lesson 3 | Date Function and Formats |
Lesson 4 | Year Month Day Functions |
Lesson 5 | Text Function |
Lesson 6 | Date Difference Function |
Module 7 | Custom Lists and Naming |
Lesson 1 | Custom Lists |
Lesson 2 | Naming |
Module 8 | Lookups |
Lesson 1 | VLookup |
Lesson 2 | VLookup Assignment |
Lesson 3 | HLookup |
Lesson 4 | HLookup Approximate Match |
Lesson 5 | Match Function |
Lesson 6 | Index Function |
Lesson 7 | Index and Match |
Module 9 | Lookups – Xlookup |
Lesson 1 | XLookup |
Lesson 2 | XLookup Array |
Lesson 3 | XLookup Horizontal |
Lesson 4 | XLookup Nested |
Lesson 5 | XLookup Filter |
Lesson 6 | XLookup SUM |
Lesson 7 | XLookup Search |
Lesson 8 | XLookup Wildcard |
Lesson 9 | XLookup Approximate Match |
Lesson 10 | Well Done Excel 2 Complete |
£149.00 for 12-months access. Home Page for Enrolment Link
This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.
Module 1 | Introduction and Welcome |
Lesson 1 | Welcome – Preview |
Lesson 2 | What You Need |
Module 2 | Getting Started |
Lesson 1 | Let’s Get Started |
Lesson 2 | Developer Tab – Preview |
Lesson 3 | Naming Ranges |
Module 3 | Form Controls |
Lesson 1 | Combo Box ActiveX Control |
Lesson 2 | VLookup and Date Difference |
Lesson 3 | Scroll Bar ActiveX Control |
Lesson 4 | Checkbox ActiveX Control |
Lesson 5 | Options Button Form Control |
Module 4 | What-If Analysis |
Lesson 1 | Scenario Manager |
Lesson 2 | Assignment – Scenario Manager |
Lesson 3 | Goal Seek |
Lesson 4 | The Payment Function – Loan Calculator |
Lesson 5 | Assignment – Goal Seek |
Lesson 6 | Solver |
Module 5 | Data Tools |
Lesson 1 | Data Validation |
Lesson 2 | Text to Columns |
Lesson 3 | Flash Fill |
Module 6 | Outline |
Lesson 1 | Subtotal |
Lesson 2 | Subtotal Assignments |
Lesson 3 | Auto Outline |
Lesson 4 | Grouping |
Module 7 | PivotTables |
Lesson 1 | The Basics |
Lesson 2 | The Basics Continued… |
Lesson 3 | Refresh Data |
Lesson 4 | Count |
Lesson 5 | Formatting Numbers |
Lesson 6 | Assignment – PivotTable |
Lesson 7 | Data Source Layout |
Lesson 8 | Convert Traditional to Tabular |
Lesson 9 | Remove Unwanted Spaces |
Lesson 10 | Using Tables |
Lesson 11 | Refresh and Refresh All |
Lesson 12 | PivotTable Drill-Down |
Lesson 13 | Blanks and Errors |
Lesson 14 | Grouping |
Lesson 15 | PivotTable Slicers |
Lesson 16 | PivotCharts |
Module 8 | Macros |
Lesson 1 | What are Macros |
Lesson 2 | Macro Security |
Lesson 3 | Saving Macro Workbooks |
Lesson 4 | Recording a Macro |
Lesson 5 | Edit a Macro |
Lesson 6 | Join Macros Together |
Lesson 7 | Assign a Shortcut |
Lesson 8 | Personal Macro run from QAT |
Lesson 9 | Macro to Filter Data |
Lesson 10 | Assign a Button |
Lesson 11 | Absolute and Relative Referenced Macros |
Lesson 12 | Non-Programmer Workarounds |
Lesson 13 | Changing Referencing Type |
Lesson 14 | VBA Code |
Lesson 15 | Dynamic Message Box |
Lesson 16 | VBA – Do While Loop |
Lesson 17 | Macro Assignment |
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Your Responsibility
What InIT Learning is doing.
There are seperate dates for the live online classes. The maximum is normally ten although will run with just one booking.
Your Responsibility
What InIT Learning is doing
Your Responsibility
What is InIT Learning doing to help?
How do we maintain a social distance?
Your responsibility:
What is InIT Learning doing to help?