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 [...]
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.
Duration : 0:4:19
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.
Expert: Dave Andrews
Contact: www.daveandrews.org
Bio: Dave Andrews is a software developer that holds a degree [...]
If computers keep getting faster, why does our work take so long?
After I created this video, I was alerted to the existence of Solow’s Productivity Paradox, which deals with the apparent discrepancy between technology investment and productivity.
I’ll give full credit to Solow, but please allow that I’m referring to productivity on a very personal level. [...]
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.
VLOOKUP and Web Query and Data Validation
Formula and functions
Duration : 0:5:18
Generate T-SQL statements with Excel.
Duration : 0:1:13
