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..
No comments:
Post a Comment