Excel File: https://www.teachexcel.com/excel-tutorial/2055/6-tips-to-quickly-clean-data-in-excel?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt
After viewing this tutorial, you will be able to perform useful time-saving data ...
Excel File: https://www.teachexcel.com/excel-tutorial/2032/vlookup-across-multiple-workbooks?src=yt
The vlookup function is a great tool for searching through a table of data and it can be used with data on the same worksheet, in the same workbook, or on...
Excel Prank for Halloween! Create a Halloween colored light show on your worksheet tabs.
How to create a macro, that will run every time someone changes the worksheet tab that they are using, that will create a little black and ...
Prank your co-workers in Excel by making their data jump around the worksheet when they try to click on it.
This is a great prank that won't mess-up any data but should provide you with a good laugh.
If you try this prank, make ...
I explain what a Macro in Excel is, why you might want to use Macros in Excel, and I give you a simple example of a Macro and of the VBA code that was used to create it.
For more: http://www.teachexcel.com...