Excel Level 1

~~£149.00~~ Offer Price £49.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 |

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 |

~~£154.00~~ Offer Price £49.00 for 12 months access. Home Page for Enrolment Link

Excel Level 2

~~£149.00~~ Offer Price £49.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 – Preview |

Lesson 3 | Let’s Get Started Copy |

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 |

Coming Soon

The following courses will be available soon as self-paced video courses. They are available at the moment as Live webinar courses

**Excel Level 3 (available live – www.itcourseslive.com)**

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.

**Excel Level 4 – Power Pivot (available live – www.itcourseslive.com)**

This course is ideal for experienced users who are responsible for analysing data from many sources and have a good understanding of Excel functions and formulas.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT

Privacy & Cookies Policy

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.