Excel_lesson Videos
Excel Multiple VLOOKUP Tutorial
Peter asks how to return multiple records from a VLOOKUP. In Episode 1002, I will show you how to use an Advanced Filter to achieve this ... tags: accounting Excel Excel_Lesson excel_spreadsheets filter Microsoft_Excel_tutorial MrExcel
04/28/09 from MrExcel
How to Add Page Setup Launcher to your Excel Toolbar
Add the Page Setup dialog launcher to your Excel 2007 Quick Access Toolbar. Episode 1003 shows you how.
tags: Add dialog Excel Excel_2007 Excel_Lesson excel_spreadsheets How
04/29/09 from MrExcel
Excel Lesson - Charting Zero
Glenn has a series of line charts showing monthly data for 2009. Most charts work fine, but the total chart shows the line dropping to zero ... tags: charting Charting_Zero excel Excel_Charting_Tutorial Excel_Lesson excel_spreadsheets Microsoft_Excel_tutorial
04/30/09 from MrExcel
Excel Filtering Tips
Another Dueling podcast: How to filter to the top 5 golf scores for one golfer? The AutoFilter won't let you do it. But Mike and Bill show ... tags: excel Excel_dueling_tips Excel_Filtering_Tips Excel_Lesson excel_spreadsheets filter Filtering_Tips
05/01/09 from MrExcel
How to use Excel Advanced Filter with a Criteria Range
Ileane asks how to get only the .edu e-mail addresses from a database of 20,000 e-mails. Episode 1006 shows you how to use advanced filter ... tags: Advanced Criteria Criteria_Range Excel Excel_Lesson excel_spreadsheets Filter
05/04/09 from MrExcel
Excel Formula Conditional Formatting Tips
William asks how to base his conditional formats on a start date in column A and a duration in column B. This calls for the Formula version ... tags: Conditional conditional_formatting Excel Excel_Lesson excel_spreadsheets Formatting Formula
05/05/09 from MrExcel
How to Copy Chart Formatting in Excel
Marcelo asks how to replicate all of the formatting on an existing chart. In Excel 2003, this was Chart, Custom Types, User Defined, Add. ... tags: Chart Copy Copy_Chart_Formatting Excel Excel_Lesson excel_spreadsheets Formatting
05/06/09 from MrExcel
How to Select Region, Undo and Underline in Excel
3 fast tips from my recent seminar in Louisville Kentucky: Different way to select current region; different way to Undo; How to overline ... tags: Excel Excel_Lesson excel_spreadsheets How Microsoft_Excel_tutorial MrExcel Region
05/07/09 from MrExcel
How to Unwind Rectangular Selection in an Excel Column
A dueling podcast: how to unwind a rectangular selection to a single column. Mike & Bill weigh in with differing methods in Episode 1010.
tags: Excel Excel_Lesson excel_spreadsheets How Microsoft_Excel_tutorial MrExcel Rectangular
05/08/09 from MrExcel
How to Recalc Speed using Excel
Mike Girven pointed me to an excellent whitepaper by Charles Williams about calculation speed. In Episode 1011, an example contrasting ... tags: calculation_speed Excel Excel_Lesson excel_spreadsheets How Microsoft_Excel_tutorial MrExcel
05/11/09 from MrExcel