VBA Data Types
VBA can take care of data types automatically, but it does it at a cost of speed and memory. When your application grows,…
Tag: to check
Excel features
Excel has been the most popular spreadsheet for almost three decades, much longer than all of his predecessors put together. Below, you will…
Column Chart
The most popular chart in Excel is Column Chart. It is located at the top of the chart list. The data in the column…
Insert rows and columns
It’s hard to plan everything in advance, so sometimes you may want to insert a new column (or row) between the existing ones….
History of Spreadsheets
Since the very first spreadsheet called VisiCalc was released, a lot has changed in the world of spreadsheets. Below, you will find some…
Currency and accounting format
When you work with monetary values, there are two different formats you can use: Currency and Accounting. You can find them in HOME >> Number >> Number Format….
Introduction to number formatting
If a cell is not formatted to a particular type, Excel will read that value and try to guess what format should it…
