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.
LOOKUP: Everything You Should Know about the Very Unknown Excel Formula
Besides the well-known VLOOKUP formula, there is a similar formula in Excel: LOOKUP. The formula is very unkown and hardly used. But there are good reasons why you should not use the LOOKUP formula. Let’s start with the basics about the formula and then talk about why you should avoid it.
Circular References in Excel: How to Find, solve and Calculate Them
You opened an Excel file and it immediately showed an error message saying that there is a circular reference. What to do now?
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.
Dictionary for Excel Formulas
Microsoft Excel supports many languages. In total, you can use Excel in 107 different languages. Many of these languages also use local formula names. For example, VLOOKUP is called SVERWEIS in German, BUSCARV in Spanish or DÜŞEYARA in Turkish. Fortunately, you don’t need to remember different formula names because Excel automatically translates the formulas to your language. However, in some cases you need to know the local formula term. Please refer to our comprehensive dictionary below.
LEN Formula: Get the Number of Characters in Excel
You need to know how many characters does the cell contain?
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?
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.
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.
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.
Professor Excel Newsletter
- The best Excel tips, tricks and tutorials.
- 1x per month.
- No spam. Promised.
Your welcome gift:Save a lot of time with our 45-pages keyboard shortcut package.
Book: Speeding Up Microsoft Excel
Do you sometimes use passwords for Excel workbooks? Save them where you need them: In Excel!
More information
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Overview | Features & details
Excel Shirts and Accessories
Check this out:
Try our free apps:
Professor's Daily Tips for Excel: Get one free Excel tip every day.
Professor's Error Helper for Excel: Solve any error in Excel.
Also Interesting:
Top articles:
Excel tips, tricks and tutorials.
1x per month.
No spam. Promised.
