The new Excel 2013 comes with new features and a fresh design which includes splash screen with faster loading speed. When opened, the new version takes you directly to the landing page which has lots of built in templates. There is a search bar through which you can search for different online office templates. In this guide, we will give you Excel 2013 overview.
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.
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.
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.
Home