Splitting text in excel using formulas
Often when you are processing text using excel it is important to split the text in to multiple parts based on a delimiter. For eg. you may want to divide this|needs|to|be|split in to five parts this needs to be split. There is a simple way to do this in excel, using “import text” option. But […]
Cool Info-graphics of the Week [Sep 5]
Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the visualizations featured earlier. Anatomy of a Great Speech – Obama’s acceptance speech at DNC Presentation Zen captures Obama’s symphony like acceptance speech in a graph shown […]
Microcharting in Excel – 7 Alternatives Reviewed
With each passing day the amount of information contained in a single spreadsheet, slide, document is growing. Thanks to demanding bosses, clients and colleagues, we are now supposed to provide all the relevant information in as much less space as possible. This is where micro charting or light weight data exploration has become a rage. […]
KPI Dashboards – Highlight KPIs Based on Percentile [Part 3 or 6]
Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany. This 6 Part Tutorial on KPI Dashboards Teaches YOU: Creating a Scrollable List View in Dashboard Add Ability to Sort on Any KPI to the Dashboard Highlight KPIs Based on Percentile Add Microcharts to KPI Dashboards Compare 2 […]
Initials from Names using Excel Formulas
Often when you are processing customer records or doing mail merge, it might be useful to get initials from a given name, like JFK for John F Kennedy. You can do this using simple text formulas (left(), mid(), find()) combined with if(). Here is how: Assuming cell B3 has the full name, then this is […]
Cool Visualizations of the Week [Aug 29]
Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the charts featured earlier. How to does Love, Anger, Joy and other emotions look like? Have you ever wondered how your emotions look like? That is exactly […]
What they dont teach you in any school – Appreciation
Back when I was doing MBA, one of the first courses we took was called MOC (Managerial Oral Communication). The idea of the course is simple. Each of the 60 students in class would give a 12 minute presentation on any topic of their choice to everyone. Then everyone has 8 minutes to provide suggestions, […]