Fresh Excel Tips

Sometimes, there are certain formulae that we work with that change on a daily or weekly basis, especially when using VLOOKUP. For example, a filename may change on a daily basis according to the date. If you have a lot of formulae working with then you can change them in one operation by selecting the [...]

Excel, like Word, allows you to select from hundreds of special characters, such as foreign letters and currency characters such as the Euro (€) that are otherwise not available from the keyboard. Symbols and special characters serve many uses in Excel, especially in financial applications that call for some of these special symbols. They are [...]

In Excel, Data Entry Rules can be used to restrict data that is entered to ensure that it is in the correct format. That data can be restricted to just whole numbers, decimals, dates, times or even a specific length. Also, you can specify whether the values need to be between, not between, equal to, [...]

One relatively unknown feature of Excel is the ability to let it read values in a worksheet back to you. If you have a large amount of data to enter, especially numbers, this can be an incredibly useful feature that will help to ensure the accuracy of the data that was entered while you match [...]