Look Who it Was Random video

Excel - New Books - Excel for the CEO & Excel for Auditors - Episode 364

649 views · Published 4 November 2009 · 2:43 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: New Books - Excel for the CEO & Excel for Auditors.

Welcome back to the MrExcel netcast! I'm Bill Jelen and I have some exciting news to share with you. We have two new books that just came out this week - "Excel for the CEO" and "Excel for Auditors". "Excel for the CEO" is perfect for anyone new to Excel or those running a small business. And "Excel for Auditors" is a comprehensive guide on how auditors can utilize Excel in their work. Both books are filled with practical examples and tips that will help you excel in your Excel skills.

Speaking of auditors, I will be in New Jersey this Thursday, October 19th, 2006, for a power Excel seminar hosted by the Institute of Internal Auditors. Even if you're not an auditor, you are more than welcome to attend and learn some great Excel tips that are useful for everyone. If you can't make it to New Jersey, don't worry, I have upcoming dates in Boise, Akron, Columbus, Indiana, Cleveland, and Green Bay. Check out our website for more information on these events. I would love to meet some of our podcast viewers, so make sure to come up and say hi!

Now, let's dive into a quick example from "Excel for Auditors". One of the common tasks in Excel is finding a unique list of customers from a large database. The typical way to do this is by using the Advanced Filter, which can be a bit complicated. But here's a better and simpler way - create a Pivot table! Just select a single cell in your data, go to Data, PivotTable and PivotChart Report, and click Finish. Then, double-click on the Customer field and voila! You have a unique list of customers. To use this list, simply copy and Paste Special Values to wherever you need it and then delete the Pivot table. Using a Pivot table is a much faster and easier way to create a unique list of anything in Excel.

Thank you for tuning in to this netcast from MrExcel. Don't forget to check out our new books and upcoming events. And if you have any suggestions for future topics, please leave them in the comments below. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Introduction and new book releases
(00:26) Upcoming seminar dates
(01:07) Quick example from "Excel for Auditors" book
(02:00) Faster method for creating a unique list using a Pivot table
(02:22) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Advanced Filter in Excel
Creating unique lists with Pivot table
Data filtering
Excel for Auditors book
Excel for the CEO book
Excel tips
Institute of Internal Auditors
Paste Special Values
Pivot table
Power Excel seminar
Unique list of customers


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152733/


If you need to find a unique list of values in any column, there are a couple of ways to find the unique values in a column. Episode 364 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel