This was weird. I stumbled across my video and I thought “WHAT? Get all text combinations using just a pivot? How did I do that?” It seemed like ‘Back To The Future’ as I re-watched my own video. Continue reading
We all have down time while we wait in line or while we commute. How do you use this time? In the past two years I’ve used part of my down time to learn Excel by reading tweets.
Continue reading
What does binning numbers into groups have in common with TV? Well…probably nothing but I had fun combining these ideas while creating this Excel file. Continue reading
The vlookup function is often used to prove a bare minimum of Excel knowledge because it’s both useful and common. Continue reading
Excel’s 3D formulas allow you to work with values from the same range in different sheets. However, not all Excel functions work with 3D formulas. Read my post to see how they work, how to go beyond 3D formulas and how to often avoid complex formulas with proper spreadsheet design! Continue reading
On Friday after work I attended a ModelOff Meetup in Toronto at The Rum Exchange located on 67 Richmond St W. It was a fun event! Continue reading
Last week I attended one of Bill Jelen’s Power Excel Seminars. The event was hosted by Excel4Apps at the SoHo Metropolitan Hotel in Toronto. Continue reading
Many of us enjoy puzzles. Sudoku, Crosswords, Chess, etc. I solve a lot of data puzzles using Microsoft Excel. A few months ago, a YouTube viewer had this question for me. Continue reading
Have you ever received an awkward data set? In my life as a Data Analyst this has happened to me many times in different shapes and forms. Continue reading
When you want to get a list of Excel file names from a folder and display it in an Excel sheet most people would think about using VBA (Excel’s programming language). But what if you don’t know VBA? Continue reading