by Nate Moore | Jul 6, 2020 | Clinical Data, Podcasts, Tables
Podcast: Play in new window | DownloadSubscribe: Android | RSS Today’s BIG Idea is a project I worked on for a urology group last week. They asked to mine their data to find patients who qualified for a clinical trial, but the approach we used can help...
by Nate Moore | Mar 3, 2014 | Excel 2013, Tables
My friend John O’Connor in Missoula, Montana taught me the formatting trick I’ll show you in Excel Video 401. Last time we added a Table Style that made our data look better. If you want to customize that Table Style, here’s how to do it. Notice in the video that you...
by Nate Moore | Feb 18, 2014 | Tables
The message of Excel Video 399 is that structured references are easy to read, but hard to write. The syntax of the structured references is too involved, just mouse or arrow over to the cell you want and let Excel build the formula for you. Once the formula’s built,...
by Nate Moore | Feb 10, 2014 | Tables
Excel Video 397 showed you how to add data to a Table, but if you need to change the size of a Table, watch Excel Video 398. The example in the video that I’ve done most often is when I need to add data to the left of a table. The Resize Table button will let you...
by Nate Moore | Feb 3, 2014 | Tables
Watch how easy it is to add more data to Tables in Excel Video 397. If you’ve ever manually shaded every other row in a report, I hope those days are over with this Excel Video. Watch how I can add a formula to one adjacent cell in a Table and Excel will automatically...
by Nate Moore | Jan 27, 2014 | Tables
Excel Video 396 has two things to know about the total row in Tables. The first thing to know is that the total row respects filters. In other words, the amount shown in the total row takes into account the filters you apply. It’s easy to get the total number of...
