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,…

Posted On

Subtract in Excel

Subtraction is a simple arithmetic operation used on an everyday basis. So this should be a very short lesson. Instead, I would like…

Posted On

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…

Posted On

Variable Scope

In VBA, there are three different scopes of variables: procedure level, module level, and public level. Each scope determines the place where the variable is visible….

Posted On

Pie Chart

A good way to use a pie chart in Excel is when you want to show relative proportions to a whole. A pie…

Posted On

Align Data in Cells

You can align data in cells both horizontally and vertically. Depending on the data you insert inside a cell, Excel aligns it differently….

Posted On

Comments and Notes

Comments in Excel can be used to describe different cells in a worksheet, without changing their contents. You can use comments in many…

Posted On

Spelling Checking

Spell checking is well known to those who work with text editors, such as Microsoft Word. Because you use text not only in…

Posted On

Slicers

Slicers were introduced in Excel 2010, but then they could only be used with PivotTables. In Excel 365 you can also use slicers with standard tables….

Posted On