Fresh Excel Tips

In the example, a worksheet lists offers from different suppliers. To make a decision as to which is the best offer, the SMALL function can be used to check for the lowest price. As in our previous tip, you can use the INDEX and MATCH functions to get the names of the companies. To find out [...]

A quick and easy way of figuring out which dates fall on the weekend is by using the WEEKDAY Function in Excel. Another way to tackle this is to use the method explained in our previous article that can be found HERE. The WEEKDAY function returns the day of the week as a number corresponding [...]

Excel provides many formats for presenting numbers, dates, times, currencies, and other types of information involving numerals.However, if the preset formats don’t match your specifications, you can also create custom formats for specific purposes. Sometimes you’d like to included parentheses when formatting the area codes of telephone numbers. Creating custom formats requires that you use number [...]

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 [...]