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
I can’t remember how I discovered Excel.TV but I watched the episode 1 trailer and my initial reaction was something like this: “WHAT???” followed by “Who are these guys?” and “I’ve got to check this out!“. Continue reading
I have been asked this question many times so I thought I would write this post as a reference that I could share with anyone who wants to improve their Excel skills.
Download the Excel file from my OneDrive (file 00126) Continue reading
As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading
I work full time as a Data Analyst currently specializing in Microsoft Excel and Microsoft Access. To keep up to date I watch a fair amount of YouTube videos and follow several websites. Continue reading
People often ask me questions like these. A quick answer is that array formulas can be used to answer very complex questions about data.
