You are creating an Excel sheet, in which another user has to enter text data (for example, the name of a person or a place). Such texts can be misspelled easily. To prevent misspelling, you can provide drop-down lists, from which the user can select. The user can also simply type text, but the text has to match exactly one of the items on the list.
Once your calculations are done, you might want to show your results in charts. Charts are a good way of getting a feeling of the values and leading to conclusions.
When you print a large table, you can select rows or columns which you want to repeat on each page. This way, the data is easier to read as the heading will be printed on each page.
Data Tables were introduced in Excel 2007. They were supposed to simplify the work with data in Excel. But in the reality they often made it more difficult. For example, handling different formulas in the same column is not really possible. Fortunately, you can easily convert a Data Table into a normal range.
Besides the normal Filter, there is a advanced Filter in Excel. What does the advanced Filter do?
You have copied data from a large table on a webpage and pasted it in Excel, but the data is only shown in one column instead of a table? Or you simply want to separate names at every space character? These (and many more) problems could be solved with the “Text to Columns” function.
There are many worksheets in your workbook, which are old but you are afraid to delete them?
Let’s assume, we have the following (although realistic) challenge: We got two lists which should have the same items in Excel. But they aren’t exactly the same so that we need to compare them. But how do we find out the best way, which items are missing in either one of the lists? Instead of comparing… Continue reading How to Compare Two Lists in Excel