If you want to see where your Excel file is located on the computer or the server, you can display the file path in the Quick Access Toolbar. With the file path displayed here, you can also copy and paste it into an e-mail and send it to a colleague (provided they have access to the same server). A great way to avoid sending attachments!
You only have to do this once – if you add something to the Quick Access Toolbar, it will be displayed in every Excel document on the same computer.
READ MOREEven if you have never used Microsoft Excel before, it only takes 5 minutes to learn how to make a simple report. Once you have done the exercise below, you will be able to create your own sales reports, commission reports, or household budget.
In this post we will create a sales report in 5 steps. You will be amazed by how easy it is!
Let’s get started!
If you work with Excel all the time, you are probably pretty tired of switching between the tabs using the mouse. To make your life easier, learn this Excel keyboard shortcut:
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.
Is it possible to create a search box in Excel, without using VBA?
Yes, and it’s easy!
We will use Conditional Formatting to highlight the fields that match the search string. For example, if you look at the table below, we want to highlight row 8, 11, 15 and 25 if we search for “RG”, because “RG” is part of the product name in those rows.
READ MORE
Have you ever imported data into Excel that won’t calculate? Look at this example where the earnings look like numbers to the human eye, but not to Excel. And when Excel is not able to identify any numbers, it can’t calculate any sums or averages either.
This happens all the time if you use data from other data sources: It could be a txt-file from a booking system, a copy-paste from a website or even a database export.
Enough about the problem. Let’s solve it, and let’s not spend more than 2 minutes doing it!
