how to use microsoft excel 2010 tutorial

The Lookup & Reference button provides functions that allow you to search for specific strings of data or numerical vĩ. The Date & Time button provides functions to make date and time calculations, for example, TODAY.Ĩ. The Text button contains functions to manipulate text, for example, to change the case of text.ħ. The Logical button contains functions relating to the logical analysis of data by setting conditions, for example, IF.Ħ.

The Financial button contains functions relating to financial calculations and analysis, for example, the PMT function.ĥ. The Recently Used button contains a list of all the functions recently accessed and is a great way to access frequently used functions quickly.Ĥ. For example, clicking on the button labelled Text will provide functions relating to working with cells containing text in Excel.ģ. In the Function Library, click on the relevant labeled category button (circled in yellow in the screenshot below) to view functions related to that category. Click on the Formulas tab on the Ribbon.Ģ. The best way to learn about functions and to get used to their syntax is by experimentation.ġ. For example: =VLOOKUP(G1,Sheet2!A1:B11,2,FALSE) may look like it is written in another language if you are not familiar with the function. People are often intimidated by functions in Excel, especially when they see a long, complicated looking, formulas referring to multiple cell references in a cell. Excel performs the same tasks that less than 30 years ago would have taken weeks, maybe even months to complete, in a less than a second. Before spreadsheets, people in various different fields of work and study, would have had to manually analyze reams of data and manually analyze it using very rudimentary methods. Test your Excel skills with the corresponding FREE Online Multiple Choiceįunctions in Excel allow you to automatically perform simple to extremely complex calculations, analyze data and manipulate data depending on what it needs to be used for. Understanding functions, how Excel organizes functions, and creating functions using the Function dialog box takes Excel beyond basic math. Excel Functions Tutorial – Excel 2010 – Formulas & Functions in Excel – Free Online Microsoft Excel Tutorialįunctions are predefined formulas that are the powerhouse behind Excel.

How to use microsoft excel 2010 tutorial