Dec 18, 2019 | Excel, Excel General
In this tutorial, we are going to learn how to build a simple loan calculator application in Excel. If you ever wanting to take out a car loan or a mortgage loan, it is always a good to figure out how much interest payment over the periods of time based on the amount...
Jun 27, 2019 | Excel, Excel General
Believe or not, I have encountered this problem quiet many times – “How to get the count of unique items from a column from a table that has duplicate records or has multiple layers.In this tutorial I will show you how to use an array formula to get the...
Jun 10, 2019 | Excel, Excel General
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...
Jun 3, 2019 | Excel, Excel General
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...
May 29, 2019 | Excel, Excel General
It is normal for people to forget their password these days since there are so many things we need to track, Excel password is one of them. In this tutorial I am going to show you how to crack the Excel worksheet password without the need of using a 3rd party software...
May 2, 2019 | Excel, Excel General
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...