Fresh Excel Tips

Custom code, when using Excel and VBA, is written in functions and subroutines. We will be attaching our custom code to Excel’s main program and invoking our code within cell formulas or in response to certain events that occur inside Excel. One of the main things you need to remember is that the VBA procedures [...]

One way to speed up your Excel usage is by using the Excel Quick Access toolbar. Your most frequently used features can be added to the Excel Quick Access toolbar allowing you to access certain commands with a single click. By Right-clicking a Ribbon command, you can add it to the Quick Access toolbar quickly [...]

In Excel, you can name individual cells and groups of cells, called ranges. A cell named Tax or a range named Northern_Region is easier to remember than the corresponding cell address. You can use named cells and ranges directly in formulas to refer to the values contained in them. When you move a named range [...]

Constants are used whenever you want to use the same value in different cells and/or formulas. By using constants, you can refer to a any value by using only the constant’s name. You can use constants in a wide variety applications and settings. For example, interest and tax rates are familiar constants that are regularly [...]

One of the more useful features in Excel is the ability to name individual cells and groups of cells, called ranges. Of course, assigning a name to your own cells will be much easier to remember than the corresponding cell address. One of the beauties of doing this is that you can use named cells and [...]