Wednesday, May 18, 2005
Excel Online Training Sitemap
Excel Online Training Sitemap: "Excel Logic Functions - Excel logic functions give Excel the ability to think... Sort of. Logic functions are used when a decision has to be made, usually when we are comparing our data against several different possibilities.
Excel IF Function - This function enables you to perform a calculation only IF a certain condition is true, and a completely different calculation if that condition is false.
Excel AND Function - The AND function can contain up to 30 separate arguments and if ALL of those arguments are TRUE, the AND function returns TRUE, but if ANY of those arguments are FALSE, the AND function returns
FALSE.
Excel OR Function - This Excel function is similar in operation to the Excel AND function and returns a logical value, either TRUE or FALSE depending on the logical value of each of its arguments.
Excel Text Functions - Excel text functions are used, surprise surprise, on text that is within your spreadsheets.
Excel LEN Function - Basically what the LEN function does is counts how many characters there are in a text string.
Excel LEFT Function - Use the Excel LEFT function to extract a specific number of characters from the LEFT, or beginning, of a text string.
Excel RIGHT Function - Use the Excel RIGHT function to extract a specific number of characters from the right, or end, of a text string.
Excel MID Function - The MID function is used when you want to extract a certain number of characters from within a text string.
Excel TRIM Function - The Excel TRIM function is an unsung hero in Excel's function camp. This neat little function removes all those unsightly spaces from your text strings, and it doesn't leave a nasty rash."
Excel IF Function - This function enables you to perform a calculation only IF a certain condition is true, and a completely different calculation if that condition is false.
Excel AND Function - The AND function can contain up to 30 separate arguments and if ALL of those arguments are TRUE, the AND function returns TRUE, but if ANY of those arguments are FALSE, the AND function returns
FALSE.
Excel OR Function - This Excel function is similar in operation to the Excel AND function and returns a logical value, either TRUE or FALSE depending on the logical value of each of its arguments.
Excel Text Functions - Excel text functions are used, surprise surprise, on text that is within your spreadsheets.
Excel LEN Function - Basically what the LEN function does is counts how many characters there are in a text string.
Excel LEFT Function - Use the Excel LEFT function to extract a specific number of characters from the LEFT, or beginning, of a text string.
Excel RIGHT Function - Use the Excel RIGHT function to extract a specific number of characters from the right, or end, of a text string.
Excel MID Function - The MID function is used when you want to extract a certain number of characters from within a text string.
Excel TRIM Function - The Excel TRIM function is an unsung hero in Excel's function camp. This neat little function removes all those unsightly spaces from your text strings, and it doesn't leave a nasty rash."
