Professor Excel

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

[…]

excel, free, use, no cost, microsoft, office

Excel for Free: 5 Ways of Using Free Spreadsheets

The Office Suite which contains Excel is one of the major revenue source for Microsoft. That said, it’s also understandable that Microsoft Office is not available for free. But there are some legal ways to open and edit Excel files. In this article we introduce you to 5 ways to work with Microsoft Office files for free. […]

print, excel, sheets, worksheets, printout, page, layout, guide

Print Excel Sheets: No More Trouble When Printing

It’s a nightmare: Printing Excel sheets. You permanently feel like Excel hates you when you want to print an Excel sheet. That said, let’s take a look at the basics (like defining the print range) as well as advanced topics (like changing headers and footers on several sheets simultaneously). 

[…]

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.

[…]