IAMMANUPRASAD

5 Simple Tips & Tricks in MS Excel |Part 10| COMMENT | CHARTS | HYPERLINK | NAME CELL | PMT,NPER

Part_10 : Tip #1 : Comments can create highlighting notes or comments using this Tip #2 : Charts Can create graphical charts using data in excel Tip #3 : Hyperlinks It can used to create external website hyperlinks and also can make hyperlinks of workbook inside and outside files. Tip #4 : Name cells Name a group of cell and call it anywere Tip #5 : PMT and NPER You can calculate loan payments with this function Part 9_2 : https://youtu.be/MrsmUx8sZ8M Tip #1 : LEN Tip #2 : CONCATENATE Tip #3 : UPPER, LOWER, PROPER Tip #4 : TEXT Tip #5 : TRIM, CLEAN Part 9_1 : https://youtu.be/H1TjUkHdpSU Tip #1 : LEFT,RIGHT,MID Tip #2 : FIND, SEARCH Tip #3 : REPLACE, SUBSTITUTE Tip #4 : CODE, CHAR Tip #5 : EXACT Part 8_2 : https://youtu.be/Ph1Bz4V5IJw Tip #1 : ISLOGICAL Tip #2 : ISODD Tip #3 : ISEVEN Tip #4 : ISNA Tip #5 : ISREF Part 8_1 : https://youtu.be/cIEWTl8V7Ds Tip #1 : ISERROR Tip #2 : ISNUMBER Tip #3 : ISBLANK Tip #4 : ISFORMULA Tip #5 : ISTEXT & ISNONTEXT Part 7 : https://youtu.be/2DfkrpgbUa4 Tip #1 : ABS Tip #2 : RAND & RANDBETWEEN Tip #3 : ROUND, ROUNDUP & ROUNDDOWN Tip #4 : CEILING & FLOOR Tip #5 : SUBTOTAL Part 6 : https://youtu.be/b8WGJlzqYLs Tip #1 : VLOOKUP Tip #2 : INDEX Tip #3 : MATCH Tip #4 : ROW and COLUMN Tip #5 : CHOOSE Part 5 : https://youtu.be/fskHJ2vmTOc Tip #1 : DAY, MONTH, YEAR Tip #2 : TODAY & NOW Tip #3 : END OF DATE & END OF MONTH Tip #4 : WORKDAYS Tip #5 : WEEKDAY & WEEKNUM Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdown List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel |Part 9_2| LEN|CONCATENATE| UPPER, LOWER, PROPER|TEXT| TRIM,CLEAN

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster TEXT FUNCTIONS Part 9_2 : Tip #1 : LEN It returns the length of the text string Tip #2 : CONCATENATE This function can used to joint multiple text string in to one Tip #3 : UPPER, LOWER, PROPER These functions can used to change the case of string's Tip #4 : TEXT Used to format the cell into text format Tip #5 : TRIM, CLEAN These functions can used to remove the extra spaces and line breaks Part 9_1 : https://youtu.be/H1TjUkHdpSU Tip #1 : LEFT,RIGHT,MID Tip #2 : FIND, SEARCH Tip #3 : REPLACE, SUBSTITUTE Tip #4 : CODE, CHAR Tip #5 : EXACT Part 8_2 : https://youtu.be/Ph1Bz4V5IJw Tip #1 : ISLOGICAL Tip #2 : ISODD Tip #3 : ISEVEN Tip #4 : ISNA Tip #5 : ISREF Part 8_1 : https://youtu.be/cIEWTl8V7Ds Tip #1 : ISERROR Tip #2 : ISNUMBER Tip #3 : ISBLANK Tip #4 : ISFORMULA Tip #5 : ISTEXT & ISNONTEXT Part 7 : Tip #1 : ABS Tip #2 : RAND & RANDBETWEEN Tip #3 : ROUND, ROUNDUP & ROUNDDOWN Tip #4 : CEILING & FLOOR Tip #5 : SUBTOTAL Part 6 : Tip #1 : VLOOKUP Tip #2 : INDEX Tip #3 : MATCH Tip #4 : ROW and COLUMN Tip #5 : CHOOSE Part 5 : https://youtu.be/fskHJ2vmTOc Tip #1 : DAY, MONTH, YEAR Tip #2 : TODAY & NOW Tip #3 : END OF DATE & END OF MONTH Tip #4 : WORKDAYS Tip #5 : WEEKDAY & WEEKNUM Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdownl List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 9_1| LEFT,RIGHT, MID|FIND| REPLACE,SUBSTITUTE| CODE| EXACT

TEXT FUNCTIONS Part 9_1 : Tip #1 : LEFT,RIGHT,MID We can use these functions to extract characters from a cell. Tip #2 : FIND, SEARCH Use this function to look specific text in a cell, it returns the position of matching text Tip #3 : REPLACE, SUBSTITUTE REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. Use SUBSTITUTE when you want to replace specific text in a text string; Tip #4 : CODE, CHAR CODE Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. CHAR Returns the corresponding character for the code Tip #5 : EXACT This function is used to compare two text, it is case sensitive Part 9_2 : Tip #1 : LEN Tip #2 : CONCAT, TEXTJOIN, CONCATENATE Tip #3 : UPPER, LOWER, PROPER Tip #4 : TEXT Tip #5 : TRIM, CLEAN Part 8_2 : https://youtu.be/Ph1Bz4V5IJw Tip #1 : ISLOGICAL Tip #2 : ISODD Tip #3 : ISEVEN Tip #4 : ISNA Tip #5 : ISREF Part 8_1 : https://youtu.be/cIEWTl8V7Ds Tip #1 : ISERROR Tip #2 : ISNUMBER Tip #3 : ISBLANK Tip #4 : ISFORMULA Tip #5 : ISTEXT & ISNONTEXT Part 7 : Tip #1 : ABS Tip #2 : RAND & RANDBETWEEN Tip #3 : ROUND, ROUNDUP & ROUNDDOWN Tip #4 : CEILING & FLOOR Tip #5 : SUBTOTAL Part 6 : Tip #1 : VLOOKUP Tip #2 : INDEX Tip #3 : MATCH Tip #4 : ROW and COLUMN Tip #5 : CHOOSE Part 5 : https://youtu.be/fskHJ2vmTOc Tip #1 : DAY, MONTH, YEAR Tip #2 : TODAY & NOW Tip #3 : END OF DATE & END OF MONTH Tip #4 : WORKDAYS Tip #5 : WEEKDAY & WEEKNUM Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdownl List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 8_2| ISLOGICAL|ISODD| ISEVEN| ISNA| ISREF

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster IS FUNCTIONS Part 2 Part 8_2 : Tip #1 : ISLOGICAL The Excel ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells. Tip #2 : ISODD Function to check the number is odd Tip #3 : ISEVEN Function to check the number is even Tip #4 : ISNA Function to find the cell has NA error Tip #5 : ISREF This function will check up the cell has referance or not,You can use the ISREF function to check if a cell contains a valid reference. Part 8_1 : https://youtu.be/cIEWTl8V7Ds Tip #1 : ISERROR Tip #2 : ISNUMBER Tip #3 : ISBLANK Tip #4 : ISFORMULA Tip #5 : ISTEXT & ISNONTEXT Part 7 : https://youtu.be/2DfkrpgbUa4 Tip #1 : ABS Tip #2 : RAND & RANDBETWEEN Tip #3 : ROUND, ROUNDUP & ROUNDDOWN Tip #4 : CEILING & FLOOR Tip #5 : SUBTOTAL Part 6 : https://youtu.be/b8WGJlzqYLs Tip #1 : VLOOKUP Tip #2 : INDEX Tip #3 : MATCH Tip #4 : ROW and COLUMN Tip #5 : CHOOSE Part 5 : https://youtu.be/fskHJ2vmTOc Tip #1 : DAY, MONTH, YEAR Tip #2 : TODAY & NOW Tip #3 : END OF DATE & END OF MONTH Tip #4 : WORKDAYS Tip #5 : WEEKDAY & WEEKNUM Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdownl List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 8_1| ISERROR|ISNUMBER| ISFORMULA| ISBLANK | ISTEXT

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster

IS FUNCTIONS Part 1 Part 8_1 : Tip #1 : ISERROR This function returns true for any error occurred in excel, otherwise it returns false Tip #2 : ISNUMBER It is a function checking whether the value in a cell is number or not Tip #3 : ISBLANK This function will check the cell is blank or not Tip #4 : ISFORMULA function to check the cell has an excel formula or not Tip #5 : ISTEXT & ISNONTEXT Function to check whether the cell contains text or not Part 8_2 : https://youtu.be/Ph1Bz4V5IJw Tip #1 : ISLOGICAL Tip #2 : ISODD Tip #3 : ISEVEN Tip #4 : ISNA Tip #5 : ISREF Part 7 : https://youtu.be/2DfkrpgbUa4 Tip #1 : ABS Tip #2 : RAND & RANDBETWEEN Tip #3 : ROUND, ROUNDUP & ROUNDDOWN Tip #4 : CEILING & FLOOR Tip #5 : MOD Part 6 : https://youtu.be/b8WGJlzqYLs Tip #1 : VLOOKUP Tip #2 : INDEX Tip #3 : MATCH Tip #4 : ROW and COLUMN Tip #5 : CHOOSE Part 5 : https://youtu.be/fskHJ2vmTOc Tip #1 : DAY, MONTH, YEAR Tip #2 : TODAY & NOW Tip #3 : END OF DATE & END OF MONTH Tip #4 : WORKDAYS Tip #5 : WEEKDAY & WEEKNUM Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdown List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 7| ABS|RAND| ROUND | CEILING & FLOOR | MOD

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster MATHEMATICAL FUNCTIONS Part 7 : Tip #1 : ABS Function used to find the absolute value Tip #2 : RAND & RANDBETWEEN To generate randum numbers Tip #3 : ROUND, ROUNDUP & ROUNDDOWN Function to rounding up the number Tip #4 : CEILING & FLOOR Returns number rounded up, away from zero, to the nearest multiple of significance. Function used to roundup the number Tip #5 : MOD It returns the remainder after division Part 6 : https://youtu.be/b8WGJlzqYLs Tip #1 : VLOOKUP Tip #2 : INDEX Tip #3 : MATCH Tip #4 : ROW and COLUMN Tip #5 : CHOOSE Part 5 : https://youtu.be/fskHJ2vmTOc Tip #1 : DAY, MONTH, YEAR Tip #2 : TODAY & NOW Tip #3 : END OF DATE & END OF MONTH Tip #4 : WORKDAYS Tip #5 : WEEKDAY & WEEKNUM Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdownl List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 6| VLOOKUP |INDEX MATCH| ROWN & COLUMN | CHOOSE

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster Reference Functions Part 6 : Tip #1 : VLOOKUP It is an Excel function to lookup and retrieve data from a specific column in table Tip #2 : INDEX The INDEX function returns the value at a given position in a range or array Tip #3 : MATCH The MATCH get the position of an item in an array Tip #4 : ROW and COLUMN Returns the number of the row or column Tip #5 : CHOOSE We can use CHOOSE when need to make a choice based on number Part 5 : https://youtu.be/fskHJ2vmTOc Tip #1 : DAY, MONTH, YEAR Tip #2 : TODAY & NOW Tip #3 : END OF DATE & END OF MONTH Tip #4 : WORKDAYS Tip #5 : WEEKDAY & WEEKNUM Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdownl List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 5 | DAY | TIME | EDATE EOMONTH | WORKDAYS | WEEKNUM

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster Other videos are below Date & Time functions Part 5 : Tip #1 : DAY, MONTH, YEAR Returns Day, month and year function Tip #2 : TODAY, NOW, HOUR, MINUTE & SECOND Returns current date and date time Tip #3 : END OF DATE & END OF MONTH Returns end of the date or month after n numbers Tip #4 : WORKDAYS Returnd number of workdays Tip #5 : WEEKDAY & WEEKNUM Returns number of week in month and number of week in year Part 4 : https://youtu.be/gZld6iknrb0 Tip #1 : IF function Tip #2 : Nested IF Tip #3 : IF with AND & OR Tip #4 : COUNTIF Tip #5 : SUMIF Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdownl List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 4| IF | nestedif | if with and & or| countif | sumif

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster Part 4 : Tip #1 : IF function : Explaining how to apply IF function in excel Tip #2 : Nested IF : IF function within IF Tip #3 : IF with AND & OR : How to apply IF function with AND and OR function Tip #4 : COUNTIF : How to apply COUNTIF function in excel Tip #5 : SUMIF : How to apply SUMIF function in excel Part 3 : https://youtu.be/h1czL6_6PGo Tip #1 : Freeze Panes Tip #2 : Print Title Tip #3 : Print Selection Tip #4 : Page break view Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdown List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 3 | Freeze pane | Print title| print selection | break view| setup

This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster Part 3 : Tip #1 : Freeze Panes: Freeze headings to better view Tip #2 : Print Title: Print the selected titles in all the pages Tip #3 : Print Selection: Print only selected area, multiple worksheet printing at a time Tip #4 : Page break view: page break view before printout Tip #5 : other printing tips Part 2 : https://youtu.be/wn0IXZD01XA Tip #1 : Transpose Tip #2 : Conditional Formatting Tip #3 : Remove Duplicate Tip #4 : Dropdown List Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..

5 Simple Tips & Tricks in MS Excel | Part 2 |Transpose | Cond format | Duplicate | dropdown | combine

Tip #1 : Transpose

Tip #2 : Conditional Formatting

Tip #3 : Remove Duplicate

Tip #4 : Dropdownl List

Tip #5 : Combines cells Part 1 : https://youtu.be/93P3xcN4H0s Tip #1 : Column or Row width Adjustment Tip #2 : Select Data Tip #3 : Quick Analysis Tip #4 : Fill & Series Tip #5 : Format Painter Please subscribe and share the video... More parts are coming with exiting tips..