Professor Excel

Text Import Wizard Gone? How to Import CSV and Text Files in Excel

Microsoft quietly replaced the comfortable Text Import Wizard from Excel and replaced it with the “Get & Transform” tools. The “Get & Transform” tools offer a lot of options and are very powerful. Unfortunately, they are quite complicated to use. Here is what you should now.

[…]

excel, powerpoint, chart, data, export, import

Export From Excel to PowerPoint: 3 Ways (Recommended Reading)

There are many ways to export a table or a chart to PowerPoint. They all have advantages and disadvantages. In the following we’ll take a look of one specific way: Copy as pictures.

custom, number, format, excel

Custom Number Formats: Big Guide, Popular Codes and a Free Download

Excel provides many default number formats. But often, these formats are not enough. For example:

Example: The default and a modifyed number format.

  • You want to display number in thousands or millions?
  • Or have a thousands separator for percentage values?
  • Or show a plus sign for positive values?

In such case, you need to create a custom number format. In this article, you learn everything you need to know. For making it easier for you, please feel free to download the example Excel file or the handy custom format card for printing it out.

[…]

Passwords in Excel: Everything about Locking and Unlocking Workbooks and Sheets

Excel is one of the most popular applications in the business life. No wonder, that there is lots of sensitive data saved in Excel workbooks and sheets. Excel provides methods to secure this data: By protecting them with passwords. But Excel also offers much more than just using passwords on complete workbooks: You can also protect contents on single sheets, areas on worksheets and single cells. In this article, you’ll learn all this: From protecting entire workbooks to single cells. Even better: You’ll learn how to unprotect them as far as possible.

[…]

excel, highlight, negative, color, red, minus

Easily Highlight Negative Values in Red Color in Excel

A good Excel table provides a quick overview of the most important facts and figures. One way of highlighting important numbers is by using colors. For example, values below zero should stand out.

Quick Access Toolbar in Excel: Everything You Need to Know

You probably know this situation: You just quickly want to use a function in Excel, but it takes you way too much time searching it within the menu bar. Admittedly, the ribbon structure of Excel can be quite confusing. But there is a solution: The Quick Access Toolbar. You can save the most important or frequently used buttons in this menu bar on top of the screen. That way, you can easily access your favorite functions. So let’s see how it works and learn some tips and tricks.

[…]

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.

[…]

select all pictures, excel, images, select, delete

Select all Pictures in Excel: 5 Easy Methods

When you copy something from a webpage and paste it into Excel, not only the text and numbers are pasted, but also pictures. As often as not, you don’t want to have these images, for example website logos, as they make your Excel file large and hide your data.