Videos

  • The press is full of Corona virus stories and graphs, but what is the basis of the projections? In this video I explain the concept of exponential growth and show you how to create your own Covid-19 infection rate simulation. The Excel file is available under downloads.
  • Office 365 has a new lookup function XLOOKUP, which solves several problems with the popular function VLOOKUP. In this video, I show you the main problems with VLOOKUP and how these are solved with XLOOKUP.
  • Filters are very useful for data analysis. In this video I show you some useful tips including how to filter a column using multiple criteria and how to simply record this selection for future use. I also show you how to very quickly filter a list for errors or blank cells.
  • Gary Knott | how2excel - Excel Schulungen Blog
    This video demonstrates an Excel file which creates a fun snowfall for Christmas using a macro with nested loops to carry out actions in every column and every row. You can download the file and an explanatory PDF under downloads.
  • A badly formatted spreadsheet can be hard to understand and use. Good formatting can make a spreadsheet easier to use and improve understanding and decision-making. In this video, I show you some valuable formatting tips and tricks as well as a quick data analysis.
  • Data are necessary for all spreadsheets and it is essential to enter the data efficiently to save time and reduce the risk of error. This video shows you some valuable data entry tips and tricks.