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,…
Category: training
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…
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…
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….
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…
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….
Removing Duplicates in Excel
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 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…
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…
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….