• Faster Macros - Have Excel calculate Excel macros faster by instal...
• 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...
• 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...
• 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 left-most...
• 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...
• 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...
• 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 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 super-powerful 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...
• Old Accountant's Trick - Today, I am appearing at the IMA Continuing Educat...
• 2% Across the Board - Time to raise everyone's rates by 2%. An obscure f...
• Joining Two Lists - In today's podcast, we have two lists of customer ...
• 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...
• Top Customers - Another hidden option allows you to have the pivot...
• Leading & Trailing Spaces - Kevin from Chicago called to ask how to remove lea...
• End of Month - Jackie from Chicago calls in with today's question...
• Comparing Lists - I use this trick all of the time. Say that you hav...
• Calculated Pivot Field - Add a calculated field to a pivot table. Episode 2...
• Calculated Items - Unlike the calculated field in yesterday's podcast...
• XLS in Data Query - This is a fairly wild concept. Sometimes you want ...
• Fresh WebData - Would you like to keep your web queries fresh? Pul...
• Conditional Rank - Ethan calls in with today's question - how to rank...
• 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...
• 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...
• Max or If - Calculate Sales over Quota using either the IF or ...
• Total Visible Rows - There is another way to use the AutoSum icon in th...
• Fabulous F4 - Sure, you probably know that the F4 key can be use...
• Column Negation - Your company system produces a data export where a...
• AutoShape Formulas - Rather than static text in the AutoShape, use a fo...
• GetPivotData Function - In Excel 2002+, try to create a formula next to yo...
• 2nd Tuesday - Ken from Chicago calls with a tough question - how...
• MegaFormula Copying - Sometimes when you have a difficult formula like t...
• Copy Values - Today's tip comes from Dave in Columbus, Indiana. ...
• 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 ...
• Function Wizard - Learn how to use a simple English-language query i...
• Absolute References - Sometimes, you want to enter a formula where one r...
• Expanding FormulaBar - Do you notice that in Excel 97-2003, if you have a...
• Joining Text - How to join text from two columns using the concat...
• Joining Dates - If you try to use the concatenation character to j...
• Table Formulas - One of the best features of the new Excel 2007 tab...
• Paste Formulas - Eric from Shanghai writes in with a question about...
• Dates as Numbers - Here is a bizarre problem sent in by a viewer. Man...
• Formula for Worksheet Name - Rupal asks how to return the worksheet name as the...
• Lotto Probability - Scott from Australia sent in what should have been...
• OFFSET - Joe writes in with a question of how to subtract t...
• Importing Fixed Width Files - In our continuing look at importing text files, to...
• Entering Teams - March Madness has begun and commissioners in offic...
• Checking Data Entry - The first entries in the NCAA office pool are star...
• Leading and Interior Spaces - Episode 466 shows how to get rid of leading spaces...
• Conditional Formatting - Today?s guest podcaster is MVP Zack Barresse. Zack...
• 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...
• Cy Young - Play ball! In honor of baseball?s opening day, lea...
• 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...
• Time Stripping - Jonathan from California has a column with date & ...
• Grouping by Hour - In yesterday?s podcast, I proposed a formula to so...
• Finding Substrings - George sends in a question ? How can COUNTIF be ma...
• Running Average - In today?s netcast, a question about how to create...
• 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...
• Moving Average - Ricardo sends in a tricky formula question for tod...
• Copy Across - Richard sends in todays question: How do you copy ...
• 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...
• Upper Case - Gary asks about converting text from lower case to...
• Counting X?s - Kyle is trying to build a worksheet to create prac...
• 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...
• 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?...
• Sparse Copy - My favorite trick is to double click the fill hand...
• Negatives to Positive - Simon from the UK sends in a question. He has a ra...
• Red-Flag Dates - Van writes in with a suggestion about podcast 539....
• Hiding Negatives - In today?s podcast, Episode 552, I use the IF func...
• Manual Recalc - Do you have a spreadsheet where the calculation ti...
• 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...
• Random Quiz - Giovanni asks how he can create a random multiple ...
• 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...
• End of Month - Using the EOMonth function to find the end of a mo...
• 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 ...
• Auto Formula Copying - Rod notes that Excel has a cool feature that will ...
• Evenly Distributing Numbers - Jerry from Georgia asks how to randomly distribute...
• Indirect Address - Rod asks how to set up a summary worksheet that wi...
• Double Click - My favorite Excel trick is to double-click the fil...
• Ball of Paint - We figure out the thickness of a coat of paint, li...
• Multiple VLOOKUPs - Alicha asks ? how can you return many columns from...
• Filter Recent II - In today?s podcast, I address the same question fr...
• 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...
• Relative Recording - When recording a macro to enter a SUM formula, you...
• Column Function - I want to revisit a topic from podcast 613; using ...
• Array Function Arguments - Back in podcast 621, I wondered why the function a...
• 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...
• OR Conditional Sums - Conditionally summing records that match one condition or another
• SumProduct - Do conditional sums with SUMPRODUCT
• Total Diagonally - Can you total that diagonally for me?
• Total Diagonally 2 - Create running diagonal totals, improving yesterday's formula
• Total Duh-agonally - A simpler way to total diagonally
• OffSheet References - Do VLOOKUPs from one sheet to another sheet
• Named Ranges - Naming a range to simply formula entry. Also using F3 for Paste Name
• Indirect - Using INDIRECT to build a Summary worksheet that can be copied to new workbooks.
• Month End - Ask for the 0th day of next month to find the last day of this month
• Ditto - Copy the exact formula from above using Ctrl+' or Ctrl+"
• 2 Field Column - Extract region data using IF statements
• Filling Outline Blanks - Fill in blank cells with the value immediately above it.
• First Subtotaled Item - Grab the first item from a subtotaled group using CHOOSE() and an array formula
• PI Day - PI() and SQRTPI(), in honor of PI-day (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
• Dynamic Validation - Define a dynamic list for your validation lists using OFFSET
• Paul McCartney - Capitalize the interior C in McCartney when using the PROPER function
• 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

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

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