• Use TextToColumns to Parse - Use the TextToColumns Wizard to eliminate the need...
• Convert Numbers to Text - Are your numeric entries sorting in the wrong plac...
• List Format - Set up your data for flawless use of items on the ...
• Sorting Data - How to sort data in Excel. Episode 232 shows you h...
• Six-Way Sort - The Sort dialog only allows a three level sort. Ep...
• Custom Sort - Sort data into a custom sequence to match the conv...
• Quickly Find Records - Use the AutoFilter feature to quickly find records...
• Unique List - Use the Advanced Filter to generate a unique list ...
• Filtering Criteria - Use the Advanced Filter with a criteria. Episode 2...
• Adding Subtotals - An AMAZING trick for adding subtotals to a dataset...
• Just the Customer Totals - After using the Subtotals function, look for three...
• Visible Cells Only - After yesterday's podcast, I am sure you tried to ...
• Count Revenue - Subtotals worked great all week, but today we enco...
• Scroll Click Click Click - Using the automatic subtotals is a huge timesaver,...
• Totals Up - Sometimes, you might want your automatic subtotals...
• Manager Bliss - Today's episode discusses an obscure trick to add ...
• GPF with co-stars - NateO and Starl join me in Toronto to discuss the ...
• Subtotals Times Two - When you need to subtotal by two different fields,...
• Subtotals Pop - Make your subtotals pop out at the reader. I'll us...
• Blank Row After Each Subtotal - This is a really easy request, but is incredibly h...
• Average & Total - How can you insert both automatic subtotals and au...
• WhatIf 32 - Today's podcast shows an old Lotus 1-2-3 trick tha...
• No Blanks - Two cool ways to get rid of all the blank cells in...
• 2% Across the Board - Time to raise everyone's rates by 2%. An obscure f...
• Combining Records - In today's podcast, I have a single list, but cust...
• Citizen Aquanaut - The last trick for consolidation - how to see who ...
• PivotTable 101 - You have 50,000 rows of transactional data and you...
• Changing Pivot - How to change an existing pivot table. Episode 264...
• Moving Pivot - There is an annoying limitation when you try to in...
• Pivot Doubts - They say that every data set has errors. Once you ...
• Pivot Update - Pivot tables don't automatically update. Episode 2...
• Pivot Zeroes - If you pull out your copy of John M. Nelson's The ...
• Pivot Fields - How to add or remove fields to a pivot table in Ex...
• Show Pivot Detail - Once you have three or more fields in a pivot tabl...
• Go Long! - In Excel 2003 and earlier, you only have 255 colum...
• AutoSort - Why are pivot tables always sorted by customer alp...
• Top Customers - Another hidden option allows you to have the pivot...
• PivotTable PageFields - What if you need to produce a report for each regi...
• AdHoc Reporting - Use Page Fields in a pivot table to create an ad-h...
• Unique Lists - There are many difficult methods for producing a l...
• Fast Pivot Tables - Skip the whole wizard and create a pivot table in ...
• Pivot Average - All of the pivot tables lately have been showing t...
• Pivot Data Fields - Yes - you can have multiple fields in the data are...
• Multiple Data Fields - Pivot Tables look horrible when you try to add two...
• Daily to Monthly - If your pivot table shows data by days, it is just...
• Pivot Table by Week - What if you need to group your daily dates up to w...
• Order Leadtime Report - If you are trying to plan inventory in the warehou...
• Formatting Pivots - While pivot tables are incredibly powerful, they g...
• PivotTable NumberFormat - If you need to change the numeric format in your p...
• No Pivot Totals - Sometimes you need to take the results of your piv...
• Banished Outlines - If there is one thing that bugs me about pivot tab...
• Comparing Lists - I use this trick all of the time. Say that you hav...
• Show Pages - Szilvia from California calls in today with a grea...
• Calculated Pivot Field - Add a calculated field to a pivot table. Episode 2...
• Pivot Charts - Instead of creating Pivot Tables, create your summ...
• Web Query - Rather than copy and paste data from your browser ...
• Web Options - How to control the options for your web query. Kee...
• Data Form - Create a simple data form to help when entering da...
• Parsing Colon - Joe from Florida calls in with a great question......
• Maddening Subtotals - What if you had to total 168 different fields usin...
• Top Five - In episode 358, a great new trick from Adam in the...
• Unique List - If you need to find a unique list of values in any...
• Ad-hoc Reporting - Today's netcast talks about an easy-to-create repo...
• Select Visible Cells - When you have created automatic subtotals and want...
• GetPivotData Function - In Excel 2002+, try to create a formula next to yo...
• Cell Dropdown - If you are creating a worksheet for someone else t...
• Cell Tips - Add a tooltip to each cell in your worksheet that ...
• Parsing Text - In today's episode a caller asks how to split name...
• Parsing Addresses - Sometimes you have a single column with several fi...
• Goal Seek - Use the Goal Seek function to back into an answer....
• Filter Copying - A question from Mike in Oklahoma City. Excel is su...
• MegaMillions Lottery - After Scott?s question for tomorrow?s podcast, I t...
• Text Files I - If you need to import a text file into Excel, you ...
• Importing Delimited Files - How to import a delimited text file into Excel. Le...
• Non-Sorting Dates - Viewer George sends in a column of dates that refu...
• Non-Pivotable Data - In just about every pivot table tutorial, the writ...
• Grouping by Hour - In yesterday?s podcast, I proposed a formula to so...
• 500! - As we hit this milestone, you can win one of a tre...
• Color Pivot - There is a cool but subtle way to select all of th...
• Pivot Sections - Say that you have a pivot table with region and pr...
• Wildcard CountIf - Thanks to many viewers who wrote in after Episode ...
• Subtotals Count - Why does the automatic subtotals command sometimes...
• Center Sorting - George has a dataset today where a serial number c...
• Sorting by Month - Mario writes in with a comment about Episode 507 o...
• Rearranging Columns - Mary from Chicago asked how to rearrange columns i...
• Rearranging all Columns - In yesterday?s podcast, I showed how to rearrange ...
• Adding Headings - Today?s problem involves a complex data set with h...
• Multiple Consolidation 2007 - Rivky writes in to ask how to do multiple consolid...
• Text to Columns - Going back to Podcast 453, I talked about taking d...
• Monthly Subtotals - If you have a column of daily dates, how can you s...
• Moving Columns III - Derek from the UK checks in with yet another way t...
• AutoFilter Doesn?t Contain - Joe asks about using custom autofilters with Excel...
• Missing Pivot Dates - Today?s question is a follow-up to yesterday?s que...
• Show All - After you?ve used an AutoFilter to see just a few ...
• Frequency Distribution - Creating a Frequency Distribution with the FREQUEN...
• Filter Most Recent - Alicia and George have sent in similar questions; ...
• Sorting Subtotals - Say that you add automatic subtotals and collapse ...
• Pivot Rearrangement - Sometimes, you might need to rearrange the heading...
• AutoFilter Navigation - Joe Marten sends in today?s tip; how to quickly na...
• Recent Records - How can you find the most recent record for each c...
• Pulling Web Data Into Excel - Maxwell asks how best to pull web data into Excel....
• Pivot 2007 - Excel 2007 offers new pivot table functionality. E...
• Year vs Year - Hiro asks how to build a pivot table to show year ...
• Subtotal Row Formulas - Debbie from Virginia asks about adding new calcula...
• Pivot Source Data - Change pivot table source in Excel 2007.
• 2007 Pivot Interface - Bring back the Pivot Table drag-and-drop interface in Excel 2007
• Deleting Blank Rows - Sort data to move blanks to the bottom of the data set.
• Validation Woes - Why validation dropdowns don't jump to an entry when you type the first letter.
• AutoComplete vs Validation - Use AutoComplete and Validation to allow easier entry of values.
• Sampling - Choose a random sample of 20 invoices from a population
• Row Differences - Finding differences between two columns using Go To Special Row Differences
• Table Formulas - Stop Excel from created calculated columns within a table
• Copying Subtotals Only - Copy the subtotal rows from the automatic subtotals
• Dates from Text to Columns - Prevent Text to Columns from converting 7-3 to a date

• Excel training videos about Charts
• Excel training videos about VBA
• Excel training videos about Pivot Tables
• Excel training videos about Data Analysis
• Excel training videos about Formulas
• Excel training videos about Formatting
• Excel training videos about Printing
• Excel training videos about Excel 2007
• Index to all videos

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.