This is a common problem: “I received data that’s in a long column but it needs to be in rows that can be sorted.” To get the data arranged properly, we look for patterns. One pattern is that there’s a space before every new entry. From there, it’s easy. The video shows how to use […]
Course is being given 18MAY13 in Chicago For details & registration: http://bit.ly/11N66qW Learn by doing! If you want to learn about wood, woodworking tools, different types of nails, etc., why not build a fancy cabinet? That’s the idea for Excel Uncensored What you will get from Excel Uncensored: – If you haven’t done any VBA […]
Tasting Comparison of 3 sriracha brands: Lee Kum Kee, Saigon Sisters, and Sky Valley. Yesterday we did Trader Joe’s, Lee Kum Kee and Saigon Sisters. Trader Joe’s as salty and not so spicy. Today, someone at Whole Foods was kind enough to give me a bottle of Sky Valley. Here is the tasting …
It had to be done! Review of 3 brands of sriracha. Lee Kum Kee is my favorite. It could be spicier but as a complete experience, it’s the clear winner.Please comment. Share your thoughts.
Ever wanted to draw in Excel? Highlight certain things? The Inking feature allows you to do it.
(This grew out of a blogpost on monitoring the fundraising of a nonprofit. You can see it here: http://bit.ly/100nsKY ) Sometimes we want to see 2 very different bits of data in one graph. In this case, it helps to see the donation totals and the number of donations together. In Excel lingo, we create […]
Many of us have given out bad information about VLOOKUPS. We’ve said that VLOOKUP always starts its search at the top of our lookup array and it goes step-by-step until it finds the closest or exact match. That’s called a Liner Search and that’s what happens when we want an exact match. We designate that […]
A travel agent presented this challenge because she was always struggling when a client wanted to go on a trip to a specific destination but when she’d look it up, the client either didn’t have enough money or didn’t have enough time. She asks: “We always know the time needed and the budget for each […]
Excel & Data Management Excel VBA code programmed to estimate the next result of selling a stock based on Current price, estimated purchase date, number of shares, estimated tax exposure. The script goes online to retrieve the current stock price, the stock price from the estimated purchase date, and calculates the estimated net