Every Excel file has metadata. According to Wikipedia, “Metadata is data [information] that provides information about other data”. That means, metadata is some data which is not your content of your file but rather information like the author name, data saved or even the file name. Or in other words: If your Excel file is a letter… Continue reading Metadata in Excel: 6 Methods of How to See and Remove All Meta-Data
Excel has a useful feature: Named Ranges. You can name single cells or ranges of cells in Excel. Instead of just using the cell link, e.g. =A1, you can refer to the cell (or range of cell) by using the name (e.g. =TaxRate). Excel also provides the “Name Manager” which gives you a list of… Continue reading Named Ranges in Excel: See All Defined Names (Incl. Hidden Names)
You want to know the weekday of a certain date? Excel provides the WEEKDAY formula. The WEEKDAY formula returns the day of the week as a number, for example 1 for Sunday, 2 for Monday and so on. You can modify, which weekday starts with one.
You have to rename several worksheets in Excel? Renaming a worksheet can be troublesome, especially when you have to double-click on each sheet name separately.
There are many cases, in which you want to show the sheet name or file name in an Excel cell. Don’t worry, you don’t have to use VBA and create a macro. Excel provides a (rough) formula for returning all the information you need. The bad news: In most cases it takes some complex modifications. The… Continue reading File Name, Sheet Name: Easily Insert File Data in Excel!