Custom Number Formatting
When you have numerical values in your worksheet, and you want to format them in a specific way that is not present in…
Category: training
Undo and Redo
When you work with a worksheet, Excel records every change you make. For example changes in cells, cell and text formatting, cutting, copying,…
Insert Rows and Columns
It’s hard to plan everything in advance, so sometimes you may want to insert a new column (or row) between the existing ones….
Adding Numbers Using the SUM Function
You don’t have to use the SUM function if you want to sum numbers. But when you use more complicated calculations you may find it…
History of Spreadsheets
Since the very first spreadsheet called VisiCalc was released, a lot has changed in the world of spreadsheets. Below, you will find some…
AutoCorrect
As soon as you start typing text in your worksheet, the Excel AutoCorrect feature monitors every move you make and corrects minor errors,…
The Macro Recorder
A popular method to create a macro is to use the Macro Recorder. When you use this tool, you show Excel (by clicking on…
AutoComplete
When you work with worksheets, sometimes you will need to enter the same text multiple times. To automate this task, Microsoft introduced the AutoComplete feature….
Currency and Accounting Format
When you work with monetary values, there are two different formats you can use: Currency and Accounting. You can find them in HOME >> Number >> Number Format….
Introduction to VBA
In the ever-growing world of data analysis, efficiency is king. This is where VBA (Visual Basic for Applications) comes in. VBA is a…