I’ll review the posts I wrote in 2019. But first, a challenge inspired by a Wall Street Journal article.
Can I Recreate This in Excel?
There’s no practical reason to do this but could I do it? I ended up with this in Excel:
I also created an option to display random numbers and switch back to the original numbers.
My 2019 Post Review Excel file includes the recreated pic and a list of all my posts.
2019 Post Sample
Some were fun (exploring silly ideas when over-caffeinated), others informative (explaining MMULT function), a few compared different solutions and even a couple of chess posts!
I was in the backyard cooking a burger, drinking a beer.
I got inspired to build this!
Auditing Jordan Goldmeier’s hyperlink udf rollover invention!
I also created a mini maze game based on Jordan’s technique.
A face moves using only formulas & conditional formatting.
I also found a way to make the face interact with cells.
It’s surprising how much I learned tinkering around with this 🙂
Reviewing a challenge from contextures, explaining MMULT function.
Sharing alternative solutions.
Should we avoid volatile functions?
This debate is just as important as vlookup vs index/match.
Finally a decent answer to the question:
4 solutions to a specific question I had earlier this year.
Which solution do you prefer?
Power Query is an amazing tool with so many uses.
See how to create all combinations from three tables.
Explore the life changing tool currently called Get & Transform (previously known as Power Query).
I review Robert Gascon’s chess game viewer.
Chess and Excel…what could be more exciting?
Robert’s post inspired me to build a FEN viewer!
Given a FEN (text description of chess position) I reposition the pieces on the board.
Download my Excel file above to see the list of all my 2019 posts.
Eugenia’s article was an interesting read. Here’s an excerpt:
Math develops beyond numbers by continuing the process of finding patterns and relationships, and turning them into progressively more abstract concepts. Thinking about numbers leads to equations, which come from relationships between numbers. If we think about relationships between equations, we get into the field of algebraic geometry. Thinking about relationships between whole fields of math leads to my own area of research, category theory.
A similar process gave us the concepts of days and years. Humans discovered patterns in the rate at which the earth rotates and the rate at which it orbits the sun. We then invented a way of organizing time in units that would line up with those cycles in a convenient way. Days and years occur regardless of human observation; the part that we imposed was the arbitrary decision of what would count as the “beginning” of each cycle—midnight and January 1.
About Eugenia Cheng
About Tomasz Walenta
Thank you for reading my blog this year. A special thanks to those who commented, offered alternative solutions and provided ideas for posts. A special thanks to Robert Gascon for his insightful comments, post suggestions and Chess Game Viewer.
I live in Markham Ontario Canada.
As you can see, I’m a big Microsoft Excel fan!