Let’s say you have data like this in a spreadsheet. Don’t roll your eyes, I am 102% sure, right at this moment, someone is (ab)using Excel to create similar messy data.
How do you reshape it to one column?
You could use formulas, VBA or Power Query. Let’s examine all these methods to see what is best. All these methods assume your data is in a range aptly named myrange. Continue reading
Nishanth & Nakshatra, my kids are now 8 years old and learning mathematics at school. Very soon (from this Saturday), they will have 2 weeks of school term break. As a stay at home dad, I shudder at the thought of school holidays. So this time, I have an evil plan. I made maths worksheets for them. Everyday, I will print one and ask them to complete.
If you are a stay at home parent and want to keep your kids busy for a few minutes every day, grab a copy of this and give it a go. Keep in mind that the workbook uses RANDBETWEEN(), so the numbers change every time. If you have multiple kids, print multiple copies. There are no answer sheets, so when you need to check the answers, you too must calculate them by hand. Continue reading
It is Easter time. This is the first Easter we are celebrating in our new house. So it is bound to have so many special memories. For last 10 years (wow, it has been a decade of tradition), I have been running Excel based egg hunts every Easter. It all started in 2009, when I was living in Sweden (where Easter is a BIG thing). I had to share the enthusiasm with someone, so I made our first Easter egg hunt on the blog.
This year, join me on an Excel themed cryptic crossword clues – Easter egg hunt. Don’t forget to share your scores and explanations in the comments. Continue reading
Update 05/10/2018: Yes, I am coming back. As part of that I am consolidating both WholeLifeProductivity.com and SimpleProductivityBlog.com into one spot – LauraEarnest.com. Stay tuned!
Dear Readers,
I’ve been blogging for a really long time – since… Continue reading
You might need to get email off of your server. The first is space. If your company has quotas on how big your email boxes can be (and they all do), you might find yourself in a situation where you have no more room, but you need to hang onto emails fo… Continue reading
For email, the old postcard rule applies. Nobody else is supposed to read your postcards, but you’d be a fool if you wrote anything private on one. –Judith Martin Continue reading
Pivot tables are fun, easy and super useful. Except, they can be ugly when it comes to presentation. Here is a quick way to make a pivot look more like a report.
See this quick demo to understand what I mean:
So simple and effective. Continue reading
As I’ve been dealing with the topic of email this month, I have had plenty of time to consider the topic of spam. You know, that stuff that flows into your email that adds nothing of value to your life while taking up space and attention.
But spam do… Continue reading
You probably know that you have to hang onto certain paper documents for a given number of years. These documents are required by law, and only after a certain number of years of retention can you get rid of them. The same applies to email, though, whi… Continue reading
It’s almost reflexive. You pick up your phone and you immediately check your email. The question I want to look at today is about checking email too much…and a better way.
I’ve had a terrible email habit. I think it stemmed from FOMO, but I would ch… Continue reading
