How to add a range of cells in excel – concat()
Excel concatenate() is seriously crippled, it can add 2 or more strings together, as long as they are supplied as separate parameters. This means, when you have a range of cells with text which you want to add up to create a large text, you need to write an ugly looking biggish concatenate() or use […]
Gantt in 60 seconds – churn out an excel project plan in no time
One of the most frequent tasks for any manager is “planning”, be it putting together a hiring schedule or designing a jumbo jet, it all starts with a simple project plan and gantt chart is simple and intuitive representation of the same. But how to make a gantt chart in excel without writing too many […]
Creating in-cell bar charts / histograms in excel
Ever since writing the create in-cell pie charts in excel, I have been itching to find a simple enough method to do incell bar graphs. An in-cell bar would probably be more useful and cuter than an in-cell pie as it can instantly provide trending details. What more, these would probably look gorgeous when printed […]
Create in-cell pie charts in Excel
Here is a ridiculously easy trick to do nice incell pie charts in excel, what more, they will make you look like a charting wizard. Download free pie chart font from here (direct download link). The font has 21 pie chart codes starting with empty circle (character ‘a’) and ending with full circle (character ‘u’) […]
on vlookup()
Like this? Feel free to share / copy / exploit / save the cartoon. See other powerpoint cartoons as well
Open your favorite sites directly from Windows XP run dialog box
After seeing DI’s Open Your Favorite Websites Directly from Windows Vista Start post, I thought why not use Windows XP Run dialog box as a search box. So here is a simple trick that can enable you to open your favorite sites directly from XP’s run dialog box. Using this trick you can type “g […]
7 Most innovative software job titles
Gone are the days when software jobs are called ‘coder’ or ‘programmer’, as sophistication increased companies started calling the same coder as ‘software engineer’ or ‘programmer analyst’, then there were ‘sr. evangelists’, ‘associates’ and ‘server gurus’, but in the new era where demand is outstripping supply, naming a job creatively is as important as the […]