Create an Excel Investment Portfolio Tracker Template

Excel has has improved much since the early day when I started using Excel 2003. With the latest Office 365 update, you can now use the stocks feature to import live stock information. In this tutorial, we will be learning how to build the a Investment Portfolio...

How to Copy and Paste Only the Visible Cells in Excel

In general, when you hide rows or columns or rows and columns, and you are trying to copy just the visible cells in your table to somewhere else, instead of copy just the visible cells on your table, Excel is going to copy everything.In this tutorial I will be showing...

Conditionally Change a Symbol Based Different Values

In Excel, you can insert different symbols using the Webdings, Wingdings font styles. But a major drawback using those font styles is, if a user change the font style to something else, the symbol will then disappear. In this tutorial, I will show you an elegant way...