Guides & Tutorials

The good thing about Automatic Table of Content is that you can effortlessly update it automatically to reflect changes in the document without typing anything as in when you are …

Here’s the situation: You’ve spent hours working on this project. Finally, you’ve finished compiling your project in a Microsoft Word document. You realized that the document was too long not …

In some cases, you may want to hide certain columns in Excel. This is particularly useful if you don’t want your spreadsheet users to see particular information or if you …

In some cases, you may want to hide certain rows in Excel. This is particularly useful if you don’t want your spreadsheet users to see certain information or if you …

There are several methods one can use to insert multiple rows in Excel. But first, you need to know how to insert a single row in Excel. Option 1: To …

There are several methods one can use to add a column in Excel. Below explain these methods. Option 1: To add a column in Excel: Find the column where you …

In this guide, you’ll learn every tip you need to know about Excel rows and columns. including how to delete or insert new rows and columns, how to adjust column …

Just before you begin reading this guide, let me inform you that this Excel Petty Cashbook tutorial is the ultimate guide. This means that I’ll try my best to exhaust …

A quick Steps on how to apply accounting number format in Excel: Step #1: Highlight the cells you wish to format Step #2: Go to Home→Number→Accounting Bonus: Alternatively, just click …

Before we begin, make sure to download the left lookup example file below: VLOOKUP is very useful for finding and retrieving related information in a table (or dataset). This function …