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.
Microsoft Excel allows you to work on a spreadsheet which can be used to organize information. One can even carry out calculations while working with excel column numbers using a number of formulae and functions given. In this tutorial, we will show you how to use some of the basic functions while working with numbers present in the columns. We will help you better organize your data in column format.
Follow this step by step tutorial in order to learn how to use Microsoft excel while working with numbers in columns.
This Adobe Photoshop tutorial will be focusing on how you can resize images in this software. Resizing an image is one of the most widely used options of Photoshop. Even people with no prior design or Photoshop background use this tool, which shows how easy it is to resize an image.
Microsoft Excel provides its users with the benefit to present data in a spreadsheet form. If you want to repeat rows or certain columns in your excel file, Excel allows its user to customize the sheet as per his/her requirements. Using Microsoft Excel allows one to arrange their data in an organized manner and also use a number of mathematical functions to carry out complex calculations.
In this tutorial, we will teach you how to repeat headers in Excel 2010.
Microsoft Excel allows it users to freeze panes while working on a large Excel workbook so that when one scrolls downwards or goes in any other direction, the data does not move around. Freeze panes in order to make the headings for each columns stay visible even if you scroll down. Data from one cell can also be split into multiple cells in order to divide off the data and make it appear organized categorically.
In this tutorial, we will show you how to freeze panes and split cell data into multiple cells in excel.
Many a times while working with a worksheet in excel, you might have huge amounts of data placed in your excel spreadsheet. It might thus be necessary at different points to replace various numbers or names etc in the given rows and columns. To make things easier, MS Excel provides you with the option of finding and replacing data in workbooks and spreadsheets to make editing information easier.
Follow this step by step tutorial to learn How to find & replace in excel.
MS Excel provides its users with the option of using templates for excel which are various worksheets available for different uses. Working with templates, not only saves time but also gives a complete and professional look to the worksheet. Since they are preinstalled, putting them into application is not difficult and one can even download more templates if need be. These templates can be customized as per your requirements, which make them even more useful.
Follow this step by step tutorial to learn how to use excel templates.
Home