Professor Excel
hide, zeros, zeroes, excel

Hide Zero Values in Excel: 3 Simple Methods

There are many reasons why you might want to hide zero values in Excel. For example when working with cell links, Excel shows a 0 even if the source cell is blank. Or because it might look more professional. Whatever reason you have, there are different methods for hiding zero values. Depending on the scope (for example one worksheet or just selected cells), different methods are most suitable. In this article we explore 3 methods of hiding zero values in Excel and compare them.

[…]

if, iferror, ifna, ifs, thumbnail

IF Formula in Excel: Everything You Need to Know

The IF formula is one of the most useful formulas in Excel. It is highly adjustable and can be extended by other formulas easily. But many Excel users don’t really know all it’s secrets. Do you know how to use it? This article covers everything you need to know about it: How to use it, how to extend it and how to use the related formulas IFNA, IFERROR and the new formula IFS. […]

space, remove, blank, cell, excel

Space Character: Remove Last Letter in Excel If It Is Blank

Does this situation sound familiar to you: You compare texts in Excel and they should be equal. But instead, Excel says the two cells are not the same. Oftentimes, there is a hidden space in the end of a text cell. Very troublesome: You can’t really see it because the blank character is at the end of the text. In this article we explore 4 methods of how to remove the last character of a text in Excel if it is a space. 

[…]

save, save as, excel, pdf, xlsx, sheet, worksheet

Save as PDF or Excel File: The Complete Guide

Admittedly, it sounds like a basic topic: Saving Excel files. But besides saving complete workbooks, there are a lot of potential improvements and methods for saving time. How do you for example save a workbook as a PDF file? Or how do you export single worksheets? Everybody probably has their own steps, but oftentimes there are faster and more convenient ways. In this article we explore the best and fastest ways of saving your workbooks or separate sheets as PDF files or Excel files to your hard drive.

[…]

indent, level, indentation, excel, guide, how-to, return

How to Return the Indentation of a Cell in Excel

Sometimes, you receive data which is organized by indentations. For example in an Excel table, the Total has no indentation whereas all single values are indented. This could be (typically…) the case for tables provided by some controlling tools. How to deal with that? What do you do if you want to sum up all values with the indentation level 1?

[…]

sharing, excel, complete, guide, email, post, mail

Sharing in Excel via E-Mail: The Complete Guide

A topic which concerns probably all Excel users: Share workbooks and single worksheets via e-mail. Everybody probably has their own steps, but oftentimes there are faster and more convenient ways. In this article we explore the best ways of attaching your workbooks or separate sheets as PDF and Excel files to a new e-mail.

After finishing the work on a workbook, you often want to share it with your colleagues. E-mail is still the most common communication tool. So let’s take a look at how to send your Excel workbook as PDF or XLSX files via e-mail most comfortably and fast.

[…]

round, roundup, rounddown, excel

ROUND: How to Round Values in Excel

Today we talk about a basic topic in Excel: Rounding numbers. Excel provides three different versions of formulas for rounding number: ROUND, ROUNDUP and ROUNDDOWN. ROUNDUP and ROUNDDOWN always round numbers away or towards zero. In this article we take a closer look at the ROUND formula and explore advanced ways of applying it.

[…]

minif, maxif, minifs, maxifs, formula, excel

MINIF & MAXIF: 5 Ways to Get a Conditional Minimum Value

Until Excel 2016, there is no built-in MINIF-Formula in Excel. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version. However, there are situations in which you need to get the minimum under a condition. In the following post, we are going to illustrate how to return the minimum using a simple example. We got an Excel table with two columns “Car type” and “Price”. We want to know the minimum price for each car type. Sounds easy? Unfortunately, Excel makes it unnecessarily difficult to calculate.
[…]

speed, up, excel, performance, calculation, speeding

Speed up Excel in 17 Easy Steps and Calculate Faster (+Download)

Excel is a great tool for performing complex calculations. Unfortunately, the larger an Excel spreadsheet gets, the slower the calculations will be. Depending on the formulas, size of the workbook and the computer, the calculations may take up to 30 minutes. In this article, we take a look at 17 methods to save time and speed up Excel. […]

IFERROR: How to Handle Error Messages in Excel

When your formula produces an error in Excel – for example #N/A or #VALUE? – you got two options: Solve the error or use it in your calculation. Solving is usually a good idea but not always possible. So let’s take a look at how to deal with errors in Excel formulas using the IFERROR formula.

[…]