How to Convert Text to Dates [Data Cleanup]
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.
Making a Dynamic Dashboard in Excel [Part 1 of 4]
In this and next 3 posts, we will learn how to make a Dynamic Dashboard using Microsoft Excel.
At the end of this tutorial, you will learn how easy it is to set up a dynamic dashboard using excel formulas and simple VBA macros.
Pivot Table Tricks to Make You a Star
We, data junkies, love pivot tables. We think pivot tables are solution for everything (except for may be global warming and that broken espresso machine down stairs).
Today, we are going to learn 5 awesome pivot table tricks that will make you a star.
A Brief History of Microsoft Excel – Timeline Visualization
Timeline charts are great for providing quick snapshots of historical events. And hardly a day goes by without some one making a cool visualization of a time line of this or that. Time lines are easy to read, present information in a logical manner and mostly fun.
So yesterday, I set out to mimic the iconic gadgets of all time in excel, just for fun. Then it strike me, why not make a visual time line of Microsoft Excel ? So I did that instead.
Collapse, Expand Excel Charts using this hidden trick
Do you know that you collapse or expand excel charts? Don’t believe me? Me neither. When I first realized that we can collapse / expand charts without writing any macros or lengthy formulas, I couldn’t wait to share it with all of you. This is such a simple yet powerful trick. See it for yourself.
The trick lies in using group / un-group data feature and carefully aligning charts with the cell grid. The whole process takes just about 2 minutes and produces wow factor worth a week. Go check it, now. Also, a downloadable template is included in the post.
Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
This is second part of 2 part series on conditionally formatting dates in excel.
Highlighting Repeat Customers using Conditional FormattingIn yesterday’s post we have learned how to conditionally format dates using excel. In this article, you will learn how to use these conditional formatting tricks to highlight repeat customers in a list of sales records.
Conditionally Formatting Dates in Excel [Part 1 of 2]
This is first part of 2 part series on conditionally formatting dates in excel.
Conditional formatting is a very useful feature in Excel. You can use Conditional formatting to tell excel how to format cells that meet certain conditions. For eg. You can use conditional formatting to show all negative values in a range in red color. Today we will learn how to use conditional formatting to format dates.