The formatting of text in Microsoft Excel is very similar to the layout in Microsoft Word. The commands in the Font group and the Alignment group are almost identical to the commands in the Font group and the Paragraph group in Microsoft Word. To format cells or cell ranges, we first select the cell (s). […]

Tutorial

I had already talked about it in the previous lesson, but what is a cell range and what can we do with this? A cell range are all, with the emphasis on “all”, side by side or non-adjacent cells, which are selected. This collection of cells is considered as a whole and is called a […]

Tutorial

Everyone will undoubtedly know how to select a cell in Excel, but I still want to show you a number of ways how you can do this efficiently. When you select multiple cells we speak about a “cell range”. “Reach” in short. To select a range whose cells are all next to, below or above […]

Tutorial

In Excel, we have the possibility to lock rows or columns. What do I mean by “locking”. For example, if you have a very long list, and you scroll down, you will no longer see the titles in the columns. No problem when all the data in the columns are clear. For example Name – […]

Tutorial

I had already told you in a previous lesson how to adjust the column width. In this lesson, we will discuss this in more detail. To adjust the column width, position the cursor between two column letters, and when it changes to a four-part arrow click a drag to the left or right. The column […]

Tutorial

There are three ways to create a new Microsoft Excel workbook. You can open a new, blank workbook when you launch Excel or by using the File tab to access Backstage view. You can open an existing Excel workbook, enter new or additional data, and save the file with a new name, thus creating a […]

Tutorial