
Excel Video Lessons
You don't need to go spend an entire day at the local computer chain store to learn Excel. There are over 600 quick (24 minute) lessons available here, for free.
Directory of Excel video tutorials from Mr Excel
 Show Full Menus All of the Time  Show full menus in Excel 2003 and earlier.
 Excel Standard & Formatting Toolbars  Quit hiding half the toolbar icons.
 New Icons  Add favorite icons to your toolbars.
 Secret Menu Items  Hold down the shift key to find secret menu items.
 Recent Files  Increase the number of files in the recently used file list
 Workspaces  Group files into a workspace so you can open them with one command.
 Cursor Direction  Change the direction that the cursor moves.
 See Headings  See Row 1 all the time as you scroll down.
 See Columns  See column A all the time as you scroll right.
 Print Titles  Print row 1 at the top of every page.
 Print Titles II  Select column headers from the middle cells on a p...
 Footers  Headers & Footers  Add text to print at the top o...
 Page Numbers  Change a multiple page report to print as one page...
 Arrange Windows  Arrange windows to see data from two or more open ...
 Arrange Worksheets  Arrange windows to view two worksheets in an open ...
 Default Workbooks  Have Excel always open certain workbooks. Episode ...
 Startup Switches  Set up Excel icons to open a specific file on star...
 Customize Startup  Use a simple macro to further customize startup wh...
 Customize Defaults for New Workbooks  Do you ALWAYS turn on Page 1 of n as your footer? ...
 Open a Copy  Open a copy of a workbook to make sure you don't a...
 Finding a File  Can't find a file? Use the file open command to so...
 Suppress Update Links  Suppress the update links message alert box when s...
 Send EMail  Send Excel file via email as an attachment direct...
 Export Data  Export Excel Data for Other Applications  Do you ...
 Faster Macros  Have Excel calculate Excel macros faster by instal...
 Word Processing  Use Excel as a word processor to properly format t...
 Spell Check Region  Spell check only specified region or text instead ...
 Hyperlink Menu  Create an easy to use menu by inserting hyperlinks...
 Paste Special  There is a lot of power in the various PasteSpecia...
 Custom Toolbar  Create a totally new toolbar customized with the i...
 Reset Toolbar  Learn how to use the customize dialog box to reset...
 Best Trick Ever  Quickly copy a formula to all rows of data. Have y...
 Turn Data On Its Side  Quickly copy a formula to all cells in a row. Then...
 Stop Autocorrecting  Stop Excel from autocorrecting certain words. Epis...
 AutoCorrecting  Typing the same, long word over and over in a repo...
 Track Changes Woes  Track Changes is a fantastic feature in Word. It i...
 Copy to Worksheets  Let the Fill Across Worksheets command copy data f...
 Talk with Excel  Have Excel talk to you! Excel will read back data ...
 Special Symbols  Learn how to insert special symbols into your Exce...
 Numbers as Text  Have Excel find numbers stored as text. Episode 14...
 Relative References  Have Excel copy a formula to other cells using rel...
 Absolute References  How to have a cell reference in a formula always p...
 Mixed References  Sometimes you need a formula to always point to a ...
 References  Create formulas using relative, absolute, and mixe...
 Faster Dollar Signs  Use a shortcut to simplify dollar sign entries in ...
 R1C1 References  Learn Excel's R1C1 referencing to understand formu...
 Named Ranges  Create easier to understand formulas with named ra...
 Named Constants in Excel  While many know that you can assign a Name to a ce...
 Natural Language Formulas  Natural Language Formulas  Create formulas using ...
 Natural Language Formulas II  Part II of Natural Language Formulas shows you how...
 Named Formulas  A reader has a similar formula in thousands of cel...
 Total without Formulas  When your manager calls on the phone and starts dr...
 Quickly Average Without a Formula  The quick sum feature discussed in episode 152 has...
 Add two columns without using formulas  Use the Add option on the PasteSpecial dialog to a...
 Calculate Sales Over Quota  An introduction to using the IF function to change...
 Text Calculations in Excel  Use Excel to calculate text. In this podcast, lear...
 Break apart a column  Use the LEFT function to return just the leftmost...
 MID Function  If you need to extract characters from the middle ...
 Get characters up to the Dash  The Left, Mid, Right functions are great, but what...
 Get characters after the Dash  Yesterday's podcast showed how to use LEFT and FIN...
 Get characters after the 2nd Dash  Another twist today  how to get characters that o...
 Use TextToColumns to Parse  Use the TextToColumns Wizard to eliminate the need...
 Joining Text and Paste Special Values  Have you ever deleted a column, only to find out t...
 Random numbers in Excel  Sometimes you need to create random numbers for a ...
 Sort to a Random Sequence in Excel  Another great feature of the Rand Function is sort...
 Create a Dice Simulation in Excel  Use the random number generator to create dice in ...
 Creating Random Letters in Excel  Not only does the Rand Function create/sort random...
 Convert Numbers to Text  Are your numeric entries sorting in the wrong plac...
 Calculate a Loan Payment  Buying a cool new car or a house? Use Excel to cal...
 Calculate Many Scenarios for Loan Payments  Want to see calculations of a loan payment if diff...
 Get Help on Any Function While Entering a Formula  Instant help with function arguments: Do you remem...
 Finding Functions  Confused when your manager asks you to do some str...
 Three Methods of Entering Formulas  There are THREE popular ways for entering formulas...
 AutoSum  Use the AutoSum button to quickly total columns of...
 AutoSum Woes  Why the AutoSum icon doesn't always work. Learn th...
 AutoAverage?  Yes  you can use the AutoSum icon to find average...
 Who Taught Excel How to Count?  Why does Excel say I have two cells when any seven...
 Number My List  How to add numbers to a list so that the numbers w...
 Rank Function  Do you need to determine where you rank in a list?...
 Sorting With A Formula  Need a Top Sellers Report? Use the VLOOKUP Functio...
 Kissing Your Sister  Ties can really screw up the RANK function. Learn ...
 Commenting a Formula  Have you just racked your brain to figure out an o...
 Calculate a Moving Average  When you are trying to analyze product demand for ...
 Straight Line Estimate  One of the simplest ways of forecasting is to assu...
 Multiple Regression  Why does Sally's ice cream stand either have a boo...
 Debug a Formula  Do you have a complicated formula? Use the F9 key ...
 Quick Calculator  One of the simplest tricks in Excel. See how to do...
 Formula Frustrations!  Frustrated because you've entered a formula and in...
 Calculate Percentage of Total  How to enter a formula to calculate percentage of ...
 Running Percentage of Total  I hate it when a calculation requires two differen...
 Powers in Excel  Exponents gave me headaches in math class, but the...
 The Root of the Problem  How to calculate square roots, cube roots, fourth ...
 Growth Rate  Your company is growing, but how fast? The formula...
 Like a Big Pizza PI  Whether you are figuring out the best pizza deal o...
 Starbucks or the Lottery?  I spend a couple bucks a day on Starbucks, UNLESS ...
 Steven Spielberg  Question: What do Steven Spielberg, an 8th grade m...
 Max, Abs and Forecast Error  Bill Jelen is the only guy on the planet who wants...
 Round Up to the Nearest 5  Today, MrExcel handles yet another maddening reque...
 Floating Along  Why does that simple price show up as $2.099999999...
 When 2 + 2 = 5  Are you updating numbers in your worksheet but the...
 Order of Operations  Excel has a certain order that it will perform a c...
 Claiming Dependents  It is tax time, but THESE dependents are not the k...
 Finding Precedents  When you have a large formula, all of the cells th...
 More Precedents  Use the Formula Auditing tools to find all of the ...
 Slow Motion Instant Replay  Rather than drawing a million blue arrows on your ...
 Time Formats  Learn the obscure formats to make your time calcul...
 Time Entered as Text  Someone entered a million time values as text. How...
 Time as Text Part 2  In today's episode, someone keyed in hundreds of c...
 Relay Races  10 runners each ran for about 3 minutes and Excel ...
 Daily Dates to Month  Make a series of daily dates appear as a month. Ep...
 Daily Dates to Months for Real  OK....the trick that I used in podcast 210 happene...
 Last day of February?  How can you convert a date to the last day of the ...
 Set up a Simple Time Sheet  What? I work hard all week and Excel can't add up ...
 Lucent or Lucille Ball  Learn how to compare two list to find an exact mat...
 Using VLOOKUP instead of MATCH  Use VLOOKUP to find the exact match when comparing...
 Matching Customers Using VLOOKUP  Compare and then add new customers and update reve...
 Gotchas when using VLOOKUP  Is VLOOKUP not finding all your entries? Find out ...
 COUNTIF  If you need to count records, use the COUNTIF func...
 Headcount by Department  I hate when senior managers ask for headcount by d...
 Age Discrimination  I can't help but thinking that this request is goi...
 Total Sales by Rep  Use the SUMIF function to figure out the total sal...
 Sales by Product and Rep  As you learned this week, SUMIF and COUNTIF are th...
 Ctrl+Shift+Enter  Learn about superpowerful amazing formulas that y...
 Bonus Payments  How to use Logical Formulas, along with the AND an...
 Down with IF  Use an old boolean logic trick to eliminate the IF...
 SumIf with 2 Conditions  Once someone learns SumIf they soon want to know h...
 Lake Wobegon  In Lake Wobegon, they say that all of the students...
 Beat Bob Barker  Rather than play the higher/lower game with Excel ...
 Protect Formulas  How to protect only the formula cells in your work...
 List Format  Set up your data for flawless use of items on the ...
 Two Rows in One Cell  If you need a long heading in a single cell, use t...
 Sorting Data  How to sort data in Excel. Episode 232 shows you h...
 SixWay 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 ...
 Old Accountant's Trick  Today, I am appearing at the IMA Continuing Educat...
 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 costars  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 123 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...
 Wal*Mart  Using the replace dialog gets tricky when you need...
 Lost & Found  For every accountant who has ever tried to produce...
 Joining Two Lists  In today's podcast, we have two lists of customer ...
 Combining Records  In today's podcast, I have a single list, but cust...
 Citizen Aquanaut  The last trick for consolidation  how to see who ...
 Numbering Records  I  In today's podcast, you want to assign a sequentia...
 Numbering Records  II  In today's podcast, you want to assign all of the ...
 1 Record on 5 Rows  Today, we deal with the most annoying dataset  ea...
 Customer SubHeadings  In today's dataset, someone tried to make a report...
 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 adh...
 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...
 Leading & Trailing Spaces  Kevin from Chicago called to ask how to remove lea...
 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...
 End of Month  Jackie from Chicago calls in with today's question...
 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...
 Calculated Items  Unlike the calculated field in yesterday's podcast...
 Pivot Charts  Instead of creating Pivot Tables, create your summ...
 XLS in Data Query  This is a fairly wild concept. Sometimes you want ...
 Web Query  Rather than copy and paste data from your browser ...
 Web Options  How to control the options for your web query. Kee...
 Fresh WebData  Would you like to keep your web queries fresh? Pul...
 Replace Malfunction  I have this data and I am trying to replace the sp...
 Data Form  Create a simple data form to help when entering da...
 Quick Formatting  Make your boring black and white spreadsheets come...
 Styles  Microsoft Word gurus suggest using Styles in Micro...
 OneClick Charts  This is the first of several podcasts about creati...
 Chart Location  Charts can exist either on their own chart sheet o...
 Chart Formatting  Why do Excel charts look so horrible? Learn how to...
 Pi Rotation  Why do pie charts look so horrible? Episode 306 wi...
 Data Drop  Do you have to recreate charts each month? Learn ...
 Parsing Colon  Joe from Florida calls in with a great question......
 Future Charting  Can you predict the future with Excel? MrExcel thi...
 Profit Waterfall  The profit waterfall chart is a great way to show ...
 Conditional Rank  Ethan calls in with today's question  how to rank...
 2007 Visualizations  Episode 312 features a preview of one of the cool ...
 Splitting Rows  There is a worksheet where every row in column A i...
 Copy Formatting  You have 12 reports. After formatting the first re...
 Excellers without Borders  Have you ever tried to copy a formula, only to hav...
 Comment Yourself  Leave yourself helpful notes in the spreadsheet. A...
 Garbage characters  Joel & Jared send in better ways to handle getting...
 Formatting Comments  If your cell comment is too long for the standard ...
 Visible Comments  Keep your comments always visible to guide people ...
 Comment Name  How to change the name in your comments, and the a...
 Comment Shape  Change your cell comments to fun shapes. Episode 3...
 Popup Pictures  Hover over a cell and have a picture pop up. Episo...
 Background Photo  Replace the plain white background in your workshe...
 Printable background  Yesterday's podcast talked about how to use a pict...
 Underline This!  Are you frustrated that Excel automatically turns ...
 Standard Width  Need to resize columns without unhiding the hidden...
 Numbering Pages  You might have many worksheets in your Excel workb...
 Quick Hideaway  Today's podcast talks about a quick and easy way t...
 Hiding Columns  If you need to remove columns from a printout, you...
 Quick Unhide  Do you need to temporarily see the values in a hid...
 Complex Printouts  What if the top section of your worksheet has colu...
 Far Out  Keep an eye on some distant faroff cells. Rather ...
 Watch Window  If you are using Excel 2003, use the new Watch Win...
 Page Breaks  The difference between automatic page and manual p...
 Page Break Preview  How to use Page Break Preview mode to see all of y...
 Fitting Report  How to make a report fit to one page wide by hundr...
 Hiding Errors  Need to print a report quickly but don't want the ...
 Tab Color  Change your worksheet tab colors  a new feature i...
 Format Painter  Today I show you a great trick for copying formatt...
 True SmartTags  Why does every TRUE value in your worksheet get a ...
 Printing Row Numbers  How to print your worksheet with the row and colum...
 Without Borders  Do you get annoyed when you copy a formula and the...
 Double Underline  Tricks for adding a double underline to your cells...
 Border Details  The complete guide to applying borders to a select...
 Shrink To Fit  How to make a value that is slightly too large for...
 Fractions  Change the decimals in your spreadsheet to display...
 Andy's Problem  Andy Cyber Walker once asked me what seemed like a...
 Max or If  Calculate Sales over Quota using either the IF or ...
 Chart Data  In Episode 349, learn a cool way to add new data t...
 Total Visible Rows  There is another way to use the AutoSum icon in th...
 Maddening Subtotals  What if you had to total 168 different fields usin...
 Numeric Keypad  If you have a lot of numeric data entry to complet...
 Fabulous F4  Sure, you probably know that the F4 key can be use...
 Page 3 of 12  Are you frustrated that as you print each workshee...
 Column Negation  Your company system produces a data export where a...
 Customizing Icons  You probably know that you can add new icons to yo...
 Date Differences  You have two dates in Excel and want to find the e...
 Top Five  In episode 358, a great new trick from Adam in the...
 Circular Data Entry  A great call from Georgia  how to ease the data e...
 PageBreak Every 35th  Today on Episode 360, a viewer question stumps MrE...
 Swap Rows & Columns  Bruce from Texas calls in today with an Excel prob...
 Pasted WebData  When you copy and paste data from a web browser to...
 Delete Objects  There is a secret icon that will let you select al...
 Unique List  If you need to find a unique list of values in any...
 Scroll Area  Back in August, the podcast showed a trick for pre...
 Arrows  Use the drawing tools to highlight data on your wo...
 Circling Cells  Using the circle tools on the Drawing toolbar to c...
 Adding Shapes  Use the AutoShapes to draw any of 70+ different sh...
 AutoShape Text  Create cool headlines by adding text to your autos...
 AutoShape Formulas  Rather than static text in the AutoShape, use a fo...
 TearOff Pallettes  A little known trick in Office  how to force the ...
 Custom Charts  Once you have customized a chart, add the chart to...
 Charting Magnitude  Sometimes you want a chart to show two different k...
 Logarithmic Scale  If you need to create a chart where each series co...
 Adhoc Reporting  Today's netcast talks about an easytocreate 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...
 Offsheet Validation  Yesterday's netcast showed how to set up data vali...
 Validation Messages  When you set up a validation dropdown, Excel won't...
 Indiscriminate Validation  Sometimes you want to have cell validation, but yo...
 Cell Tips  Add a tooltip to each cell in your worksheet that ...
 Dependent Validation  Setting up data validation lists, where the second...
 Formatting Macro  Someone posed this question in a recent Power Exce...
 Target Diagrams  Create a target diagram in Excel, using the busine...
 2nd Tuesday  Ken from Chicago calls with a tough question  how...
 MegaFormula Copying  Sometimes when you have a difficult formula like t...
 Org Charts  Create an Org Chart in Excel. The org chart tool i...
 EyeCatching Titles  Add visual interest to your reports by adding a co...
 Grey Background  Jim from Montreal calls in today to ask if there i...
 Ribbon Minimization  Starting on Tuesdays and Thursdays, I will be taki...
 Leading Zeroes  Have you ever tried to enter an ID number that sta...
 Shortcut Keys  It's another Excel 2007 Thursday. I'll take a look...
 Copy Values  Today's tip comes from Dave in Columbus, Indiana. ...
 Parsing Text  In today's episode a caller asks how to split name...
 Data Visualization  A look at Excel 2007 data bars and color scale fea...
 Leading Zeroes  A much better way of showing leading zeroes. After...
 QAT Taming  The only toolbar that is easy to customize in Exce...
 Workday Calculations  There are a couple of obscure functions in the ana...
 OffSheet Precedents  It is a real pain to try to trace precedents that ...
 Big Grid  Excel 2007 sports a massive grid. Take a tour of c...
 Find #####  When a number is too large to fit in the width of ...
 2007 Formats  Actually  there are three different file formats ...
 AutoShape Defaults  Have you ever needed to create many similar autosh...
 Morphing AutoShapes  Although Excel offers 100+ builtin AutoShapes, yo...
 Color Sort  New in Excel 2007  you can sort by cell color! To...
 Logo Shapes  Use the freeform tool to make a 3D version of you...
 2 Column TextBox  How to use Excel as a word processor. This episode...
 Function Wizard  Learn how to use a simple Englishlanguage query i...
 Absolute References  Sometimes, you want to enter a formula where one r...
 Expanding FormulaBar  Do you notice that in Excel 972003, if you have a...
 Joining Text  How to join text from two columns using the concat...
 Mini Toolbar  Get quick access to all of the text formatting com...
 Joining Dates  If you try to use the concatenation character to j...
 Removing Duplicates  Excel 2007 offers powerful new features for removi...
 Mapping Data  Microsoft MapPoint is a great product that will al...
 Parsing Addresses  Sometimes you have a single column with several fi...
 Table Formatting  Excel 2007 adds new table intelligence that you ca...
 Adaptive Menus  In Excel 20002003, if you open a menu and only se...
 Table Extending  Once you have defined an Excel 2007 table, Excel w...
 Recent Files  This netcast has a couple of tips from Tools  Opt...
 Customizing Toolbars  Learn some new tricks with your Excel 972003 tool...
 Table Formulas  One of the best features of the new Excel 2007 tab...
 Toolbar Hyperlinks  More tricks for your Excel toolbars, including how...
 Table Formatting  Six accent colors x 7 options x 20 themes x your i...
 April Fools  One of my favorite April Fools Day tricks involves...
 Gantt Chart  This cool trick shows you how to create a Gantt ch...
 Table Filters  Excel 2007 offers amazing new AutoFilter functiona...
 Dr. Fill  Use the Fill Handle to extend a series. Episode 42...
 Free Book  Sign up to get a free chapter each week of my new ...
 Fill Weekdays  If you work Monday through Friday, Microsoft has a...
 Filling Bagels  Sure, Excel can fill in the months of the year. It...
 Excel 2007  Office 2007 debuted at midnight last night. In Epi...
 Ribbon Mapping  As you dive in to get all the great features in Ex...
 OneNote  The Home & Student edition of Office 2007 includes...
 Goal Seek  Use the Goal Seek function to back into an answer....
 Adding Without Formulas  Did you ever notice the status bar below your spre...
 Translate  Excel 2007 offers an oddity  an icon to do transl...
 AutoFilter Woes  Jim from Montreal calls in wondering why the AutoF...
 Virtual AutoFilters  Excel 2007 does offer a number of improvements in ...
 Paste Formulas  Eric from Shanghai writes in with a question about...
 Combo Chart  How to create a combination chart that includes bo...
 Undo Toolbar Customizations  If you have inherited a computer where someone has...
 Overlay Charts  In a recent charting challenge, Jerome Sullivan se...
 Filter Copying  A question from Mike in Oklahoma City. Excel is su...
 PieChart Lies  Watch out when someone tips a pie chart backwards ...
 Dates as Numbers  Here is a bizarre problem sent in by a viewer. Man...
 Cone Chart Lies  Another popular way for people to lie with charts ...
 Unhide One Column  Stuart from the UK asks: say that you have columns...
 Hidden Column Tricks  As a followup to yesterday?s netcast, Episode 450...
 Filling an Outline  Heidi asks a question that is a new twist on an ol...
 Formula for Worksheet Name  Rupal asks how to return the worksheet name as the...
 MegaMillions Lottery  After Scott?s question for tomorrow?s podcast, I t...
 Lotto Probability  Scott from Australia sent in what should have been...
 OFFSET  Joe writes in with a question of how to subtract t...
 Chart Resizing Problems  Dan from Akron notes that when he inserts new colu...
 Text Files I  If you need to import a text file into Excel, you ...
 Importing Fixed Width Files  In our continuing look at importing text files, to...
 Importing Delimited Files  How to import a delimited text file into Excel. Le...
 Page Breaks Disappear  Dan has an unusually wide spreadsheet where the pa...
 March Madness  You are invited on Monday to download MrExcel?s NC...
 Entering Teams  March Madness has begun and commissioners in offic...
 Checking Data Entry  The first entries in the NCAA office pool are star...
 Gathering Entries  In offices throughout the US, people are starting ...
 Formulating the Future  As the NCAA games start today, the commissioner ne...
 Leading and Interior Spaces  Episode 466 shows how to get rid of leading spaces...
 Umlas Magic  Today?s podcast is the first in a series featuring...
 Dreamboat Formatting  I realize this is the Learn Excel podcast, but we ...
 Organizing Chart Data  Our guest host today is Jon Peltier. Jon maintains...
 Conditional Formatting  Today?s guest podcaster is MVP Zack Barresse. Zack...
 Fill Control  Today?s guest podcaster is Curt Frye, author of th...
 Quick Transpose  Do you need to turn data on its side in Excel 2007...
 Formulas in Word  Sure ? it is easy to add up a column of numbers in...
 Daily F9  Dick Kusleika is our guest podcaster today. Dick i...
 Double Validation  Excel MVP from Brazil Robert Martim shows how to s...
 April Fools  Bill?s favorite Excelrelated April Fool?s day tri...
 Cy Young  Play ball! In honor of baseball?s opening day, lea...
 Utilities for Excel  Today, an interview with Andrew Engwirda, author o...
 Parsing Irregular Text  Jason sends in our question today. He has a single...
 Text Dates  After importing data, your numbers and dates might...
 Leading CSV Zeroes  If you have a CSV file, you will always lose any l...
 Hide by Grouping  Today, Scott W sends in a better way to hide and u...
 Be Challenged  There is one week left to enter the current challe...
 VLOOKUP vs MATCH  The VLOOKUP function is one of the most versatile ...
 Index & Offset  These two functions allow you to dynamically point...
 Match & Index  In today?s podcast, we have hundreds of rows of VL...
 VLOOKUP LEFT  To finish up the recent discussion of VLOOKUP, IND...
 Classic Menus 2007  Bill Gates asked the question: ?The ribbon is fine...
 NonSorting Dates  Viewer George sends in a column of dates that refu...
 Sum Bold  Mudit asks, is there any way to sum just the bold ...
 Tricky Validation  Mike writes in with a question that is way too har...
 Chart to PowerPoint  Bob from Dallas writes in with a question. Bob has...
 NonPivotable Data  In just about every pivot table tutorial, the writ...
 Time Stripping  Jonathan from California has a column with date & ...
 Grouping by Hour  In yesterday?s podcast, I proposed a formula to so...
 Quick Zooming  Do you hate the Zoom control on the standard toolb...
 Finding Substrings  George sends in a question ? How can COUNTIF be ma...
 Running Average  In today?s netcast, a question about how to create...
 Spelling Numbers  George sends in a question ? how can you convert a...
 500!  As we hit this milestone, you can win one of a tre...
 Data Entry  Today?s podcast shows a better way to do data entr...
 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...
 Connecting Shapes  If you use the shapes on the drawing toolbar such ...
 Wildcard CountIf  Thanks to many viewers who wrote in after Episode ...
 Excel Gradebook  Christina asks how to create a gradebook in Excel....
 JanFebMar Conversion  Your crazy software exported a file where the date...
 Add a Dash  If you need to spice up a column in your report, E...
 Corralling Students  Christina asks how to make sure that the students ...
 Dismissing AutoFill  When you drag the fill handle, Excel offers an ext...
 Filling Blanks  While yesterday?s podcast talked about using the F...
 Moving Average  Ricardo sends in a tricky formula question for tod...
 Group Mode  Joe writes in with a faster way to get an entire w...
 Subtotals Count  Why does the automatic subtotals command sometimes...
 Paste Options Redux  Last Thursday, we pondered how to get rid of the a...
 Event Handlers  In honor of Memorial Day in the United States, a q...
 Conditional Find  Rod calls in a question today; how to use conditio...
 Copy Across  Richard sends in todays question: How do you copy ...
 Center Sorting  George has a dataset today where a serial number c...
 Custom Sort  Sometimes, your company tradition will force you t...
 Show Positives  Dermot sends in today?s question; a spreadsheet is...
 Finding Numerics  The Find command seems to work perfectly with text...
 Flight Numbers  JJ writes in with a question from Alaska. His home...
 Final Saturday of Month  Ammar from Iran sends in a question about how to f...
 MegaFormula Redux  Gary sent in a better way to build MegaFormulas. G...
 Color Palette  Excel 97 through Excel 2003 was limited to 56 colo...
 Color Templates  Rather than modify the 56 colors for every new wor...
 Copying Colors  Once you have a custom color palette set up in Exc...
 2007 Themes  Rather than having to customize the color palette,...
 Theme Effects  In Excel 2007, a theme is comprised of fonts, colo...
 Custom Themes  It is easy to create a custom theme in Excel 2007....
 Favorites Playlist  Doug sends in a question today about managing his ...
 Upper Case  Gary asks about converting text from lower case to...
 Counting X?s  Kyle is trying to build a worksheet to create prac...
 Sorting by Month  Mario writes in with a comment about Episode 507 o...
 Indeterminate Substitution  Robbie calls in today to ask how to add a hyphen a...
 Appending Sequence  Ben asks how he can automatically append a sequenc...
 Overlapping 2007 Charts  Peter sends in a question that relates back to Epi...
 Is it your birthday?  George would like to mail birthday cards to all of...
 DATE EXTRADONAIRE  I love the DATE function. While some Excel functio...
 MOD FUNCTION  Daan Sprunken (who was a runner up in one of the l...
 Shortcuts  Jonathan writes in to mention Ctrl+; enters today?...
 Rearranging Columns  Mary from Chicago asked how to rearrange columns i...
 Rearranging all Columns  In yesterday?s podcast, I showed how to rearrange ...
 Sparse Copy  My favorite trick is to double click the fill hand...
 Adding Headings  Today?s problem involves a complex data set with h...
 Strikethrough a Portion  Today, Bob calls in with a question. He has an Exc...
 Scrollbar Size  If you navigate your worksheet rows by dragging yo...
 Negatives to Positive  Simon from the UK sends in a question. He has a ra...
 Custom Functions  Way back in Episode 499, I talked about adding the...
 RedFlag Dates  Van writes in with a suggestion about podcast 539....
 Hiding Negatives  In today?s podcast, Episode 552, I use the IF func...
 Formatting Away Negatives  In today?s podcast, a custom number format that sh...
 Formatting Zones  Building on yesterday?s podcast, Episode 554 shows...
 Thousands Display  Need to convert a report or a chart to display in ...
 Multiple Consolidation 2007  Rivky writes in to ask how to do multiple consolid...
 Manual Recalc  Do you have a spreadsheet where the calculation ti...
 Moving Columns  Udo from Dresden Germany sends in a tip for a fast...
 Zeroth Day  Erik points out that the best way to find the last...
 Negative Workdays  How can you figure out a date that is a certain nu...
 Negative Time?  Excel does not deal well with negative times. What...
 Better Scientific Notation  Ryan from Schaumberg sends in a tip for improving ...
 Mapping Data  Turn a list of customer locations into a map right...
 Floating Point Errors  Have you ever had an Excel calculation show up wit...
 Restoring Scrollbar  Back in Episode 548, I talked about the frustratin...
 Text to Columns  Going back to Podcast 453, I talked about taking d...
 Truncation Justify  Are you a fan of Edit ? Fill ? Justify? If so, wat...
 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...
 Random Quiz  Giovanni asks how he can create a random multiple ...
 AutoFilter Doesn?t Contain  Joe asks about using custom autofilters with Excel...
 2007 Filters  Excel 2007 adds some amazing new features to the E...
 Plus or Equals  All Excel formulas start with an equal sign, right...
 Repeating Characters  If you need to fill a cell with a character, eithe...
 Editing Formula Ranges  A quick trick showing how you can make a formula p...
 RSS Size  In today's Episode 576, I ask, How many episodes o...
 End of Month  Using the EOMonth function to find the end of a mo...
 Merge Words  Mike from Kansas City asks if there is a way to ta...
 Double Click Fill Handle  One of my Greatest Hits ? a fast way to copy a for...
 Fixing Crystal  Susan writes in with an annoying problem. Crystal ...
 Massive Page Breaks  Steve wonders how he can add a page break after ev...
 Validation Dropdowns  Brent asks if it is possible to make the data vali...
 Validation Lists Elsewhere  Brent asks how you can set up validation lists on ...
 Refreshable Validation  Store your validation lists on a separate workshee...
 Text Length  Ron from Dallas asks how he can limit the number o...
 Shrink To Fit  Here is another solution to Episode 585: Instead o...
 Concatenate Range in VBA  Back in Episode 578, I used an incredibly complex ...
 Sample Spreadsheets  When you use the New command, you have access to h...
 Ctrl+Alt+X  Bill from Addison TX sent in a great tip to allow ...
 Rolling Charts  Say that you need to show a rolling 6 month chart....
 Missing Dates  When you create a chart from data that might have ...
 Missing Pivot Dates  Today?s question is a followup to yesterday?s que...
 Unprotect Green Cells  Today, the questioner asks how to unprotect the gr...
 Run Macro Button  You?ve created a simple macro and want to assign t...
 Faster Fill Handle  Today, Dr Fill Handle provides a faster way to use...
 Auto Formula Copying  Rod notes that Excel has a cool feature that will ...
 Show All  After you?ve used an AutoFilter to see just a few ...
 Evenly Distributing Numbers  Jerry from Georgia asks how to randomly distribute...
 Text Box Length  Joe Marten sends in a better way to limit the numb...
 500th Episode  I wonder if there is a milehigh club for podcasti...
 Redocking Properties  If, in the VBA editor, you accidentally undock the...
 Indirect Address  Rod asks how to set up a summary worksheet that wi...
 Adding Worksheets  Add new worksheets in seconds. Episode 603 shows y...
 Breaking Charts  Do you have a chart which is too confusing? Try re...
 Frequency Distribution  Creating a Frequency Distribution with the FREQUEN...
 Histogram  To create a true histogram from frequency informat...
 Double Click  My favorite Excel trick is to doubleclick the fil...
 Navigate Worksheets  Learn how to quickly navigate worksheets. Episode ...
 Hiding Chart Rows  When you hide a row, Excel will remove that series...
 Ball of Paint  We figure out the thickness of a coat of paint, li...
 Unhide All Sheets  You can hide several sheets with a single command,...
 Default Footer  Anne sends in today?s question: How can I change t...
 Multiple VLOOKUPs  Alicha asks ? how can you return many columns from...
 Filter Most Recent  Alicia and George have sent in similar questions; ...
 Filter Recent II  In today?s podcast, I address the same question fr...
 Spilling Cells  Ethan sends in a question about optionally allowin...
 Spilling Values II  In today?s episode, I take a look at three nonmac...
 Underlining Woes  Mark sends in a question about why Excel underline...
 Sorting Subtotals  Say that you add automatic subtotals and collapse ...
 Forecasting  Leon asks how to forecast the next number in a ser...
 Array Forecast  Today, we take a second look at Leon?s question ? ...
 LINEST Regression  Rather than using FORECAST to choose the next numb...
 Exponential Growth  Sometimes the growth in a model is not linear, but...
 Multiple Regression  How much ice cream will Sally sell on any given da...
 Formula Bar  Excel 2007 features an amazing expanding formula b...
 VBA Naming Ranges  The macro recorder uses a confusing way to name ra...
 Relative Recording  When recording a macro to enter a SUM formula, you...
 Pivot Rearrangement  Sometimes, you might need to rearrange the heading...
 Column Function  I want to revisit a topic from podcast 613; using ...
 Customer Templates  Jennifer from Illinois asks if you can use the tri...
 Realllly Long Text  Excel can allegedly handle 4096 characters in a ce...
 Array Function Arguments  Back in podcast 621, I wondered why the function a...
 Keyboard Shortcuts  Vincent from Montreal shares a tip today to print ...
 Dragging Chart Points  Did you know that you can change numbers in the un...
 Four Conditions  Today?s question deals with conditional formatting...
 Combining Worksheets  James asks how he can combine data from all rows o...
 Validation Unique  Ben asks today?s question: Can I set up Validation...
 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...
 Filtered Greenbar  Rod from Cincinnati notes that the trick used in P...
 Conditionally Summing  Patrick asks how he can summarize his monthly time...
 Pulling Web Data Into Excel  Maxwell asks how best to pull web data into Excel....
 Excluding Zero Values From Pie Charts  Patrick wrote in to address my answer from podcast...
 Previous Banking Day  A great question from one of my Excel seminars sta...
 Fibonacci Sequence  John from New York asks if Excel can be used to cr...
 Exit Excel  In Excel 2007, Microsoft has changed the behaviour...
 Extending ABC  Excel knows how to extend any series, but it can n...
 Changing Numbers Graphically  Steve asks if he can build an Excel worksheet wher...
 Slider Controls  Today, a second answer to Steve?s question about c...
 2007 Filter  In Episode 650, I take a look at the new functiona...
 Remove Duplicates  Excel 2007 offers a fantastic new way to remove du...
 Pivot 2007  Excel 2007 offers new pivot table functionality. E...
 NonNumeric Managers  Do you have a manager who?s eyes glaze over when p...
 The Ribbon is Cool  There. I?ve said it. Let me say it again? ?The Rib...
 Year vs Year  Hiro asks how to build a pivot table to show year ...
 Negative Charts  Chris from Long Island asks how to conditionally f...
 Find All  Today we take a look at some nifty tricks in the F...
 Subtotal Row Formulas  Debbie from Virginia asks about adding new calcula...
 Deleting Borders Deletes Gridlines  Greg from Indiana sends in a great mystery today. ...
 Weeks Ending on Sunday  Add a validation dropdown with all weeks ending on a Sunday
 OR Conditional Sums  Conditionally summing records that match one condition or another
 SumProduct  Do conditional sums with SUMPRODUCT
 Pasted Icons  Pasted web data often has annoying icons. Remove them.
 Extracting Links  Have a bunch of hyperlinks in Excel? Extract the URL from each link to a new column.
 Scraping Webpages  VBA to grab data from all web pages in a list
 Clustered Columns  Create a clustered column chart using Excel  a question sent in by Rodney
 Totaling Visible Rows  After applying an AutoFilter, total only the visible rows
 Total Diagonally  Can you total that diagonally for me?
 Total Diagonally 2  Create running diagonal totals, improving yesterday's formula
 Total Duhagonally  A simpler way to total diagonally
 Proper Case  Changing names to proper case
 OffSheet References  Do VLOOKUPs from one sheet to another sheet
 Custom Numbers  Finding numbers in a column with special numeric formatting.
 Negative Invert  Better way to color negative chart columns in red.
 Named Ranges  Naming a range to simply formula entry. Also using F3 for Paste Name
 Recording Naming  Use a macro to name the current range
 Preventing Spills  Fill blank cells with an apostrophe to prevent adjacent long cells from spilling.
 Page Break Preview  Use Page Break Preview or Page Layout View in Excel 2007
 Pivot Source Data  Change pivot table source in Excel 2007.
 Timestamp  A VBA event handler to timestamp new records in an Excel worksheet
 Indirect  Using INDIRECT to build a Summary worksheet that can be copied to new workbooks.
 Quiz Practice  Use Excel to practice for quiz
 Chart >4%  Use a filter to remove small pie wedges from a pie chart.
 Bar of Pie  Automatically move pie wedges under n% to a secondary chart.
 Tracking Runners  Track finishing times for runners in Excel.
 Preventing Spills  Prevent long text from spilling into adjacent cells, take II
 VBA in 2007  VBA is alive and well in Excel 2007
 Month End  Ask for the 0th day of next month to find the last day of this month
 Hiding in 2007  Use Excel 2003 Keyboard shortcuts in Excel 2007
 Page Setup  Repeat headings and titles at the top of each printed page, with page numbers.
 Insersection Operator  Using the intersection operator in Excel
 Ditto  Copy the exact formula from above using Ctrl+' or Ctrl+"
 Easy Greenbar  Use Excel 2007 Table functionality to format a range with greenbar.
 Double Greenbar  Set up greenbar formatting with stripes that are two rows high.
 Scale Selection  A macro to scale a selected range.
 Alt Shortcuts  New Alt shortcuts in Excel 2007
 VLOOKUP or INDEX?  Is it better to use VLOOKUP or INDEX and MATCH?
 Column Widths  Copy column widths from one range to another range.
 2007 Pivot Interface  Bring back the Pivot Table draganddrop interface in Excel 2007
 Mapping Data  Plot your Excel data on a map using MapPoint.
 VBA Userforms  Create a userform in VBA
 2 Field Column  Extract region data using IF statements
 Filling Outline Blanks  Fill in blank cells with the value immediately above it.
 Deleting Blank Rows  Sort data to move blanks to the bottom of the data set.
 Pivoting Time Columns  Change a pivot data set that has quarters going across to rows going down
 Pivot 2007  Create your first pivot table in Excel 2007
 Changing Pivot  Changing a pivot table in Excel 2007
 Pivot Sorting  Sorting a pivot table field.
 Pivot Dates  Group daily dates up to months in an Excel 2007 Pivot Table
 Pivot Filters  Filter a pivot table to show only records from this week.
 Show Pages  Create a report for each customer in a few clicks.
 First Subtotaled Item  Grab the first item from a subtotaled group using CHOOSE() and an array formula
 Validation Woes  Why validation dropdowns don't jump to an entry when you type the first letter.
 Choose Value  VBA userform to allow you to choose a value.
 PI Day  PI() and SQRTPI(), in honor of PIday (3/14)
 NCAA MapPoint  Use RANDBETWEEN to choose a person at random, mapping with MapPoint
 Event Calendar  Show events visually on a calendar in Excel
 AutoComplete vs Validation  Use AutoComplete and Validation to allow easier entry of values.
 Sampling  Choose a random sample of 20 invoices from a population
 Dynamic Validation  Define a dynamic list for your validation lists using OFFSET
 Leading Zeroes  Keep leading zeroes in Excel.
 Paul McCartney  Capitalize the interior C in McCartney when using the PROPER function
 PivotText  Show Yes or No in the data area of a pivot table.
 Custom Number  Obscure custom number formatting tricks
 Row Differences  Finding differences between two columns using Go To Special Row Differences
 Random Drawing  Use RANDBETWEEN to choose prize winners
 Building Formulas with Text  Using INDIRECT with concatenation.
 Table Formulas  Stop Excel from created calculated columns within a table
 2003 Icon Sets  Create an icon set in Excel 2003 using wingdings.
 Insert Worksheets  Add a new worksheet for every customer on the summary worksheet
 Copying Subtotals Only  Copy the subtotal rows from the automatic subtotals
 Dates from Text to Columns  Prevent Text to Columns from converting 73 to a date
 Bingo Draw  Draw bingo numbers down column A
 Bingo No Duplicates  Generate random bingo numbers without generating duplicates
If you like this video, there are hundreds of 25 minute videos available here:
MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.
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.
