![]() ![]() #45 Excel tip for spead – Be a keyboard user.#44 Use ‘Group’ feature to organize your workbook.#43 Generate Random numbers using Randbetween formula (Caution).#42 Don’t scroll Up & Down, use Freeze Panes.#41 Boost your analytical skills with SUMPRODUCT formula.#40 BEST EXCEL TIPS – Take full advantage of Sumif & Sumifs.#37 Be careful with circular reference errors.#36 Make use of Upper, Lower & Proper functions to play with the text.#35 Use SUBSTITUTE formula to replace text.#32 Left formula to extract text from Left side.#31 Right formula can extract text from right side.#30 Use IFERROR formula for error management.#29 Measure length of a string with LEN formula.#28 Extract Day, Month & Year from a date.#27 Use TRIM formula to remove unwanted spaces.#26 best excel tip – GET RID OF GRIDLINES.#25 Calculation Options can help as well as ruin your work.#23 Find & Select (or GoTo special) to identify all the formulas in a worksheet.#22 Use Transpose formula for live updates.#21 Use built-in styles for quick formatting.#20 Beautify your reports with structured formatting.# 18 Learn CVZY shortcuts to save 90% of your time.#17 Use Transpose to transform your data. ![]() #16 Hide cell contents in Conditional Formatting.#14 Control+Enter can solve formula fill problem.Differentiate Input cells & Formula cells with a colour coding Advanced excel tip – Breakdown lengthy formulas ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |