Professor Excel
exchange, rates, excel, currency, currencies, conversion

Currency Conversion in Excel: Tutorial + Free Excel Add-In

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 convert everything to Euro. That’s when the trouble starts: Which exchange rate do I use for example for converting US Dollar to Euro? And more importantly: Where do I get the currency exchange rate in a convenient and fast way?

[…]

histogram, histograms, excel, chart

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 and 3 USD and so on. 

This article introduces three methods in Excel how to create a histogram. Please also feel free to download all examples in an Excel file.

[…]

thousands, decimal, separator, change, excel, powerpoint, thinkcell

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.

[…]

Excel FAQ

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 FAQ!

[…]

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, file, size, file size, reduce, excel, workbook, compress

Study: What Really Helps to Reduce the File Size of Your Excel Workbook

You’ve 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. There are many ways to reduce the file size of your Excel workbook.

[…]

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?

[…]

rename, excel, worksheets, name, sheets

Rename Excel Worksheets: Methods, Rules and Recommendations

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.

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 got 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.

[…]