Slicers
Slicers were introduced in Excel 2010, but then they could only be used with PivotTables. In Excel 2013 you can also use slicers with standard tables….
Category: training
Select Cells
Excel allows you to select cells in several different ways, using both the mouse and the keyboard. Selecting with a mouse by dragging…
Line Chart
The line chart is used to show trends in data. It usually has more data points than a column or bar chart, because…
Hyperlinks
A Hyperlink is a text, which references to a particular place. It is usually highlighted and underlined in a way that it can…
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…
Variables
Because VBA is a programming language, it shares common principles and elements with other languages. One of them is variables. A variable is…
Constants
If you need to use a value that never changes, it will be wise to use a constant instead of a variable. When…
Loops
VBA, as well as other programming languages, offers loops. Looping is an operation of repeating the same block of code multiple times. Excel…
Recover Files
Probably you’ve had to deal with a situation in which you forgot to save the file you have worked a long time. Maybe…
Developer Tab
The Developer Tab is an additional, hidden tab that can be useful when you write VBA code, especially if you prefer to work…
