Posted in Excel tips

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

When you calculate with large numbers in Excel, you might want to only show the values as thousands or millions. 2,000 should be shown as…

Continue Reading... Thousands or Millions in Excel: How to Change the Number Unit
Posted in Excel tips

Merge Excel Files: How to Combine Workbooks into One File

You have several Excel workbooks and you want to merge them into one file? This could be a troublesome and long process. But there are…

Continue Reading... Merge Excel Files: How to Combine Workbooks into One File
Posted in Excel tips

Unhide All Rows or Columns in Excel at the Same Time

Let’s assume the following situation: You’ve received an Excel workbook from a colleague, client or anyone else but you have the feeling, that some rows…

Continue Reading... Unhide All Rows or Columns in Excel at the Same Time
Posted in Excel tips

XLSX, XLSM or XLSB: Which File Type Is the Best for You?

Probably 99% of all Excel workbooks are saved in the XLSX file type these days. But there are various other file extensions available: For example…

Continue Reading... XLSX, XLSM or XLSB: Which File Type Is the Best for You?
Posted in Excel tips

The Excel AND Function

The Excel AND function is used to check whether the value in a cell meets multiple stated criteria. The AND function can be found under…

Continue Reading... The Excel AND Function