HowTech

Microsoft Excel allows you to do calculations using formulas and functions. With the use of these formulas in excel you can easily calculate anything. There are some built in functions that you can use or you can use your own formulas as well. There are over three hundred functions in Excel. A function is a pre made formula so you can directly enter it by writing the name of the function and the rest of the formula will be showed to you automatically.
To learn in Microsoft Excel to how to use formulas and functions follow the tutorial below.

You can hide a column and hide a row in Excel easily of you do not require that data for the time being. Such data can be removed from view and can be brought back anytime as per your requirement.
You can also group data in Microsoft Excel that allows you to manage it better.
To learn how to hide and group rows and columns in Excel, follow the tutorial below.

Excel workbook has multiple sheets in a single workbook. You can add as many sheets in it as you like. In this tutorial we have worksheets which are exactly the same except for the values in them. While using Microsoft Excel if we want to make changes in all of them, instead of making changes in them one by one we can easily do that in one go.
Follow this step by step tutorial to learn how to calculate formula in excel across separate worksheets.

Microsoft Excel provides several levels of protection for your valuable workbooks by using passwords. However If you forget or lose your passwords, you won’t be able to undo the areas you protected by any normal means.
To learn how to set workbook permissions in Excel follow this tutorial.

When numerous users are working on an Excel spreadsheet, they may want to leave comments for the other user to see. This comment box comes in very hand in case you want to make a note and discuss it in detail with someone later. In this tutorial, we will teach you how to add comments, edit them and navigate through them.
In this tutorial, we will teach you how to insert and edit comments in Excel.

Many users avail the share features in Excel. In Excel, one can share workbook with other users. In this tutorial, we will teach you how to track changes these other users make in your Excel workbook. Highlight these changes, review them and then decide whether you want to accept or reject the changes.
In this tutorial, we will teach you how to share workbook and track changes in Excel.

In this tutorial we will be showing you how to join cells in Excel such that their data is combined into one cell which was previously present in two cells. People have a whole list of names of employees in their excel sheets. This can go up to several hundred or even thousands of rows. Suppose if you want to join or merge the data from two cells into one then it would take a lot of time. In order to do that you can use a formula that will do this step for you easily.
Follow this step by step tutorial to learn how to combine two Excel cells such that their data is combined into one.