Learn Excel from MrExcel Video Podcast Podcasts

PodcastDirectory / Technology / Computers
PodcastDirectory / Regions / UN / Unknown

Primary Format : Computers Also Listed as: Computers City : Unknown State/Province : Unknown Country : Unknown Country : UN User Tags: User Votes: RSS Feed Website People found this Podcast Searching for: View this Podcast on a Google Map. Add to iTunes Text Only listing of Learn Excel from MrExcel Video Podcast Podcasts Trumix.com listings available of Learn Excel from MrExcel Video Podcast Podcasts Click Here to Update the directory of this podcasts programs.

Trumix.com listings available of Learn Excel from MrExcel Video Podcast Podcasts Build your own playlists with this podcast. Episode 794 - 40 What-If Scenarios Run many what-if scenarios at once using the Data Table command. Episode 794 will show you how to set up and use this powerful command.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 793 - Pivot Filter Hack Normally, you can not use AutoFilter within a pivot table. Today, Dan from Philly shares an amazing hack that allows you to filter the results of the pivot table. Episode 793 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 792 - Substitute Total Another way to solve yesterday's problem is to use the =SUBSTITUTE function instead of LEFT and LEN. Episode 792 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 791 - Trimming Total After adding Subtotals, Excel will append the word " Total" to the field being subtotaled. In Episode 791, we take a look at how to use a formula to remove the totals so that the data can be used as a lookup table.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 790 - Split Cell Kathy asks how to type numbers in a diagonally split cell. Episode 790 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 789 - Unhide Worksheets II Rather than use a custom view, Episode 789 shows how to create a 3-line macro to unhide all worksheets.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 788 - Unhide Worksheets You can hide 20 worksheets in a single command, but it is very tedious to unhide all worksheets. Episode 788 shows how to use a custom view to unhide all worksheets.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 787 - Consolidate Minus A question from a seminar... how can you use the consolidate command to subtract one data set from another data set? Episode 787 shows you the workaround.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 786 - Data Consolidate An introduction to using Data Consolidate to add two data sets. Episode 786 introduces the concept. Tomorrows episode will throw in an interesting twist.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 785 - Macro Pictures Episode 322 talked about adding pop-up pictures to a cell. Devin asks if there is a way to add many pictures at once. In Episode 785, I use some macro code from page 764 in the book to quickly add pop-up pictures to many cells.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 784 - Wildcard VLOOKUP Tom asks how to do a VLOOKUP with a wildcard. This interesting question has many possible approaches to solve the problem and it will become the June/July challenge of the month. I encourage you to enter our contest to win cool prizes. Watch Episode 784 to see how!This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 783 - Hide Zeroes Back in Episode 767, the podcast dealt with the problem of using =IF(ISBLANK(A2),"",A2) to hide zero values in the results table. Today, Rene and Denis both write in with a far simpler solution. Episode 783 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 782 - Leader Lines...... Hamilton sends in a question about parsing data that has leader......lines between the columns. This ends up being trickier than you might think. Episode 782 shows you how I approached the problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 781 - Unsorted VLOOKUP I keep hearing a common misconception that the lookup table in the VLOOKUP has to be sorted. In many cases, this is not true. Episode 781 looks at the optional fourth parameter of VLOOKUP.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 780 - Distribute Personal.xls Do you have the world's greatest Personal.xls and want to share it with others in your company? Watch Episode 780 for the steps necessary to distribute the personal macro workbook.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 779 - Copy NonBlanks Macro Column I is sparsely filled in with product codes. You would like a macro to copy only the non-blank cells to a new column. It turns out that the macro recorder can actually reliably perform this task. Episode 779 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 778 - Interative TextBox One of my favorite tricks is to fill a textbox with the result of a formula in the worksheet. When you try this as the title in an embedded chart, you need to change the formula to point back to the original worksheet. Episode 778 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 777 - Option Buttons To enhance the chart from Episode 776, I'll use option buttons on the worksheet from the Forms toolbar. Episode 777 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 776 - Interactive Chart Lucy asks how to make a chart interactively change from red to yellow to green based on an external selection. In today's Episode 776, we take a look at the basics of setting up such a chart. Tomorrow's episode will take a look at the Options button on the Form toolbar to enhance the chart. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 775 - Toggle Gridlines In Excel 2003, there is a cool button lurking in the Forms toolbar. This button gives you one click access to show/hide gridlines. I am not a big fan of hiding gridlines, but when it is only one click away, I find myself actually doing so. Also, another tip about using PgDn and PgUp to move between worksheets or between screenfuls of columns. Episode 775 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video ever ... Listen | Listen in your iPhone | Download | View full cache | Episode 774 - Macro Tweaking After recording a macro in yesterday's podcast, I take a look at the recorded code to look for instances where the macro recorder hard coded the number of records. With just a few tweaks, we have a working macro to automate the import and conversion of data from one system to another. Episode 774 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 773 - Google Calendar Pau asks how to take a CSV file from one website and convert it for importing to Google Calendar. In Episode 773, I turn on the macro recorder and attempt to fix the file.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 772 - Landscape Page Numbers You are printing a multi-sheet workbook which is mostly portrait. In the middle, one worksheet needs to be landscape. You would like the page number to appear at the bottom of the portrait page like all of the other page numbers in the document. Episode 772 will show you the steps required to make this happen.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 771 - Color Blind Telling red cells from green cells in Excel is difficult for those suffering from color blindness. In Episode 771, I take a look at a macro that will show the text name of the color in the status bar for any selected cell.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 770 - Moving Average Chart a moving average in Excel. Episode 770 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 769 - IF AND OR NOT Episode 769 looks at the difficult variations on yesterday's podcast; how do you set up an IF statement that will only be true if two conditions are true? This episode will look at using OR, AND, NOT within the logical test of the IF function.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 768 - Multiple IF How do you deal with many levels in an IF statement? Episode 768 discusses nesting IF statements.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 767 - #VALUE Errors A question asks how to avoid #VALUE errors when a formula refers to a cell with a blank text value. In Episode 767, I will take a look at how these blank cells come to be, how to work around the #VALUE error and even a different approach to prevent the root cause of the problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 766 - Hexadecimal Leading It is Memorial Day in the U.S. Since most people are out at a picnic instead of at work today, I tackle an incredibly obscure problem. How can we make sure that Hexadecimal numbers have leading zeroes? Episode 766 will take a look at the HEX2DEC, TEXT, and RIGHT functions. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 765 - Insert Shortcuts You might already know these, but I recently was shown a few cool shortcuts for inserting rows, columns, or cells. Episode 765 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 764 - Freeze Panes The Freeze Panes command allows you to always see certain rows at the top of your worksheet. In Episode 764, I will show you how to use Freeze Panes to always see certain columns as well.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 763 - Protecting Cells When you use Tools, Protect Worksheet, all of the cells become protected. How can you protect only a portion of the worksheet? In Episode 763, we take a look at this problem and protect only the formulas in a worksheet. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 762 - Chart Top Customers A combination of six cool tricks allows you to take detailed transactional data and produce a chart of the top five customers in about 12 clicks. Episode 762 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 761 - Toolbar Customization In Episode 761, a look at three cool custom icons you can add to your toolbar in Excel 2007 or 2003. See how easy it is to use Select Current Region, Select Visible Cells, and Set Print Area.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 760 - No Outliers How can you calculate the MIN or MAX value ignoring one outlier? Or, how can you figure out the MIN or MAX throwing out 5% of the outliers? Episode 760 takes a look at SMALL, LARGE, and PERCENTILE functions.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 759 - Border Color There is a way to set the default border color that is used when you use the Borders dropdown. Episode 759 shows you how. Also, a look at the new Podcast DVD.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 758 - Pivot Unique Can you use a pivot table to measure how many unique combinations of customer and product appear in a data set? Well, you can't do it natively, but in Episode 758, we take a look at a formula such as =IF(SUMPRODUCT(($B$2:$B2=B2)*($D$2:$D2=D2))>1,0,1) which will allow the calculation to work. Also - a look at the Amazon Kindle.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips f ... Listen | Listen in your iPhone | Download | View full cache | Episode 757 - Sliding Commission Michael asks how to calculate a sliding commission rate. Episode 757 shows two approaches, both of which use the sorted version of VLOOKUP.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 756 - Meal Rollover A question from a recent seminar involved calculating how many unused meals occurred during a month. The person had to rewrite several formulas every month depending on the total number of days in the month. In Episode 756, we'll take a look at some changes to allow that formula to work for every month.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 755 - Sort Largest You need to sort a detailed data set so that the records for the largest customer are at the top. Episode 755 will show you a quick way to accomplish this task. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 754 - Create Workbooks Rene from Norway asks how to modify the code from podcast 730 in order to create a new workbook for every department. Episode 754 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 753 - Text Date/Time When Romas sent in the question for podcast 751, I couldn't tell from the screenshot if his data actually was date/time or text that looked like a date/time. In Episode 753, I take a look at how to tell if the cell contains a date or something that looks like a date. You will also see how to use the TEXT, LEFT, MID, DATE functions to convert the text date/time to a real date. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute vi ... Listen | Listen in your iPhone | Download | View full cache | Episode 752 - Truncating to Date In today's podcast, we take a look at breaking Romas' date/time column into a date column using the INT function. Episode 752 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 751 - Grouping Dates Romas has data with both date and time in column A...but needs to summarize the data by date. In Episode 751, we take a look at using a pivot table to solve this problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 750 - Save Settings Do you need to transfer custom lists and other settings from one Office installation to another computer? The Save My Settings wizard will make this a snap. Episode 750 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 749 - Sum Overdue Rob has a spreadsheet showing install dates for several batteries. He needs to sum all of the batteries that are overdue for being replaced. This requires a tricky variation of the SUMIF formula. Episode 749 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 748 - Pivoting Text Terry called in with a question where she wanted to use a pivot table to show text fields from a database. While this question initially threw me for a loop, we did end up with a workable pivot table that showed off text. Episode 748 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 747 - Who is Largest Lucy sends in a question. She has built a table of sales by rep by day. She used the MAX and MIN function to find the largest and smallest value. However, her boss then wants her to identify who had the largest and smallest value. This requires the use of INDEX, MATCH, and a couple of hidden columns. Episode 747 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips ... Listen | Listen in your iPhone | Download | View full cache | Episode 746 - Obscuring Excel Jon has designed a worksheet in Excel that he wants others to use. However, he does not want them to realize they are using Excel. How can he obscure the fact that we are in Excel? Episode 746 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 745 - Create an AddIn  If you want the macro from episode 744 to always be available, you can save it as an add-in and install the add-in. Episode 745 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 744 - Auto-Increment Continuing the information from podcasts 742 and 743, I record a simple macro today to open the Invoice.xlt file and then add a couple lines of code to update the invoice number and the date. Episode 744 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 743 - Save as Template Continuing the series from podcast 742, once you've downloaded and customized the invoice from Office Online, learn how to save it as a template and add it to the New Workbook task pane. Episode 743 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 742 - Invoice Worksheet Rather than create an invoice worksheet from scratch, download a free one from Office Online. Episode 742 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 741 - Compare Columns Daniel from Quebec sends in a better way to compare columns using GoTo Special Column Differences. Episode 741 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 740 - Insert Worksheets II Jerry from Georgia sends in a great alternate solution to podcast 730, inserting one worksheet per customer. Gerry uses the Show Pages feature of pivot tables. Episode 740 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 739 - Menu to Ribbon Two tips for finding an Excel 2003 command on the Excel 2007 ribbon. One is to use the Customize QAT dialog. Pam sends in a cool website from Microsoft that will help you to find the command. The website is here: http://office.microsoft.com/en-us/help/HA101491511033.aspx. Episode 739 shows both methods. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 738 - Unique SN per CN Matthew sends in a cool technique today to find a unique list of serial numbers for every model from a database. Matthew's trick uses about five tricks that you probably rarely use. Episode 738 walks you through Matthew's technique. You will see pivot table calculated fields, paste values, replace, and deleting all zero cells.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from ... Listen | Listen in your iPhone | Download | View full cache | Episode 737 - Excel 2007 Charts Lorin asks if there is anything new in Excel 2007 charts. While Microsoft rewrote the charting engine in Office 2007, you still have the same basic chart types. However, there are new data visualization tools in conditional formatting that allow you to add bar charts to every cell. Episode 737 discusses these new features.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the ... Listen | Listen in your iPhone | Download | View full cache | Episode 736 - Index Match Jon has a follow-up question about his baseball spreadsheet. After calculating the win and loss streaks, he would like to find the longest streak, including the start and end dates. This seemingly simple question requires two completely useless functions. Once these functions are used in conjunction, they become very powerful. Episode 736 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to lea ... Listen | Listen in your iPhone | Download | View full cache | Episode 735 - Win Streak Jon asks how to calculate a winning or losing streak from baseball data. Episode 735 will show you how to build the formulas to calculate a win streak. Also, how to build a column showing Home or Away based on finding an @ sign in the opponent column.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 734 - Bingo No Duplicates If you want to randomly choose from a list and never have duplicates, you can use the method discussed in this podcast. Episode 734 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 733 - Bingo Draw Hamilton asks how to generate a column of bingo numbers, one at a time. In Episode 733, a tiny macro will add random numbers down column A.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 732 - Dates from Text to Columns Jonathan notices a problem when he uses the Text to Columns wizard. Baseball scores such as 4-3 are converted to dates. In Episode 732, we'll take a look at how to keep those scores from being converted.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 731 - Copying Subtotals Only Kerry asks: after adding automatic subtotals, how can you copy only the subtotal rows? Episode 731 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 730 - Insert Worksheets J.B. needs to create a new worksheet for every customer listed on the summary worksheet. He asks if there is an Insert Worksheets command. While there isn't, you can create one with a few lines of VBA code. Episode 730 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 729 - 2003 Icon Sets Chris from Scotts sends in a cool trick today...how to set up an icon set in Excel 2003. Episode 729 takes a look at how to set up this trick.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 728 - Table Formulas Excel 2007's table functionality is cool, but viewer Jim is wondering why Excel is changing his formulas. In Episode 728, we will take a look at how to control this behavior,This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 727 - Building Formulas with Text Bill has a worksheet where he's building text references and then hopes to evaluate the resulting SUM function. Instead, I suggest using INDIRECT to add up the three individual cells. Episode 727 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 726 - Random Drawing Today an idea from Tim in NH. While I frequently use RANDBETWEEN() to do a door prize drawing, Tim adds some bells and whistles to create a nice spreadsheet used to award the prize. Episode 726 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 725 - Row Differences While I've talked about Go To Special many times, I usually use Blanks, Visible Cells Only, or Formulas. Someone asked how to use the Row Differences option. This is a good way to compare if anything changed from one column to another, but it is limited. Episode 725 explores this option. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 724 - Custom Number I used an old custom number formatting trick in yesterday's podcast. Today, we take a look at more possibilities using custom number formats. Episode 724 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 723 - PivotText After summarizing data in a pivot table, you want to replace the numbers with a simple Yes/No text. Yes if they met the condition, No if they did not.Episode 723 will show the rather convoluted process. In the process of creating the pivot table, you will see data grouping, calculated fields, table options, and then a bizarre conditional number format. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to lea ... Listen | Listen in your iPhone | Download | View full cache | Episode 722 - Paul McCartney The PROPER function never manages to capitalize the interior C in McCartney. In today's podcast, an interesting way to solve this problem with a formula. Episode 722 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 721 - Leading Zeroes Many people were missing from the map on last Monday's podcast. Did I miss their entries? No! I use a common Excel trick to keep leading zeroes, but this confused MapPoint. In today's podcast, we take a look at other ways to keep leading zeroes in Excel. Episode 721 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 720 - Dynamic Validation Jonathan is frustrated that his validation scrollbars start in the midst of several blank cells that he set up in his validation list. He was doing this to allow room for future growth in the list.Instead, Episode 720 will show you how to set up a dynamic named list using the OFFSET function.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 719 - Sampling Wale asks how to randomly choose 20 invoices from a population of 500 invoices. Episode 719 will show you two methods for solving this problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 718 - AutoComplete vs Validation Laura, Erik, and Howard all sent in similar workarounds to podcast 713. Today in Episode 718, we will take a look at how to offer a validation dropdown that will allow keyboard afficianados to enter values quickly.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 717 - Event Calendar Matthew from Washington wants to take an event database and create a visual calendar that shows availability.While this sounds simple, it requires several steps. The end result is fairly cool. Episode 717 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 716 - NCAA MapPoint Today, in Episode 716 we take a look at the entries for the MapPoint contest, and also a chance to enter the MrExcel NCAA basketball game.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 715 - PI Day March 14 (3-14) is Pi day and we will take a look at some calculations with the PI and SQRTPI functions in Episode 715.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 714 - Choose Value In yesterday's podcast, we were frustrated that the Validation dropdown would not allow us to type a few letters of the entry. In Episode 714, we will take a look at a tiny userform and macro to replace the validation dropdown. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 713 - Validation Woes In Episode 713, a link to http:/www.mrexcel.com/excel_video_training.html, another link to http://www.mrexcel.com/video2003.html. Then, how to set up a dropdown list in Excel, but some frustration that the dropdown list won't let you type the first few letters of the value.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 712 - First Subtotaled Item Dick sends in a cool question today. First, he figured an amazing way to grab the first value from a subtotaled group. But, Episode 712 shows three lines of VBA code to finish the process.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 711 - Show Pages Do you ever need to produce a report for every customer? This is a snap with pivot tables in Excel 2007. In Episode 711, we take a look at how to use Show Report Filter Pages to replicate a report for every customer.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 710 - Pivot Filters Learn how to filter a pivot table to only items from this week, last quarter, or next month. Episode 710 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 709 - Pivot Dates Excel offers amazing tools to group daily dates to months, quarters, years, or weeks. Episode 709 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 708 - Pivot Sorting Episode 708 shows how Excel offers sorting rules that allow your pivot tables to be sorted in a certain manner. The old AutoSort option is now hidden behind a dropdown in the pivot table field list.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 707 - Changing Pivot To rearrange a pivot table in Excel 2007, simply drag fields to a new drop zone in the pivot table field list. Episode 707 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 706 - Pivot 2007 Create your first pivot table in Excel 2007. Episode 706 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 705 - Pivoting Time Columns It is difficult to create a pivot table when you have a time component stretching across the columns in your data set. In today's episode, an amazing trick in Excel 2007 to change four quarterly columns into four rows. Episode 705 will show the multiple consolidation ranges trick.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 704 - Deleting Blank Rows In today's podcast, a simple process to delete the blank rows by sorting the data first. Episode 704 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 703 - Filling Outline Blanks Continuing the process started in podcast 702, I will take a look at how to fill in all the blanks in the "outline view" of Column B. Episode 703 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 702 - 2-Field Column In today's podcast, we start with a data set where column A contains both Region and Model information. In Episode 702, I'll use formulas to split that data into two columns.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 701 - VBA Userforms Back in Episode 695, I used the InputBox function in VBA to ask for a couple of answers. In today's podcast, I will show you how to convert that macro to use a custom user form in Excel. Episode 701 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 700 - Mapping Data Take your Excel data and plot it on a map using Microsoft MapPoint. Watch Episode 700 to learn how you can win a copy of MapPoint.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 699 - 2007 Pivot Interface Microsoft changed the pivot table interface in Excel 2007. While the new interface is much better, in this lesson, we will take a look at how to bring back the old interface. Episode 699 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 698 - Column Widths Say that you need to copy column widths from one range to another range. The Paste Special dialog now offers the opportunity to paste column widths from one range to another range. Episode 698 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 697 - VLOOKUP or INDEX? Mel sends in today's question. She prefers VLOOKUP, but her husband prefers INDEX and MATCH instead of VLOOKUP. In Episode 697, we'll take a look at when to switch from VLOOKUP to INDEX and MATCH.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 696 - Alt Shortcuts Jim from California suggests that I take a look at the new Excel 2007 Alt shortcut keys. They are pretty cool, with one minor drawback. Episode 696 takes a look.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 695 - Scale Selection In today's podcast, a five line macro that will allow you to scale a selected range. This macro was inspired by engineers in one of my recent VBA seminars. They had been using a similar tool for years and we were surprised it was a five line macro to replicate the tool. Episode 695 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 694 - Double Greenbar As a follow-up to yesterday's podcast, we'll take a look at how to customize the formatting used in the Excel 2007 table formatting. Episode 694 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 693 - Easy Greenbar Excel 2007 offers easy greenbar formatting using the table functionality. While the table functionality offers amazing tools that we'll discuss on another day, today's Episode 693 looks at the few clicks necessary to format a range with alternating row formatting.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 692 - Ditto If you need to copy the *exact* formula from the cell above, there is an amazing shortcut key that will copy this formula down one row. I mean...the exact formula...not a formula with different references, but the exact formula. Episode 692 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 691 - Intersection Operator When specifying function arguments, if you put a space between two ranges, the space operates as an intersection operator. Episode 691 ponders what uses our viewers might have for this operator.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 690 - Page Setup Can you specify rows to repeat at the bottom? Can you specify columns to repeat at the right? Can you have a dynamic page number in the "rows to repeat at top" area? If you are asking these questions, I think you need to investigate the Page Setup Header/Footer tab. It will solve most of these questions. Episode 690 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the ... Listen | Listen in your iPhone | Download | View full cache | Episode 689 - Hiding in 2007 Justin asks how to hide columns in Excel 2007. Finding the command on the 2007 ribbon is a little tough, but Episode 689 shows a way to invoke any Excel 2003 command in Excel 2007.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 688 - Month End Calculate the last day of this month, using a new trick sent in by Bob. Episode 688 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 687 - VBA in 2007 Microsoft hides some of the VBA controls in Excel 2007. Episode 687 will show you how to access the Developer tab in the Excel 2007 ribbon.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 686 - Preventing Spills Ari sends in a better solution to podcast 677. If you want to prevent text from long cells spilling over to adjacent blank cells, the technique shown in Episode 686 works like a charm. This method might even clean up spills faster than Bounty...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 685 - Tracking Runners Marshall from Pennsylvania watched episode 680 from last Friday and came back with a cool use for the same technology: scoring runners in a 5K or 10K race. In Episode 685, we take a look at a simple system in Excel to track the finishing times as you type in bib numbers.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 684 - Bar of Pie In a second attempt to solve Odelia's question from yesterday, I use a bar of pie chart to automatically move all of the pie wedges less than 4% to a secondary chart. Episode 684 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 683 - Chart >4% Odelia is trying to create a pie chart with only the values greater than 4% of the total. Episode 683 shows one method for solving this problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 682 - Quiz Practice Ross is heading back to university and was hoping to use Excel to quiz himself. In Episode 682, I will show you how to use conditional formatting to hide the correct answer until an answer is filled in.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 681 - Indirect Kambiz sends in a question. He has a Summary worksheet that points to Jan, Feb, Mar worksheets in his workbook. When he copies the worksheet to a new workbook, the formulas keep pointing to the Jan worksheet on the original workbook. In Episode 681, we take a look at using the INDIRECT function to solve this problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 680 - Timestamp Florian wants to time stamp a record every time someone types a new name in column A, but the NOW function is not working. In Episode 680, I will show you a few lines of VBA code to solve this problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book Listen | Listen in your iPhone | Download | View full cache | Episode 679 - Pivot Source Data Dan asks another Excel 2007 question. How can you re-specify the source data for a pivot table in Excel? It used to be simple to do this in the pivot table wizard, but it is not obvious how to find the pivot table wizard in Excel 2007. In Episode 679, I will show you how to solve the problem in Excel 2007.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen | Listen in your iPhone | Download | View full cache | Episode 678 - Page Break Preview Dan asks how to find Page Break Preview in Excel 2007. In Episode 678, I will show you how to find Page Break Preview, but also the improved Page Layout View.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Listen |