About
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:
- Excel to PDF Converter
- Offset function in conjunction with Sumif
- Highlighting duplicate values in adjacent cells
- Avoiding blank cells
- Compare multiple excel sheets at once
- Excel keyboard shortcuts List
- Mouseless Dragging of the topmost cell to cells below
- Hide and unhide rows and columns without a mouse
- Display separate taskbar button for every open excel workbook
- How to get rid off #### entries in excel???
- Delete Excel chart
- Moving between multiple excel Workbooks
- Pivot table or countif function???
- Converting Text to Columns in Excel
- How to sum values in a filtered list???
- Selecting non-adjacent cells in excel
- Selecting Multiple Worksheets
- Formatting the cell as text
- Excel frequency function or simple logic??
- Concatenate function
- Changing case in Excel
- Is there any de-concatenate command??
- See all Formulas at Once
- SUM(IF()) array formula
- Putting Borders around bunch of non-adjacent Cells at once
- Insert Excel Spreadsheet into Microsoft Word Document
- Dragging a formula down
Popularity: 1%