# All articles with 'text()' Tag

Published on Nov 4, 2015 in Charts and Graphs, Learn Excel

Imagine you are the head of training department at ACME Inc. You arrange training programs round the year to empower your team. It is hard work, coordinating between employees, trainers, department heads, venues and coffee machines. What if there is something to help you keep track of all this? I am not talking about getting you a shiny new iPad, you silly. I am talking about a tracker & calendar built in Excel that ties everything together (well, almost everything, you still have to fill the coffee machine.)

We are going to build a training program tracker & calendar using Excel.

Continue »

## Combine pie and xy scatter charts – World Polls chart revisited

Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry.

I really liked Roberto’s comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go.

Over to FrankensTeam.

Continue »

## Top 10 Formulas for Aspiring Analysts

Published on Jan 16, 2013 in Learn Excel

Few weeks ago, someone asked me “What are the top 10 formulas?” That got me thinking.

While each of us have our own list of favorite, most frequently used formulas, there is no standard list of top 10 formulas for everyone. So, today let me attempt that.

If you want to become a data or business analyst then you must develop good understanding of Excel formulas & become fluent in them.

A good analyst should be familiar with below 10 formulas to begin with.

Continue »

## Formula Forensic No 019. Converting uneven Text Strings to Time

Published on Apr 19, 2012 in Excel Howtos, Formula Forensics, Huis, Posts by Hui

I have imported some data that comes in as a number that I need to convert to h:mm. The data string will be either 1,3,4,5,6 integers long and looks like this…

Help

Continue »

## A Technique to Quickly Develop Custom Number Formats

Published on Nov 2, 2011 in Excel Howtos, Huis, Learn Excel, Posts by Hui

This post examines a quick technique for developing Custom Number Formats for Cells, Charts or any other Number location in Excel.

Continue »

## Dummy Data – How to use the Random Functions

Published on May 4, 2011 in excel apps, Excel Howtos, Huis, Learn Excel, Posts by Hui

Don’t know which way to go ?
Can’t make up your mind between alternatives?

Using collected or known data is the best when developing Excel models, but from time to time this may not be available when you are developing your model. This post will look at some options for setting up Dummy Data using Excels Random number functions.

Continue »

## Make your Chart Legends Legendary

Published on Apr 8, 2010 in Charts and Graphs

We all know that legend can be added to a chart to provide useful information, color codes etc.

Today we will learn how to make the chart legends smarter so that they provide more meaning and context to the chart, like this:

This type of legend can be more useful than a plain legend as this provides more useful information without taking up too much space.

Continue »

## How to Convert Text to Dates [Data Cleanup]

Published on Mar 23, 2010 in Excel Howtos, Learn Excel

Sometimes when we import data from another source in to excel, the dates are not imported properly. This can be due to any number of reasons. In this post, we will learn some tricks and ideas you can use to quickly convert text to dates.

Continue »

## Formula 1 Style Sorting of Times (Durations) in Excel

Published on Jul 15, 2009 in Excel Howtos

The other day I was watching Formula 1 on TV. I think it is the ideal game to follow for a lazy dude like me. It is on every other weekend. It takes .32 seconds to understand the game and 3.2 seconds to know the points and scoring mechanism. But I am not here to convince you to follow the game. While looking at score boards, it struck me,

“how about writing excel formulas for sorting a list of durations (or numbers) in the formula 1 order?”

Continue »

## Excel Tips Submitted by You [Part 4]

Published on May 14, 2009 in Learn Excel

Today is our last installment of your week @ PHD. We have some exciting tips on using VBA, date formulas and index-match syntax.

Continue »