THIS COURSE PROVIDES TUTORIALS ON SPECIAL MS EXCLE TRICKS WHICH CAN BE USED TO DO TEDIOUS WORK IN MINUTES...
THIS COURSE PROVIDES TUTORIALS ON SPECIAL MS EXCLE TRICKS WHICH CAN BE USED TO DO TEDIOUS WORK IN MINUTES...
HOW TO SEARCH MULTIPLE DATA FROM A LARGE DATABASE?
4mHOW TO USE MAX FUNCTION AS AN ARRAY FOR LARGE DATA?
2mHOW TO CONVERT ROWS INTO COLUMNS AS AN ARRAY FUNCTION?
4mHOW TO USE SUM FUNCTION AS AN ARRAY FUNCTION?
2mCounting no. of columns and rows in the large size table within seconds!
1mHOW TO FREEZE PANES IN EXCEL?
2mSORTING DATA IN MS EXCEL ON MULTIPLE CRITERIA
2mHOW TO CALCULATE RUNNING TOTAL IN MS EXCEL?
4mHOW TO USE CLEAN FUNCTION IN MS EXCEL?
1mHOW TO REVERSE LONG LISTS IN MS EXCEL IN SECONDS?
2m