• 2007 Visualizations - Episode 312 features a preview of one of the cool ...
• Ribbon Minimization - Starting on Tuesdays and Thursdays, I will be taki...
• Shortcut Keys - It's another Excel 2007 Thursday. I'll take a look...
• Data Visualization - A look at Excel 2007 data bars and color scale fea...
• QAT Taming - The only toolbar that is easy to customize in Exce...
• Big Grid - Excel 2007 sports a massive grid. Take a tour of c...
• 2007 Formats - Actually - there are three different file formats ...
• Color Sort - New in Excel 2007 - you can sort by cell color! To...
• 2 Column TextBox - How to use Excel as a word processor. This episode...
• Expanding FormulaBar - Do you notice that in Excel 97-2003, if you have a...
• Removing Duplicates - Excel 2007 offers powerful new features for removi...
• Table Formatting - Excel 2007 adds new table intelligence that you ca...
• Table Extending - Once you have defined an Excel 2007 table, Excel w...
• Recent Files - This netcast has a couple of tips from Tools - Opt...
• Table Formulas - One of the best features of the new Excel 2007 tab...
• 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...
• Table Filters - Excel 2007 offers amazing new AutoFilter functiona...
• Free Book - Sign up to get a free chapter each week of my new ...
• 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...
• 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 ...
• Quick Transpose - Do you need to turn data on its side in Excel 2007...
• Classic Menus 2007 - Bill Gates asked the question: ?The ribbon is fine...
• Moving Average - Ricardo sends in a tricky formula question for tod...
• Conditional Find - Rod calls in a question today; how to use conditio...
• Custom Sort - Sometimes, your company tradition will force you t...
• 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....
• Overlapping 2007 Charts - Peter sends in a question that relates back to Epi...
• Multiple Consolidation 2007 - Rivky writes in to ask how to do multiple consolid...
• 2007 Filters - Excel 2007 adds some amazing new features to the E...
• Sample Spreadsheets - When you use the New command, you have access to h...
• Histogram - To create a true histogram from frequency informat...
• Formula Bar - Excel 2007 features an amazing expanding formula b...
• Exit Excel - In Excel 2007, Microsoft has changed the behaviour...
• 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...
• Non-Numeric 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...
• Page Break Preview - Use Page Break Preview or Page Layout View in Excel 2007
• Pivot Source Data - Change pivot table source in Excel 2007.
• VBA in 2007 - VBA is alive and well in Excel 2007
• Hiding in 2007 - Use Excel 2003 Keyboard shortcuts in Excel 2007
• 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.
• Alt Shortcuts - New Alt shortcuts in Excel 2007
• 2007 Pivot Interface - Bring back the Pivot Table drag-and-drop interface in Excel 2007
• 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.
• Table Formulas - Stop Excel from created calculated columns within a table
• 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.