Professor Excel

Precedents and Dependents: Easily Trace Related Cells in Excel

Let’s assume the following situation: You receive an Excel file from your colleague and have to understand it as quickly as possible. How do you start?

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?

[…]

calculation, options, calculate, manual, automatic, excel, thumbnail

Calculation Options in Excel: Decide When and What to Calculate

Does this sound familiar to you: Excel takes too much time calculating. Instead of instantly showing the results, you have to wait for several seconds or even minutes for Excel to finish up the calculation. The problem: The larger your Excel model gets, the more you get frustrated by the lack of performance.

[…]

speed, up, excel

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 15 methods to save time and speed up Excel. […]