Data Validation Under Table
Tables are great, we love them. But we don’t always love them. If using data validation in a column, it works great inside of a Table. But what about in the cells underneath the Table? Not so much. In this blog […]
Add rows to all Tables in a worksheet
Adam asked a question in the how to find the last row on a sheet with tables post. He wanted to know how to insert a row into every Table in the worksheet. Well, it’s a slightly different problem than […]
Append data to a Table with the Total Row showing
Working with Tables is great. I mean, did you even see where you’re at? Our name says it all. But sometimes they just don’t work quite like you would think. As in life, we work with what we have. A […]
Excel Summit South in Review
A few short weeks ago, several experts from around the world began a whirlwind-tour across New Zealand and Australia, to share their Excel and modeling knowledge. I must say, it was one helluva’n experience which I was blessed to be […]
Office 2016 Breakdown
Hello! It’s been a while since I’ve posted. Apologies for the delay, but life has been good. So much has happened the last few months, with so many shiny, new things to talk about! And I love shiny, new things. […]
Office 2016 for Mac is here!
While I don’t use a Mac, I can appreciate cross-platform capabilities. That and my wife uses a Mac. So I’m excited to let you know that Office 2016 for Mac is finally here! Here’s what you need to know: Get […]
The Einstein Riddle: A logic puzzle
A friend of mine posted this on their Facebook. I’d heard of it but never tried it out myself. FSo I figured, why not, and gave it a go. If you like logic puzzles, this is for you! This doesn’t […]
How to find the last Table row on a sheet
There was a really good blog post by Jon Acampora over at ExcelCampus with a VBA tutorial on finding the last row, column, or cell on a sheet, and three different methods to do that with (End, Find, and SpecialCells). […]
Choosing a File Format
A good question which keeps popping up is what file format should you choose for an Excel file. Excel can save in a variety of formats. I’m assuming we’re only dealing with Excel 2007 or later and will not be […]
Run Scheduled Macro
By Zack Barresse Synopsis Today at PASS BA 2015 I spoke in a session about the topic of Excel Add-Ins. Nearing the end of the session an attendee asked an interesting question which I thought worthy of a blog post. What […]