Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...

Excel VLOOKUP Basics & Top 5 Mistakes Rookies Make An Excel VLOOKUP can be your best friend. It can save you hours of work. Give this formula the information you have and it looks through a long list ...

The Complete Excel VBA, and Data Science Certification Training Bundle goes over the basics of Microsoft Excel for automation, data visualization, and more for $49.99.

Discover resources to help you learn MS Excel at a basic, intermediate and advanced level. Get information from online courses to help you get started.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

This course is intended for experienced Excel 2013 users who have a desire or need to advance their skills by using larger data sets to simulate realistic work applications. Main concepts covered ...

Pre-requisite: Excel Basics Part 1 or a basic knowledge of Microsoft Excel. Basic keyboarding and mouse skills required. Register in person at the Information Desk or by calling 416-394-5240.