Done in Excel 2013, (should work with previous versions), this shows how to do a look up of data stored in a grid. The example shows days of the week and seminars offered with #s of attendees.
In addition, learn a shortcut to name ranges and data validation using predetermined lists. The example shown is a small one yet can be used for large grids of data.
In this demo, learn how to add rounded values. This way when #s have less decimal pts, the #s will add up to the value of these #s.
This shows you how to create a database table in Access 2013. There are some slight changes in the updated version which are mentioned in this tutorial.
Done in version 2013, this will work with previous versions. This is a great way to deal with a data dump where you have a lot of text with too many spaces in between. A few other tips are also shown on how to sort it with the text to columns feature, copy/paste as only values.
This tutorial works with Excel 2013 (works with previous versions) and shows how to create a simple macro (this one will make a sheet landscape, create custom footers) and a demonstration of creating a button to put in the quick access toolbar.
This 11 minutes video covers a lot of territory…make sure you hit the pause button. This also works with earlier versions of Excel.