Home Archives for Advanced filter an Excel data list
August 6, 2012 3 Comments

My Top 10 Most Viewed Excel Tutorials on YouTube Year-to-Date in 2012

DannyRocksExcels on YouTube

DannyRocksExcels on YouTube

Later this month, my YouTube Channel – DannyRocksExcels – will surpass 1.8 million views! Thanks to everyone who has visited, watched, and commented on my Excel video tutorials these past four years!

Top 10 Most Viewed Videos – January thru July, 2012

According to my YouTube statistics, these are the 10 most viewed Excel video tutorials on my channel. Click on the Links to watch any video on YouTube :

  1. How to Merge Multiple Excel Workbooks to a Master Budget – views year-to-date 39,338
  2. How to Use Advanced Filters in Excel – views year-to-date 29,700
  3. How to Use an Excel Data Table for “What-if” Analysis – views year-to-date 27,301
  4. How to Add a Check Box Control to an Excel Form – views year-to-date 27,171
  5. Consolidating Data from Multiple Excel Worksheets by Position – views year-to-date 26,517
  6. How to Create an Interactive Pivot Chart – views year-to-date 24,858
  7. Compare Two Excel Lists to Spot the Differences – views year-to-date 23,826
  8. Create Interactive Excel Forms by Including Option Boxes – views year-to-date 20,665
  9. How to Use the VLOOKUP Function in Excel – views year-to-date 20,574
  10. Import Excel Data Into MS Access – views year-to-date 18,288

Learn More Tips, Tricks, and Techniques for MS Office Programs

The 50 Best Tips DVD-ROMs

The 50 Best Tips Series of DVD-ROM’s

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – where you can purchase my video training resources.

The 50 Best Tips, Tricks & Techniques Series

Click on the link to go directly to the information page for each title. You will see a list of the 50 Tips and Ru Times for each title:

100% Satisfaction Guaranteed!

I stand 100% behind the quality of my products. I will refund your purchase price if, for any reason, you are not 100% satisfied – with no questions asked!

Thank you for your support through the years!

Danny Rocks

The Company Rocks

Link to this post!
Filed Under: Excel Training, Most Viewed Excel Videos, Online Store for The Company Rocks, Video Training Courses, YouTube Videos by Danny Rocks Tagged: , , , , , , , , ,
August 6, 2008 1 Comment

Learn to filter and copy unique records in an Excel list

Frequently, you need to find and copy the unique records in an Excel data list. For example, you might be preparing to send out a direct mail piece and you want to clean you list first.

Having the unique records copied to another location might help you to spot glaring errors from faulty data entry.

Here are the steps to follow in this video lesson:

  1. Highlight the data that contains the records you wish to filter. This could be the entire data lis or just one column / field.
  2. Select Data, Filter, Advanced Filter. Be sure to select “Copy to another location and to check the “Unique records only” box.
  3. Click the starting cell where you want to place the copied “Unique records” and then click OK.
  4. You may wish to use the AutoFilter to select the data entry errors for correction.

Find the Excel Video Lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

Link to this post!
Filed Under: Excel Data Tables and Lists, Excel Training Tagged: , ,