We started HandyExcelTips.com with the aim of making a world of difference to your excel knowledge. Most would agree that in this world of computers, having a considerable expertise in excel, is a boon. But the question is can you achieve it independently through some good excel books?? Or by just asking your colleague to help you out?? Realistically speaking, I don’t think you can. I am sure most of us who do not get help when they get stuck resort to long excel formulas when something so easy might just be available. I know this because that’s what me and most of my co-workers do and have been doing for years. To get around that problem I decided that every now and then I will post some excel query and will also tell you how I solved it and then would like to know your viewpoint. So Handyexceltips.com is relying on volunteers to make this site a useful excel resource wherein people can find answers to all their excel queries.

Here is a list of articles that are currently on our site:

  1. Excel to PDF Converter
  2. Offset function in conjunction with Sumif
  3. Highlighting duplicate values in adjacent cells
  4. Avoiding blank cells
  5. Compare multiple excel sheets at once
  6. Excel keyboard shortcuts List
  7. Mouseless Dragging of the topmost cell to cells below
  8. Hide and unhide rows and columns without a mouse
  9. Display separate taskbar button for every open excel workbook
  10. How to get rid off #### entries in excel???
  11. Delete Excel chart
  12. Moving between multiple excel Workbooks
  13. Pivot table or countif function???
  14. Converting Text to Columns in Excel
  15. How to sum values in a filtered list???
  16. Selecting non-adjacent cells in excel
  17. Selecting Multiple Worksheets
  18. Formatting the cell as text
  19. Excel frequency function or simple logic??
  20. Concatenate function
  21. Changing case in Excel
  22. Is there any de-concatenate command??
  23. See all Formulas at Once
  24. SUM(IF()) array formula
  25. Putting Borders around bunch of non-adjacent Cells at once
  26. Insert Excel Spreadsheet into Microsoft Word Document
  27. Dragging a formula down
Share This

Popularity: 1%