## TODAY: How to Insert the TODAY Function in Excel

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()

## Data Source of PivotTables: How to See and Change It

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?

## How to Paste Cell Formatting Only in Excel: 2 Easy Methods!

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.

## How To Quickly Insert Rows And Columns In Excel

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?

## How to Insert the Week Number in an Excel Cell

You might want to use numbers of weeks especially when you create timelines, schedules or calendars. The formula is called WEEKNUM().

## How to Save an Excel File Comfortably to PDF

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.

## How to Use the IF Formula in Excel

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.

## How to Unhide All Rows or Columns in Excel at Once

Many people love the “Hide” function for hiding rows or columns, as it is very easy to use:

## Sort: How to Sort Data in Excel

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.

## Clear All: How to Also Delete Formatting in Excel

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?