Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
EMMY NOMINATED SERIES directed by and starring Steve Buscemi is back for a second season!!! Park Bench is a local's take on the special people, places, and spirit of New York City. Through unscripted moments with average New Yorkers and Steve's celeb friends, Buscemi takes viewers on a funny, first-hand journey/misadventure, told in his unique voice.
Journey to the Draft is an organic, unscripted, docu-series that follows three college football players, all with promising professional careers. These young men attend different schools across the country and play a variety of positions on the field, but at the end of the day they share one goal:to play in the NFL. The AOL docu-series follows players Leonard Williams, Kevin White and Marcus Peters.
Connected features the personal stories of six New Yorkers woven together into one of the most intimate series ever. This groundbreaking show changes the nature of storytelling by giving each character a camera to document their lives. The result is a unique format revealing as different as everyone appears to be, we are all universally Connected.
Wake up to your world in 2 minutes.
"Stricly Come Dancing presenter Tess Daly and The Saturdays' Rochelle Humes talk to mums about their experiences of being mum. Whether the daughter of a Rolling Stone, in one of the most famous girl bands the world has ever known, or a parent coping with disability as well as family life, each mother in Being Mum shows that the feelings, challenges and rewards of motherhood are universal no matter the surroundings you find yourself in."
Jews and Money. Asian Drivers. Polish IQ. CPT… that's racist! But where do these stereotypes come from? Comedian Mike Epps explores the backstories of this humor and how history and fact often distorts into a snide – but sometimes funny – shorthand.
"INSPIRED" features celebrities, visionaries and some of the biggest newsmakers of our generation, recounting the stories behind their biggest, life-changing moments of inspiration.
In a compelling series of verite encounters, Win Win provides unique access into the minds and lives of the world’s most-celebrated entrepreneurs and athletes.
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.”
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.
Learn how to count using the Pivot Table in MS Excel 2007.
Tags:count,counting,excel advance training,microsoft excel 2007,microsoft windows,pivot table,total training
Grab video code:
Next, I want to show you an example of a data set that has no numeric fields whatsoever but we could still summarize it with a pivot table. We need to close this file. So just choose File, Close and then I will open the file for 02 pivot tables. This data set has defect data. It shows the date, the manufacturing line number and the area where the defect was found and we want to do an analysis to see which areas have the most defects. Unfortunately, there is no field for us to sum. I will select one cell in the data, use insert pivot table, and click okay. I want to do an analysis by which defects occurred most often. If I choose the defect field, it is automatically added as a raw label.
I now need to take the defect field and drag a second occurrence into the sum values. Because this field is text and there is no way to sum, Excel will automatically choose to count which is perfect and that is exactly what I want. Now, as I look down through the data, I see that fit and finished roof had the most defects of all. So, I want to be able to zoom in and take a look at fit and finish roof. Of course it makes sense to take the defect field from raw labels and move it up to report filter where we can choose fit and finished roof.
Let us do an analysis by date to see if this problem has been happening all month. And now, instead of percentages, I will see cumulative year to date figures. You will see that for most of the month, there were just a few occurrences each day. If I scroll down though, something happened around the 28th of the month. Let us take a look at the line. I am going to take the line field and add that to the column labels. The problem seems to have happened first on line two in column C. That is the line that started having problems. Using this pivot table, it was very easy for us to zoom in and realize that the fit and finished roof first happened on line two and then spread to the other lines a couple of days later.
I bet if we check the records, we will see that a new shipment that arrived from the vendor was restocked to line two and then eventually out to the other lines. This is a very interesting situation where we had many rows of defect data. Really no idea on what is going on but by using a pivot table in the count option instead of summing, we have been able to zoom in and find the problem very, very quickly.