The data en time values that a cell are a bit strange data types. They require you to know some of the useful date- and time functions provided in Excel. This tutorial shows how to create an Excel-sheet that keeps track off the attendence of your employees during a whole year and shows how you can make use of functions like DATE(), DAY(), NETWORKDAYS(), WEEKDAY(), WEEKNUM(), YEARFRAC() and more!
When your data set becomes bigger, you need are forced to use the right tools to do the job. This tutorial covers how you can more easily deal with large data sets in terms of importing data, filtering, sorting, removing duplicates, transposing your data set and more.
Especially when your spreadsheet gets bigger, it is very useful to make use of the various searching and referencing functions that Excel offers. One of the most popular search functions are VLOOKUP and HLOOKUP. Together with other searching functions, the use of VLOOKUP and HLOOKUP are explained in the video tutorial