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
Date Archives → September 2015
Mr Excel (Bill Jelen) Power Excel Seminars
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
Video 00122 Normalizing Exported Data
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
Video 00135 Cali Data Cleanup
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
Trump Excel: Get the List of File Names from a Folder in Excel
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
Video 00137 Vlookup_Returns Multiple Values
Vlookup returns only 1 value, right? Well…normally yes but there are some tricks to return multiple values (numbers) and add them up. Continue reading