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 rearrange fields in a Pivot Table of MS Excel 2007.
Tags:excel advance training,microsoft excel 2007,microsoft windows,pivot table,rearranging fields,total training
Grab video code:
The other fantastic thing about a pivot table is that it is very easy to change the report. Let us say that you print this report and you take it to your Manager. And variably, the Manager is going to say, “Well wait a second; this is what I asked for but not exactly what I wanted. I want Products going down the left hand side and Regions going across the top.” It is very easy to change this in a pivot table. You want to take the Region field and move it from the row labels drop zone and drop it to the column labels drop zone. And then, we are going to take the Product field and move it from the column labels drop zone and drop it in the row label drop zone. Just that quickly, I have completely changed the complexion of the report. If you need to add new field to the pivot table, you can simply either check them in the top half of the pivot table field list or just drag them from the top half of the pivot table field list and drop them in the appropriate place. For example, let us say that we wanted to add customer to this report, there are two places along the left hand side where we can add the Customer field. We can show each Customer in column A and within that, the products that they have purchased. In order to do that, we would drop the customer field before the product field in the rows label area.
That is one view of our data. It also might make sense to show the product field first in column A and then show the customers who purchased that product. We would simply drag the customer field and drop it below the product field in the row labels area. Completely different report show that each product and the customers who purchased that product. Notice how easy it is to completely change the report simply by dragging fields throughout the report. If there is a field in the pivot table that you need to remove from the pivot table, fairly easy to remove it. You have two choices now in excel 2007. The easiest way is simply to uncheck the field in the top half of the field list. The other method is to grab the field from the bottom half of the field list and drag it back to the top. When the mouse pointer changes to a black X, you are about to remove the field from the pivot table report.