Excel 2016 new features

With every release of the Office suite, Microsoft introduces a number of new features. In this lesson, I’ll show you the most important…

Posted On

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

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

Spell 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