accounting

Fill Handle Regression – Episode 1187

               

A lot of behind-the-scenes math goes into dragging the fill handle…Howie asks why the fill handle does what it does when you select four numbers and drag. Episode 1187 discusses trend lines, LINEST, and straight line regression. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Row Height .18″? – Episode 1186

               

In today’s podcast, a quick way to hide the column headers, and a row height in inches Episode 1186 shows you how. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Counting Mondays – Episode 1185

               

Mike and Bill get together for another live dueling podcast, counting the number of Mondays between two dates. Episode 1185 shows you how. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the(…)

Pivot SmartArt – 1184

               

Create a pivot table that drives a SmartArt diagram. Episode 1184 shows you how. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Q1, Q2, H1 – Episode 1183

               

Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.Episode 1183 shows you why.Also, in this episode, a challenge to users – view the podcast for details! …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday(…)

Learn Excel from MrExcel