You want to know the weekday of a certain date? Excel provides the WEEKDAY formula. The WEEKDAY formula returns the day of the week as a number, for example 1 for Sunday, 2 for Monday and so on. You can modify, which weekday starts with one.
Sometimes, you want to create random values in Excel. There is a simple formula to generate random numbers: RAND. If you type =RAND() into a cell, you’ll get a number between 0 and 1. So what do you do, if you want to have random number between 20 and 50 for example?
You’ve done some calculations in Excel but you aren’t satisfied with the result? So you ask yourself, how you could achieve the desired result. A good starting point for such analysis is the built-in Goal Seek function in Excel. It’s simple to use but yet powerful. On the other side, it does some reverse calculation and therefore has a reputation for cheating in order to achieve the target results.
You have to rename several worksheets in Excel? Renaming a worksheet can be troublesome, especially when you have to double-click on each sheet name separately.
When you copy something from a webpage and paste it into Excel, not only the text and numbers are pasted, but also pictures. As often as not, you don’t want to have these images, for example website logos, as they make your Excel file large and hide your data.
Dealing with text in Excel can be painful as the formatting is limited within Excel cells. One method of organizing text is to add line breaks.
The COUNTIFS function works similar like the SUMIFS function. But instead of adding up the values, it counts how many items with one or more criteria are in your table.
The “Conditional Formatting” button is hidden in the middle of the Home ribbon in Excel. Nonetheless, Conditional Formatting offers many options for visualizing your data. As the name already says, Excel can format your table depending on one or more conditions.
When you calculate with large numbers, you might want to only show the values as thousands or millions. Unfortunately, Excel doesn’t offer such option with a single click.
The SUMIFS formula adds up all numbers, when one or more than one criterion is fulfilled. SUMIFS only exists since Excel 2007 and is especially useful, as it can regard several search criteria.