• See Headings - See Row 1 all the time as you scroll down.
• See Columns - See column A all the time as you scroll right.
• Footers - Headers & Footers - Add text to print at the top o...
• Word Processing - Use Excel as a word processor to properly format t...
• Time Formats - Learn the obscure formats to make your time calcul...
• Time as Text Part 2 - In today's episode, someone keyed in hundreds of c...
• Two Rows in One Cell - If you need a long heading in a single cell, use t...
• Subtotals Pop - Make your subtotals pop out at the reader. I'll us...
• Customer SubHeadings - In today's dataset, someone tried to make a report...
• Formatting Pivots - While pivot tables are incredibly powerful, they g...
• PivotTable NumberFormat - If you need to change the numeric format in your p...
• Quick Formatting - Make your boring black and white spreadsheets come...
• Styles - Microsoft Word gurus suggest using Styles in Micro...
• Chart Formatting - Why do Excel charts look so horrible? Learn how to...
• 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...
• 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...
• Standard Width - Need to resize columns without unhiding the hidden...
• 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...
• 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 ...
• 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...
• Date Differences - You have two dates in Excel and want to find the e...
• 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...
• AutoShape Text - Create cool headlines by adding text to your autos...
• Custom Charts - Once you have customized a chart, add the chart to...
• Select Visible Cells - When you have created automatic subtotals and want...
• Formatting Macro - Someone posed this question in a recent Power Exce...
• Eye-Catching Titles - Add visual interest to your reports by adding a co...
• Grey Background - Jim from Montreal calls in today to ask if there i...
• Leading Zeroes - Have you ever tried to enter an ID number that sta...
• Data Visualization - A look at Excel 2007 data bars and color scale fea...
• Leading Zeroes - A much better way of showing leading zeroes. After...
• Find ##### - When a number is too large to fit in the width of ...
• 2007 Formats - Actually - there are three different file formats ...
• Mini Toolbar - Get quick access to all of the text formatting com...
• Joining Dates - If you try to use the concatenation character to j...
• Table Formatting - Excel 2007 adds new table intelligence that you ca...
• Table Formatting - Six accent colors x 7 options x 20 themes x your i...
• Gantt Chart - This cool trick shows you how to create a Gantt ch...
• Paste Formulas - Eric from Shanghai writes in with a question about...
• Undo Toolbar Customizations - If you have inherited a computer where someone has...
• Dates as Numbers - Here is a bizarre problem sent in by a viewer. Man...
• Unhide One Column - Stuart from the UK asks: say that you have columns...
• Hidden Column Tricks - As a follow-up to yesterday?s netcast, Episode 450...
• Umlas Magic - Today?s podcast is the first in a series featuring...
• Dreamboat Formatting - I realize this is the Learn Excel podcast, but we ...
• Conditional Formatting - Today?s guest podcaster is MVP Zack Barresse. Zack...
• 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...
• Classic Menus 2007 - Bill Gates asked the question: ?The ribbon is fine...
• Time Stripping - Jonathan from California has a column with date & ...
• Grouping by Hour - In yesterday?s podcast, I proposed a formula to so...
• Color Pivot - There is a cool but subtle way to select all of th...
• Conditional Find - Rod calls in a question today; how to use conditio...
• Show Positives - Dermot sends in today?s question; a spreadsheet is...
• Theme Effects - In Excel 2007, a theme is comprised of fonts, colo...
• 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...
• Strikethrough a Portion - Today, Bob calls in with a question. He has an Exc...
• 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...
• Formatting Away Negatives - In today?s podcast, a custom number format that sh...
• Formatting Zones - Building on yesterday?s podcast, Episode 554 shows...
• Better Scientific Notation - Ryan from Schaumberg sends in a tip for improving ...
• Floating Point Errors - Have you ever had an Excel calculation show up wit...
• Merge Words - Mike from Kansas City asks if there is a way to ta...
• Shrink To Fit - Here is another solution to Episode 585: Instead o...
• Histogram - To create a true histogram from frequency informat...
• Default Footer - Anne sends in today?s question: How can I change t...
• Spilling Cells - Ethan sends in a question about optionally allowin...
• Four Conditions - Today?s question deals with conditional formatting...
• Filtered Greenbar - Rod from Cincinnati notes that the trick used in P...
• Negative Charts - Chris from Long Island asks how to conditionally f...
• Custom Numbers - Finding numbers in a column with special numeric formatting.
• Quiz Practice - Use Excel to practice for quiz
• 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.
• Validation Woes - Why validation dropdowns don't jump to an entry when you type the first letter.
• Event Calendar - Show events visually on a calendar in Excel
• Leading Zeroes - Keep leading zeroes in Excel.
• Custom Number - Obscure custom number formatting tricks
• 2003 Icon Sets - Create an icon set in Excel 2003 using wingdings.

• 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.