Today, in Episode #1333, Bob asks if there is an easy way to count how many records are located in each country in a Data Set. Though Bob was hoping for an "=CountByCountry" Function, I employed a Pivot Table instead.

…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 #1332, Mike “Excel Is Fun” Girvin and Bill “MrExcel” Jelen Filter an Excel Database to clear all ‘N’ Records, retaining all other data. Using a variety of methods, see how its done and learn a keyboard shortcut or two!

Dueling Excel Podcast #64…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. [Coming early 2011!!]

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

Tweet

Today’s Learn Excel question comes from Kristine. Kristine asks if a pivot table can be created by combining data from many worksheets? The answer is yes, you can; but the data has to be structured in a particular format in order for this to work. Today, in Episode #1331,  Bill shows us how to accomplish this task.

…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 #1330, Jack asks how to calculate compound growth for a year that is 10 years in the future. Rather than using a table to calculate the growth for each year, Bill uses the Exponent Calculation to  provide the result in one step!

…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

The ‘Screenshot’ feature in Excel 2010 allows you to select from a list and then work with your chosen image. Today, in Episode #1329, Bill shows us how to use the ‘Screenshot’ feature to paste a screenshot of another application into Excel 2010.

From Chapter 12…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, in Episode #1328, Mike “Excel Is Fun” Girvin and Bill “MrExcel” Jelen look at a question posed by ‘Raymond30031′ from YouTube. Basically, arranging 2 Criteria with Multiple Ranges to give us our result, Mike and Bill use the INDEX, INDIRECT and MATCH Functions to lookup the data. Also learn keyboard shortcuts to maneuver through your spreadsheets easily!

Dueling Excel Podcast #63…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. [Coming early 2011!!]

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

Today, in Episode #1327, Bill looks at DAX Measures in Power Pivot 2010. Specify your conditions, learn to manipulate the ‘Calcualte’ Function to customize your measurements in Power Pivot 2010. “PowerPivot For The Data Analyst: Microsoft 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

Conditional Formatting offers the ability to mark duplicates or uniques, but in some respects, it sort of missed the boat. Today, in Episode #1326, Bill looks at how to use a formula-based conditions with VBA to fill voids left by Condtional Formatting.

From Chapter 15…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.

Today, in Episode #1324, Bill shows us how to sort a pivot table field using a custom list as this requires too many steps in PowerPivot.

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

Dueling Excel Episode #1323 with Mike “Excel Is Fun” Girvin and Bill “MrExcel” Jelen looks at Charting methods on both sides of the number line in both Excel 2007 and Excel 2010. Learn Shortcuts, formulas and inherent functions in this episode!

Dueling Excel Podcast #61…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. [Coming early 2011!!]

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

Today, in Episode #1322 of the Learn Excel from MrExcel Podcast, Bill shows us how to have dynamic text within a shape. Use a formula and the Shape tool in Excel 2010 to produce a dynamic visual presentation of your data!

From Chapter 11…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.

Excel 2010 added a cool new search box to the Filter dropdown. Today, in Episode #1321 of the Learn Excel from MrExcel podcast, Bill looks at filtering by multiple [keyword] searches to display results for an industry.

Chapter 16 … 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

PowerPivot enables something called "Asymmetric Reporting". Asymmetric Reporting creates the ability to report Actuals for last year and Budget for this year. Watch as Bill demonstrates this feature of Power Pivot in Episode #1320 today.

…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

Today, in Episode #1319, Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen show us the options available to create a formula that defines the address of a cell containing a total. Using VLOOKUP, MATCH the ADDRESS Function and a few other tricks, getting that address becomes easy!

Dueling Excel Podcast #61…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.

Data is great stuff. Adding a visual component to enhance the appeal of your data? Awesome! Today, in Episode #1318, Bill shows us how to use Microsoft Map Point in conjunction with our Data Set in Excel 2010 to produce a great visual! Try it!

From Chapter 10...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.