You want to display today’s date? Or you want to check, if a date written in a cell is today? There is an easy formula: =TODAY()
You receive an Excel workbook with a Pivot Table and don’t know what data it is referring to? Or you have added a column or row to your data and want to adapt the Pivot Table?
Formatting an Excel table often takes more time than creating its contents. Borders, background colors, fonts and so on must be set to match your workbook and maybe even company guidelines.
Let’s enhance your Excel skill with some handy keyboard shortcuts: How to insert a new row (or column) within 1 second without using the mouse?
You might want to use numbers of weeks especially when you create timelines, schedules or calendars. The formula is called WEEKNUM().
When you save an Excel file to PDF, you usually go to File, Export, Create PDF/XPS and follow the steps. Let’s have a look at how to add a button to the Quick Access Toolbar so that it’s only one click to save PDF, instead of searching through the menus.
The IF formula is very useful in many different cases. It checks if a condition is true and performs defined steps, depending on the result. The IF formula is highly adjustable and can be extended by other formulas easily.
Many people love the “Hide” function for hiding rows or columns, as it is very easy to use:
There are several ways to sort data: Using filters, Pivot Tables or the built in Sort function. The sort function has the advantage that it’s easy to use and can be modified in detail.
The “normal” way to delete the content of a cell is by pressing “Del” on the keyboard. But what if you want to delete the formatting and comments as well?