- 10 Shortcut Keys in excel to speedup your work.
- Change the comma separator from lakhs to million
- Excel autocorrect feature and tricks to save time
- Excel text box link to cell to auto update text box or shapes
- Hide formulas in excel and protect worksheet from update
- How to add the developer tab to the ribbon
- How to Correct VLOOKUP error (#N/A,#REF!,#VALUE!,#NAME?)
- How to customise quick access toolbar…?
- How to find duplicates in excel- 3 ways to check for duplicates
- How to insert drop down list in excel
- How to insert image into excel comment box
- How to lock cell and protect sheet in excel
- Insert table from excel to Gmail or Blogger
- Lookup Picture in excel with Index Match
- Nested vlookup in excel : vlookp trick
- Remove Extra Spaces from Lookup Values: VLOOKUP with TRIM
- Speedup your vlookup: 2vlookups instead of 1 vlookup
- View or Print all formulas in a Sheet
- VLOOKUP column index auto update with COLUMN function
- VLOOKUP to replace excel if multiple conditions (Nested IF)