Category: training

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

VBA can take care of data types automatically, but it does it at a cost of speed and memory. When your application grows,…

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

Excel has been the most popular spreadsheet for almost three decades, much longer than all of his predecessors put together. Below, you will…

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

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

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

When we work with Excel, there’s often a situation where we have duplicate data in our worksheet. We can find and manipulate this…

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

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