Excel Is Simple

Most of the times we face the problem of line breaks in excel cells. The two ways to remove the line breaks is the 'clean' function and the 'substitute'  function. Check this video to see how to use the formulae ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you ...

Download the sample report here https://goo.gl/Zt8HTz Here are the links for the tutorial of the 'vlookup' function: https://www.youtube.com/watch?v=-WAEzokHSJM https://www.youtube.com/watch?v=-hJxIMBbmZY ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you have just s...

Description The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. Syntax The IF function syntax has the following arguments: logical_test: Required. Any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator. value_if_true   Optional. The value that you want to be returned if the logical_test argument evaluates to TRUE. For example, if the value of this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, the IF function returns the text "Within budget." If logical_test evaluates to TRUE and the value_if_true argument is omitted; that is, there is only a comma following the logical_test argument, the IF f...

Learn the AND & IF formula step by step using this video

Here is a simple explanation of the various COUNT and IF formulas Here are some of the simple COUNT and IF formulas: COUNT - Counts number of cells with numbers in a range COUNTA - Counts number of non blank cells in a range COUNTBLANK - Counts number of blank cells in a range COUNTIF - Counts if a criteria is met in a range COUNTIFS - Counts if multiple criteria is met in a range SUM - Sum of a range SUMIF - Sum of a range if a single criteria is met SUMIFS - Sum of a range if multiple criteria are met Watch the video to understand the working of these formulas Welcome to Excel is Simple; A channel where we will help you will all your excel problems in the simplest possible way Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1