Those who are new to spreadsheets and Excel will find the basic information needed on how to use Excel and other programs such as Calc and Microsoft Works to create effective and professional looking spreadsheets. This is a beginner’s guide that covers essential information.
Functions are predefined formulas and are already available in Excel.
|Date & Time Functions||DATE and TIME Functions are used to perform operations on date and time values like fetching today’s date, current time, finding working days between 2 given dates etc.|
|Engineering Functions||Engineering Functions have been provided to perform some of the commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases.|
|Financial Functions||Financial Functions are used to do financial calculations like calculating your mortgage payments, find future value of an investment etc.|
|Information Functions||Information Functions are used get information about the worksheets and its contents like the current row number, whether a cell has an error, the type of value a cell has etc.|
|Lookup & Reference Functions||Lookup & Reference Functions are useful when you to work with arrays of data, and are particularly useful when you need to cross reference between different data sets.|
|Database Functions||Database Functions have been provided to help you to work with a large number of organised data records, stored in Excel, i.e., a database.|
|Logical Functions||Logical functions help you to work the logical values, TRUE and FALSE. They include boolean operators, conditional tests and functions to return the constant logical values.|
|Math & Trig Functions||Math Functions are provided by Excel, to carry out many of the common mathematical calculations, including basic arithmetic, conditional sums & products, and the trigonometric ratios.|
|Statistical Functions||Excel provides a large selection of Statistical Functions, that perform most of the common statistical calculations, from basic mean, median & mode calculations to the more complex statistical distribution and probability tests.|
|Text Functions||TEXT functions are used to return information about a text string, to convert between text and other data types, and to split and concatenate text strings.|
|Cube Functions||Cube functions perform calculations and extract data from a cube, which is stored on an external SQL server. These functions are only supported with a connection to Microsoft SQL Server 2005 Analysis Services or later data source.|
|Web Functions||A trio of new functions that make it easy to extend your worksheets to use XML web services. The Excel WEBSERVICE function, ENCODEURL function, and FILTERXML function work nicely together to make the task of working with web services straightforward within Excel 2013.|