Status Bar Shows a Wrong Result (Sum, Average) – Here Is Why
Excel has a very handy feature: It displays some quick information about the selected cells in the status bar. This might be the sum, average, maximum or minimum value. Unfortunately, in some cases, the shown number seems to be wrong. Here is why!
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?
Bullet Points in Excel: 6 Easy Methods (+Download)
No matter if you use Microsoft Word, PowerPoint, Outlook or OneNote: You can easily insert bullet points and create bullet point lists. In Excel you can’t. But there are some simple workarounds. In this article, you learn 6 methods for inserting bullet points in 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.
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?
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:
- Status Bar Shows a Wrong Result (Sum, Average) – Here Is Why
- Currency Conversion in Excel: Tutorial + Free Excel Add-In
- Bullet Points in Excel: 6 Easy Methods (+Download)
- Text Import Wizard Gone? How to Import CSV and Text Files in Excel
- LOOKUP: Everything You Should Know about the Very Unknown Excel Formula
Top articles:
Excel tips, tricks and tutorials.
1x per month.
No spam. Promised.
