Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity. We'll hear their inspiring stories firsthand, whether fighting back from a career-ending injury or transforming their lives and bodies through diet and exercise.
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.
The Future Of Us is a powerful original series from television personality, futurist, filmmaker and techno-philosopher, Jason Silva. In this series, Silva shares his excitement around recent discoveries and inventions.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
They say every picture tells a story and AOL On's new original series My Ink proves it. Travel along as some of the world's greatest athletes bring their tattoos to life through exclusive interviews and visits to their favorite tattoo parlors.
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.”
Discover crowdfunded small business success stories with author, comedian, and entrepreneur Baratunde Thurston.
Go behind-the-scenes with racing's hottest, young talent, 17-year-old Dylan Kwasniewski, as he aspires to make it in the #1 motorsport in America – NASCAR
Follow Scott Schuman, the Sartorialist, from the streets of NYC to the capitals of Europe on his quest to photograph and document the best in culture and fashion.
Iconic potter, designer, author and personality Jonathan Adler shares his unique perspective on creativity. Showcasing the inspiration Jonathan finds in the most unlikely people and places, Inspiration Point will add style, craft and joy to your life.
Serving Innovation gives a fresh look into the stories and passions that motivate some of the most innovative tastemakers in America.
A documentary directed by Alex Winter exploring the Napster downloading revolution; the kids who created it, the bands and businesses that were affected and its impact on the world at large.
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.
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.