Free Online Articles Directory
 |
How to use Wildcards in a Filter - Excel Lesson
Video Description: In today's dueling Excel podcast, the question is how to delete all the records which contain either ski or swim. This requires multiple wildcards in a filter. Mike and Bill will compare various methods in Episode 1090. Related Article Subjects: How to Use excel Wildcards, excel filters, Excel Lesson, excel spreadsheets, excel tutorial, excel wildcards, How to use Wildcards in a Filter, excel, MrExcelHow to Use excel Wildcards
How to a Replicate a Pivot Table
Patricia asks how to replicate a frequency distribution for many questions in a survey. If your data is set up correctly, this is a snap using the Show Report Filter Pages feature in a pivot...
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 with a criteria range to solve this...
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 you how in Episode...
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...
MrExcel's Learn Excel #946 - Countif Filtered
Loh from Malaysia sends in a very hard question. How can you use COUNTIF to analyze only the visible rows from a filtered data set? I knew the solution would have to involve iterating through... AutismBy: Vince D\\\'Souza | 13/08/2009 | Mental HealthTreatment of Autism. Calculating and Conveying the True Cost of Ownership of Projection DisplaysBy: Michael Bridwell | 05/10/2009 | TechnologyAs the world's economies work their way toward recovery, the challenges of the past year have left us with valuable lessons. Now more than ever, it is vital that the True Cost of Ownership of any capital expenditure, be clearly defined and understood. Savvy end-users and purchasing agents are becoming increasingly aware that purchase decisions need to be based not just on the initial purchase price of the product, but also on the long-term cost of ownership.
|
 |
|||||
|
Article Categories
|
|||||||
|
|
|||||||
