Learn Excel from MrExcel: Dana asks if there is a way to link data from one worksheet to another, when the linking data is vertical and it needs to be linked into a horizontal lookup table. Today, in Episode #1334, Bill shows us how this is done.
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. "Excel 2010 In Depth"
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.
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 for this to work. Bill shows us how to do that today in Episode #1331
Note: for a different method using VBA, see: Creating a pivot table with multiple sheets
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!
Today, in Episode #1329, Bill shows us how to select and paste a screenshot of another application into Excel 2010...
This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.
Today, in Episode #1328, Mike Girvin and Bill Jelen look at a question posed by a YouTube fan. 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.
Today, in Episode #1327, Bill looks at DAX Measures in Power Pivot 2010. Specify your conditions, learn to manipulate the 'Calculate' Function to customize your measurements in Power Pivot 2010. "PowerPivot For The Data Analyst: Microsoft Excel 2010"
Conditional Formatting offers the ability to mark duplicates or uniques, but 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 Conditional Formatting.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.