Lessons Archive

Intermediate MS Excel

Free Preview

Length: 960 minutesComplexity: Standard

Details about the Intermediate MS Excel Online portion of this bundled course.  With over 133 lessons, 260 video clips and 48 example exercises with detailed video solutions explaining exactly how you should have got to the answer. This portion of the course builds on the Fundamental knowledge from the beginner course and teaches you to solve problems in Excel with a particular focus on the tools available.

Beginner MS Excel

Free Preview

Length: 480 minutesComplexity: Easy

Details about the Online Beginner MS Excel portion of the Course. With over 60 lessons, 130 video clips, and 28 example exercises with detailed video solutions explaining exactly how you should have got to the answer. This portion of the course will give you the fundamentals to make sure it is easy to learn anything about Excel.

Build your first VLOOKUP

Length: 20 minutesComplexity: Easy

Build your first VLOOKUP and understand what each component means and how to use it.

VLOOKUP explained in simple terms

Length: 5 minutesComplexity: Easy

Vlookup explained in simple terms so that you obtain a fundamental knowledge that you can apply to the more advanced uses of VLOOKUP

Trick: Protect rows and columns without protecting sheet

Length: 20 minutesComplexity: Easy

The problem with the Protect Sheets is that it does apply some limits and some users want everything to be open EXCEPT that they don't want users to insert or delete rows and columns (this is a very common cause of spreadsheet errors or 'templates' corrupting). This is a trick to disable the insert/ delete option without protecting the sheet and no VBA.  

Hide formulas in Excel

Length: 20 minutesComplexity: Easy

When you protect a sheet you typically stop users from changing your formulas. However, you can also control whether a user can see a formula on a cell. If you want the formula to be hidden you need to follow a slightly different process.

SUMIF et al Examples

Length: 20 minutesComplexity: Easy

SUMIFS et al Examples- sales by area, recon lists, duplicate bank accounts