Professor Excel
region, settings, excel, calculation, speed, time, performance, study, analysis

Region Settings: Big Impact on Excel’s Calculation Speed

In our large analysis of how to speed up Excel, we’ve found an interesting fact: Changing the region settings of your computer has a big impact on the performance on Excel calculation. Unfortunately, finding this left us with more question than answers. That’s why we further investigated: Which region formats let Excel calculate faster? What is the reason? And what does it mean for you?

[…]

Performance of Excel: Study Shows How to Speed up Excel by 81%

There are various advice about how to speed up Excel. Also we’ve published an article about how to increase the performance of Excel (actually it’s our most read article). But we’ve asked ourselves: Which of these advice really help? Furthermore: How much time can you save with it? That’s why we measured how long Excel calculates under different conditions.

We found some surprising results.

[…]

force, cell, format, formatting, text, number

Force Any Cell to Your Desired Format in Excel

You are changing the cell format, for example from “text” to “number” and nothing happens? Or the other way around, you want to enter a phone number but Excel automatically converts it to a number? Unfortunately, Excel is very unpredictable when it comes to text/number formatting. Here is what you should do in order to force Excel to accept your desired format.
[…]

recover, autorecover, autosave, period, restore, work, file, delete

Recover an Excel Workbook After Crashing or Deleting

Let’s start with the bad news: The probability is high that your workbook is gone when you are reading these lines. But there are some steps you could try to recover it. It might be worth starting with the AutoRecover function and then – as long as unsuccessful – trying other steps.

[…]

3d, 3 way, lookups, 3d lookups, excel

3D Lookups in Excel: 6 Methods (+Download)

The king of lookups in Excel: The 3 way- or 3D lookup. Imagine this scenario: You got several Excel tables, each has rows and columns. Depending on your input values, you want to get the data from a specific cell from the right table, row and column. Such lookups are called 3D lookups or 3 way lookups. In this article we explore 6 methods of how to conduct 3D lookups in Excel.

[…]

emoji, emojis, excel, insert, cell

Emojis in Excel: How to Insert Emojis into Excel Cells

You’ll probably have a good reason for it: Inserting emojis or similar symbols into an Excel cell. Before we start we should probably mention the bad news: the emojis you have on your mobile phone are only possible to insert on a Mac. On a computer running Windows 8 or later you can insert an emoji, but it looks ugly. If you are still running a Windows PC with Windows 7 or earlier, there are similar symbols available.

[…]

sort, horizontally, horizon, left to right, left, right, sorting, excel

Sort Horizontally: How to Sort Data Left to Right in Excel

Today, we got a quick tip for you: Sort data left to right. Most Excel users don’t know that it is possible to sort horizontally. Admittedly, the option is a little bit hidden in Excel. But once you know it, it’s not a big deal.

[…]

2D Lookups in Excel: 4 Easy Methods for 2 Way Lookups + Excel Download

There are many cases in which you need a 2 dimensional lookup. That means, if you want to get a value from a specific row-column combination with neither rows or columns fixed. Unfortunately, the problem of a two way lookup comes up quite often. In this article we explore 4 methods of how to conduct 2D lookups in Excel.

[…]

file, size, reduce, workbook, excel, smaller, too big

How to Reduce the File Size of an Excel Workbook

Excel workbooks usually have an acceptable file size. But sometimes, they are unreasonably large. There are several reasons for a big file size coming with different ways of how to reduce it. Depending on the contents of your Excel workbook some methods will work better than others. So, let’s try them one by one.

[…]

Hyperlink: 3 Ways of How to Extract the Link from an Excel Cell

Sometimes, you copy webpages. Or just a links. Or you receive an Excel sheet with links in it. In such case, you often want to extract the hyperlink addresses from the cells. There are basically just three options for getting the hyperlink address from an Excel cell. […]