If you have dates that you want to convert into a quarter, you may have realized that Excel does not have a function for it. Therefore we will show you an easy formula that you can use in Excel to convert date to quarter. You don’t have to calculate a quarter from date in Excel …
If you want to make a list of items in Word, then you want to use bullets. Bullet points give a summarized overview. This article shows you how to add a bullet point in Microsoft Word. There are several symbols that you can choose from to make a bulleted list. You will learn how to …
If you want to make an intuitive reference to an image, you can insert a caption. You can quickly add a caption to a picture or photo in Word by using the Insert Caption function. Word will automatically number your captions of tables or figures. However, sometimes the caption numbering of the figure is incorrect …
Maybe you have tried to make a list of names or titles, but you did not manage to put them all in alphabetical order. It is time-consuming to arrange a list in alphabetic or numerical order manually, but that is unnecessary. Instead, you can learn how to sort a list of names alphabetically in Word …
You have inserted a header and footer in your Word document. Somehow, Word is not showing the header and footer in your document anymore. Not only has the header and footer disappeared in Word, but also the top and bottom margins of the document. Don’t worry if the header and footer disappear in Word 2013 …
This article will show you different ways to write text vertically in a Word document. You will be able to change text directions or the orientation of text in Microsoft Word. It is easy to write text vertically in Microsoft Word and Excel. Read the steps of how to create text vertically in Microsoft Word …
In the previous article, you learned how to add a border around a range of cells in Excel. Did you know that you can also create a custom cell style in Excel? You will learn to create and insert a custom border around cells in Excel. You will also learn another way to add a …
An Excel worksheet consists of multiple cells that are divided by gridlines. If you want to learn how to add a border to a range of cells in Excel, you should read this article. You will learn how to insert, create and remove a border in Excel. We will start to create a border around …
In the previous article, you learned how to create a table in Excel with headers. Now we will show you how to format a table in Excel, which is almost the same. In this tutorial, you will learn how to remove table formatting in Excel 2016 or later. If you remove a table format in …
Excel table is useful as you can organize and analyze data quicker. You can convert a data range into a table with features like filtering and sorting. It is straightforward to create a simple table in Excel by using a shortcut. This tutorial shows you how to create an Excel table with data and headers. …