http://www.TeachExcel.com
This tutorial shows you how to insert a macro you may find on the internet into your Microsoft Excel workbook or spreadsheet. This is a step-by-step tutorial which walks you through copying the macro from a web page to pasting that into a module, ThisWorkbook, or an individual worksheet. You will also learn how to view all the macros present in Excel and how to delete any macros from excel, including the module in which they were contained.
To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.
Have a great day!
Duration : 0:5:37
I use Excel as something of a simple database. I use it to keep track of movies, collectibles, etc. because I like the interface, the ease of organizing data, and the ability to filter data on-the-fly with AutoFilters and Sorts.
A database is used for storing large amounts of data, such as the addresses of every member of an organization. View data from a database in Microsoft Access with tips from a software developer in this free video on using Microsoft Access.
If computers keep getting faster, why does our work take so long?
See how to use a currency web query, and then link it to a data validation cell drop down list and a VLOOKUP formula that transforms a Balance Sheet from One Currency To Another.
Generate T-SQL statements with Excel.