Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Comedy is hard, but teaching comedy to children is hilariously difficult. Kevin Nealon is giving the challenge to some world-famous comedians. As these young minds meet with comedy’s best, get ready to learn some valuable comedy lessons, and to laugh!
James Franco loves movies. He loves watching them, acting in them, directing them, and even writing them. And now, he’s going to take some of his favorite movie scenes from the most famous films of all time, and re-imagine them in ways that only James can.
The story of punk rock singer Laura Jane Grace of Against Me! who came out as a woman in 2012, and other members of the trans community whose experiences are woefully underrepresented and misunderstood in the media.
Executive produced by Zoe Saldana (who will be the subject of one episode), a celebrity travels back to their hometown to pay tribute to the one person from their past (before they were famous) who helped change their life by giving them an over-the-top, heart-felt surprise.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
Enter the graceful but competitive world of ballet through the eyes of executive producer, Sarah Jessica Parker. This behind-the-scenes docudrama reveals what it takes to perform on the ultimate stage, the New York City Ballet. Catch NYCB on stage at Lincoln Center.
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
Go behind the scenes with some of the biggest digital celebrities to see what life is like when the blogging and tweeting stops.
Digital influencer Justine Ezarik (iJustine) is back. After covering the world of wearable tech last season, iJustine is expanding her coverage this year by profiling the hottest tech trends across the country.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
A 12 episode documentary series following 5 startup companies competing in the 2013 San Francisco TechCrunch Disrupt Startup Battlefield as they fine tune their products and eventually present in front of a panel of judges in hopes of winning $50,000 in funding.
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
Learn how you can quickly search very large data bases and pinpoint and extract specific pieces of data without a lot of ...
manual effort in Microsoft Excel. Learn How to sort data using the sorting and filtering tool in Microsoft Excel.
Tags:database,microsoft excel 2007,sorting and filtering tool,total training,workspace
Grab video code:
While Excel’s find and replace functionality is an empty little functionality that it will allow you to find and replace data, there are other tools and techniques that you can use to extract data and pinpoint data. The tools that I am referring to here are the sorting and filtering tools found in Excel. With these sorting and filtering tools, you can quickly search very large data basis and it pinpoints and extract specific pieces of data without a lot of manual effort.
So, let us go to this next tab, the sorting and filtering data tab to start fresh and let us talk about Excel sorting functionality first. Excel makes sorting a data table very easy. All you have to do is simply click on the column that you want to sort. For example, I will sort the region column and click on the sort and filter command button on the Home Tab and you will see several options here. You can sort A to Z basically meaning that you can sort in ascending order, sort Z to A, sort descending order or apply a custom sort where you can sort on multiple columns at once.
Now, this filter command here is not necessarily as sorting function so we will talk about that later. But, for right now, my plan is to sort my region column in descending order. So, what I would do is simply click sort Z to A and as you can see, the region column is now sorted in descending order and how do I know that. Well, west at the top here and if I press the Control End hot key that we learned earlier, you will see Midwest is at the bottom. So, I am going to go back up to the top here and press Control Home. It takes me up to the top and let us do an example of sorting multiple columns at one time.