- [Instructor] So quick pro tip…when it comes to label filters is using wild cards.…So if I drop into our sort and filter options here…and go into begins with, you'll notice…these two lines of text down at the bottom.…The question mark is used to represent…any single character.…The asterisk is used to represent…any series of characters.…So these are the two types of wildcards…that you can integrate into these filters…to get a little bit more sophisticated.…So like we talked about in the last lecture,…if I want to show all of the titles…that begin with a certain letter,…very straightforward, just type the letter, press okay.…

In this case I've got all my titles that begin with A.…Very simple, going back into that label filter.…What if I want any title where A…is the second character?…Now it can't use the standard tools.…I have to use some wildcards here.…So if I want A to be the second letter,…all I need to do is put a question mark…in the first position.…And I can use a capital A, a lower-case a.…This isn't case-sensitive, so that's fine.…

Resume Transcript Auto-Scroll

Author

Released

12/3/2018

While the power and time-saving value of PivotTables appeals to anyone who analyzes data in Excel, many users are too intimidated by the feature to add it to their workflow. In this course—the first installment in a two-part series—instructor Chris Dutton breaks down how to use PivotTables, as well as how to add PivotCharts to the mix to summarize your data visually. Throughout the course, Chris shares practical tips and demonstrations that help you grasp how these tools are used in the real world, as well as how PivotTable values are actually calculated and displayed. Learn how to prepare your raw data for analysis; leverage formatting, sorting, filtering, and grouping options; display values in multiple ways; create PivotCharts; and much more.