In today’s business world, there is hardly any Excel workbook not using currencies and exchange rates. Example: When I want to know my revenue for the last month – let’s say of my Excel add-ins or books – I receive an Excel file containing data in various currencies. Because I’m located in Germany, I want to… Continue reading Currency Conversion in Excel: Tutorial + Free Excel Add-In
Category: General
Histograms in Excel: 3 Ways to Create a Histogram Chart (+Download)
A histogram chart is a great way to present your data. It groups your data into bins or classes and shows the number of items per bin. For example: Your data has “Big Mac” prices in different countries. A histogram shows how many countries have a Big Mac price between 1 and 2 USD, 2… Continue reading Histograms in Excel: 3 Ways to Create a Histogram Chart (+Download)
Change Thousands & Decimal Separators in Excel, PowerPoint and ThinkCell
Sometimes you don’t want the comma “,” as a thousands separator, but rather a full stop “.”. Or you don’t want the full stop as the decimal separator. Changing these two separators in Office is easy: You can either do it system-wide or override the system settings.
How to Hide Gridlines in Excel: 6 Expert Methods!
The light grey gridlines are quite useful. They provide a quick impression of the rows and columns of your Excel worksheet. But once you want to create your final layout, they look annoying. Your worksheet looks more professional with hidden gridlines.
Excel FAQ: The Most Frequently Asked Questions – Big Guide!
There are many annoyances and troubles in Excel. Most of them you can easily fix. For example: You can’t scroll up and down. Or the formula bar is gone. Or you can’t group and ungroup rows and columns. The problem: Often it’s not very intuitive to find the right button or setting. Check our comprehensive… Continue reading Excel FAQ: The Most Frequently Asked Questions – Big Guide!
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 XLSM, XLSB or “older” Excel users might still remember the XLS file type. What are the differences of these file types? And even more important: Which one should you use?
XML & ZIP: Explore Your Excel Workbooks File Structure
Did you know that Excel files are actually a zipped collection of XML files? You can easily explore and edit the complete structure of your Excel workbook. All you have to do: Rename and unzip the .xlsx file. Let’s take a look at it.
Study: What Really Helps to Reduce the File Size of Your Excel Workbook
You have just finished your work and want to send your file to your boss. He is waiting for it. But instead of sending the email, you just receive and error: The file size is too large. This is the moment you tell yourself not to panic. And actually there is no reason to panic.… Continue reading Study: What Really Helps to Reduce the File Size of Your Excel Workbook
Increase Calculation Performance in Excel: Change the Region Settings!
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… Continue reading Increase Calculation Performance in Excel: Change the Region Settings!
Rename Excel Worksheets: Easy with Tips & Tricks and Methods!
You have to rename several worksheets in Excel? Renaming a worksheet can be troublesome, especially when you have to double-click on each sheet name separately.