Professor Excel
thousands, millions, excel, display, cell, format

Thousands or Millions in Excel: How to Change the Number Unit

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.

Adjust Rows and Columns in Excel: The 4 Best Ways!

Do you spend a lot of time changing the column width in Excel? On the one hand, you’d like to see as many columns as possible for having a good overview, but on the other hand, you want to see as much content as possible within a column. In the worst case, you’d only see ### instead of values.

combine, chart, types, excel

How to Combine Two Chart Types in Excel

Creating charts in Excel is quite easy: Select the data and choose your desired chart type on the ‘Insert’ ribbon. But when it comes to combining two chart types – for example a column chart with a line on top – many users suddenly struggle. But actually, it’s almost as simple as inserting a normal chart. Let’s have a look at how to do it and how to further adjust your chart. […]

See and Change the Data Source of a Pivot Table in Excel

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 Only Paste Cells Formats

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 Insert Rows and Columns

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 Get the Week Number in Excel

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.

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.