Whenever you have to work with tons of numbers and make various calculations, use the sum function in Excel to make your task easy. You can also apply autosum in excel to make calculations for you. Furthermore in this tutorial, we will show you how to check these functions at a glance for any errors that might exist. Follow this step by step guide and master the sum functions that Excel has to offer.
In this tutorial, we will show you how to add numbers using Sum and AutoSum in Excel.

In Excel, there are more than 300 functions. There is one called the “if” function. It allows you to apply logical reasoning into the data and by that you can perform various tasks. It allows you to test an argument; the argument can either be true or false. We can apply a condition which will be tested. If it is true or false, different results will be shown accordingly. Such kind of logical tests can be applied by using the “if” function.
Follow this step by step tutorial to learn how to use if function in excel.

While working with spreadsheets in Ms Excel, using a variety of shortcuts and cell references can save you a lot of time. You can name cell ranges and use that name later on instead of typing out the range over and over again. Moreover, the cell names can also be used while entering a function or formula.
Follow this step by step Ms Excel tutorial to learn How to Name and use cell ranges in Excel.

MS Excel allows one to use a variety of functions and excel formulas when working with data and carrying out various calculations. You can even choose to test a statement to see if it is true or false. The if function allows you to apply conditional formulas that check the validity of a certain condition and test it for the data range you have applied it on.
Follow this step by step tutorial to learn How to use sumif on excel along with averageif.

Knowing how to work with date and time in excel can come in handy when you need to enter time stamps somewhere or you want to add a date to a specific entry. One should know how to enter time and date in Excel and how to do their formatting.
Follow this step by step tutorial to learn how to work with times and dates in Microsoft Excel.

Handling data in excel can be difficult sometimes. There is always a room for errors and these errors come in different ways. In this tutorial, we will have a look as to what absolute reference is and how can we use it to prevent errors. When you are doing some calculations, you give cell references and when you use the auto fill feature, Excel guesses the pattern and tries to use the same formula or in the same way the previous value was calculated. However, this may sometimes give reference errors.
Follow this step by step tutorial to learn how to prevent errors using absolute references in Ms Excel.