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..
