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

Posted On

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…

Posted On

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…

Posted On

Hyperlinks

A Hyperlink is a text, which references to a particular place. It is usually highlighted and underlined in a way that it can…

Posted On

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…

Posted On

Variables

Because VBA is a programming language, it shares common principles and elements with other languages. Ones of them are variables. A variable is…

Posted On

Constants

If you need to use the value that never changes, it will be wise to use a constant instead of a variable. When…

Posted On

Loops

VBA, as well as other programming languages, offers loops. Looping is an operation of repeating the same block of code multiple times. Excel…

Posted On

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…

Posted On

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…

Posted On