Saying good bye to 2010 and welcoming in 2011, Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen present you with "Red Over 140". In todays Dueling Excel Podcast [Episode #1316] Mike and Bill use a variety of methods to track values that exceed a predetermined threshold. Maybe you'll also need information in cells adjacent to the exceeded value - they'll show you how to get that too!

Dueling Excel Podcast #60…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

AND

“Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

"If you've seen one of my seminars, then you know that my favorite trick is to Double Click the Fill Handle to copy a formula down to the bottom of the Data Set. Excel 2010 handles blank cells in the adjacent column much better than in previous versions." - Bill Jelen

Join us today as we look at how well Excel 2010 really does handle copying Formulas in Episode #1315.

Chapter 14 … This episode is the video podcast companion to the book, “Rev Up to Excel 2010: Upgraders Guide to Excel 2010” by Bill Jelen a.k.a. “MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Considering Upgrading to Excel 2010? Want some help in making an informed decision? Check out Bill Jelen's Blog Post: "Upgrade to Excel 2007 or Excel 2010?"

Tweet

Each of Bill Jelen's 'Learn Excel from MrExcel' Podcasts start with a note about "Easy-XL" . . . but what is it? Learn a little bit about Easy-XL today, in Episode #1314 - an addin that dramatically reduces time spent doing routine tasks in your workbook.

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

Dueling Podcast #59 deals with Sorting Summary Data - collected results of a survey. Counting the responses is easy until it becomes a matter of keeping the reults in the original order. Using Custom Lists, Defined Names and a few Keyboard Shortcuts Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen show us how to accomplish the task with Episode #1313.

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

In Excel 2003, they were referred to as 'Lists'. In Excel 2010 they are referred to as 'Tables'. Today, with Episode #1312, Bill takes a look at 'Tables' and how the use of this feature allows Charts, Pivot Tables and Formulas to grow as the Data Set grows - automatically!

Chapter 13 … This episode is the video podcast companion to the book, “Rev Up to Excel 2010: Upgraders Guide to Excel 2010” by Bill Jelen a.k.a. “MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Considering Upgrading to Excel 2010? Want some help in making an informed decision? Check out Bill Jelen's Blog Post: "Upgrade to Excel 2007 or Excel 2010?"

Tweet

Today, learn how to interact with a Pivot Table - online! In Episode #1311, Bill shows us how to create a Pivot Table in Excel 2010, upload it and then [using the Excel Web Application] create a nice looking Dashboard on the web.

...This episode is the video podcast companion to the book, "Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

 

Bob writes with a question about using AutoFilters when the headings are not in row 1. With Episode #1310 Bill looks at a solution, as well as a method for totaling the visible cells.

 

...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!

 

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

 

Tweet

Create a visual representation of your values without using a Chart. In Episode #1309, Bill shows us how to use the "Pipe" Character ( | ) with the 'REPT' Function to show the variances in a data set - even when the values are very large.

From Chapter 9...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

Today's Dueling Podcast [ Episode #1308 ] looks at sorting data with a Formula. Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen look at the uses of the RANK, VLOOKUP, COUNTIF, LARGE, ROWS, INDEX, MATCH and SMALL Functions - plus a few shortcuts you may find useful!

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

Excel 2010 now contains 400 Functions. Amongst those new Functions is a new Function called ‘AGGREGATE’. AGGREGATE is similar to SUBTOTAL, but with several new tricks, including MEDIAN, LARGE, SMALL, and the ability to ignore Error Values - which Bill will be looking at today, in Episode #1307.

… This episode is the video podcast companion to the book, “Rev Up to Excel 2010: Upgraders Guide to Excel 2010” by Bill Jelen a.k.a. “MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

PowerPivot 2010 offers the opportunity to create up to 4 Charts from your data . . . but what if you need to move beyond that implied limitation to 5 or more Charts? In Episode #1306, Bill shows us how to easily 'make a few connections' and move into the "More Than Four" dimension with PowerPivot and Excel 2010.

…This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

"Go Zips!" The University of Akron mens soccer team wins a National Championship - the First University of Akron sports team to win a National Championship! Today, in Episode #1305, Bill uses the new Excel 2010 Sparkline tool to analyze the 2010 as well as the 2009 'Zips' season.

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

Today, in Episode #1304, Bill shows us how to use a Pivot Table in combination with Excel VBA [Visual Basic for Applications] to 'Roll-Up' dates to weekly increments.

By:=7, _
Periods:= Array(False, False, False, True, False, False, False)

From Chapter 13…This episode is the video podcast companion to the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

Todays Dueling Excel Podcast, Episode #1303 with Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen,  looks at 'Unwinding Dates'. Suppose your dates are input like this: "1997-1999" How can you have each date year list out so that they now appear as sequential: "1997  1998  1999"? You may choose to use Excel VBA [Visual Basic for Applications] or Formulas...but in any event you'll want to watch Episode #1303 to see how its done!

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Today in Episode #1302 Bill shows us how to create a chart for each customer in our database. Using a Pivot Table to manipulate the data, some formatting and the "Show Report Filter Pages" option our task becomes simplified.

From Chapter 7...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet