Formula Forensics No. 005 – Zebras and Checker-Boards
Zebra Stripes and Checker Boards
This week in Formula Forensics I’m taking a break from Array Formulas to have a look at some Zebra Stripes and Checker Boards.
No, I haven’t gone crazy, although some may argue that point.
More specifically were going to take a look at, Zebra Stripes and Checker-Board Conditional Formatting.
Formula Forensics No. 003 – Lukes Reward
Today we publish what is hopefully the First of many posts by guest author Luke M. it is also the Third post in the Formula Forensics series, which has now moved to a regular and new Thursday slot ?
Luke has taken up Hui’s and 3G’s challenge of explaining how the technique he regularly uses on the Chandoo.org Forums for extracting individual records out of a group.
Today Luke tells us how to extract a list of items from a larger list according to some criteria.
Scheduling Variable Feed Sources
In many industries, bulk commodities are received or delivered in batches or parcels of various quantities and with various properties.
This post will look at one option for scheduling these commodities within Excel.
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.
Top X chart – Show Top X values of a chart Interactively
Two charting principles we hear all the time are,
- Sort your data in a meaningful order before plotting it.
- Show only relevant information, not everything – because un-necessary information clutters the chart.
Today we will learn a dynamic charting technique that will mix these two ideas in a useful way. I call this a Top X chart.
Baby Feeding Chart using Excel
While feeding the babies last night, I had this idea. Why not make an excel sheet where you can keep track of the baby’s feeding and sleeping activities on day to day basis. It would probably help you understand your baby’s needs better and may be give you some insights.
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
It is no exaggeration that knowing excel formulas can give you a career boost. From someone starting at the long list of numbers, you can suddenly become a data god who can lookup, manipulate and analyze any spreadsheet.
So when our little excel blog hit the 5000 RSS Subscriber milestone, I celebrated the occasion by asking you to share an excel formula through twitter or comments with rest of us. And boy, what an excellent list of formula tips you have shared with us all.
Here is the complete list of entries for the twitter formula contest.