Free Excel Tips, Tricks & Tutorials

Download one of the free templates in the table below. Having problems customizing it to your needs? Post a question on the forum or email e.i.kooi@excelltricks.com

Dowload one of the freely available invoice templates in the table below. Problems customizing it to your needs, ask a question on the forum or send an email.

Learn how to create an excel-spreadsheet that contains all kinds of buttons that interact with your data. The tutorial shows how to create a registration form.

Excel provides the easy-to-use macro recorder that allows you to automate standardized tasks. Learn how to record your own macro, or download a macro from the web, and run it in your worksheet.

Make a scatterplot in three dimensions! Looks very cool on power point presentations.

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.

You can define groups and make calculations on parts of your data.

Waterfall charts can be useful in displaying the profits and losses at certain key decision moments in time

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