MICROSOFT EXCEL 2007 TUTORIAL YOUTUBE HOW TO
MICROSOFT EXCEL 2007 TUTORIAL YOUTUBE WINDOWS

(If you do not see this option in the menu you are probably usingВ Excel 2007 or higher!). In the menu go to the HelpВ tab and then click on About Microsoft Excel In the Excel Options dialog box, Select Resources > About button. Go to File > Help > About Microsoft ExcelД¬lick on Rounded Microsoft Office Icon > Excel options. Here is what it looks like in Excel 2016: You can check all of this information by choosing either the help or about option in Excel:

Whether you use a 64-bit or 32-bit version.

MICROSOFT EXCEL 2007 TUTORIAL YOUTUBE WINDOWS

If it is not in capital letters, you are probably using some other version of Excel.ДЇor Microsoft Excel 2010, you can see the Rounded File Menu Button at the top left-hand corner.ДЇor Microsoft Excel 2007, you can see the Rounded Microsoft Office Icon at the top left-hand corner.ДЇor Microsoft Excel 2003, the giveaway here is it looks like Windows XP!ДЄnd this means you already need an upgrade!Д®ven though the above 2 methods are quick and easy, they do not provide complete information like: If you are using Microsoft Excel 2013, you can see that the Ribbon tabs are all in Capital Letters! For any other version, this text is not available. It is the only Excel version with this feature. You can see the вЂњTell me what you want to doвЂќ text at the top.

MICROSOFT EXCEL 2007 TUTORIAL YOUTUBE HOW TO

If you make an error in the formula that prevents Excel from being able to calculate the formula at all, Excel displays an Alert dialog box suggesting how to fix the problem.For Microsoft Excel 2016, you can easily spot the difference. See the below screen shot.ДЄs soon as you complete a formula entry, Excel calculates the result, which is then displayed inside the cell within the worksheet (the contents of the formula, however, continue to be visible on the Formula bar anytime the cell is active). When you are using built-in functions, you click the cell or drag through the cell range that you want to use when defining the functionвЂ™s arguments in the Function Arguments dialog box. Using the Pointing method to supply the cell addresses for formulas is often easier and more powerful method of formula building. When building formulas manually, you can either type in the cell addresses or you can point to them in the worksheet. =SUM(A1:A12) Adds the values in the range A1:A12.ДЇor creating a formula you need to type in the Formula Bar. Worksheet functions (such as SUMor AVERAGE) If the cells are identical, the formula returns TRUE otherwise, it returns FALSE. This formula uses only values, and it always returns the same result as 100.Д¬ell references (including named cells and ranges) =A1+A2 Adds the values in cells A1 and A2. Mathematical operators, such as +(for addition) and *(for multiplication) Elements of FormulasДЄ formula can consist of any of these elements в€’ For example, you can quickly change the data in a worksheet and formulas works.

The values and text used in formulas can be located in other cells, which makes changing data easy and gives worksheets their dynamic nature. It performs some calculations and returns a result, which is displayed in the cell.ДЇormulas use a variety of operators and worksheet functions to work with values and text. A formula consists of special code, which is entered into a cell. Without formula, worksheet will be just simple tabular representation of data. Formulas are the Bread and butter of worksheet.

Microsoft excel 2007 tutorial youtube