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 create custom themes for your Pivot Table.
Tags:custom formats,custom themes,excel advance training,microsoft excel 2007,microsoft windows,pivot table,total training
Grab video code:
Now, I am going to go back to the office theme. Now, it is still possible, even with all the different options in the styles gallery and the 20 different themes that none of those really do what you need. Excel gives you the opportunity to create your own pivot table themes. Let us say that we want to take this current them and change the stripe size from one row to two rows. We would go back to the design ribbon and open the gallery, find the theme that we are currently using. You will notice that it is highlighted. I will right click that theme and choose duplicate. Excel gives me a new theme and of course it uses kind of a strange name basically depending on to the old name.
So I am going to give this a name such as “My Style, Two Rows.” In the left list box are all the items that we can customize in this theme. As you scroll through, there are almost two dozen items that can be customized. In this case, we want to change the first row stripe and the second row stripe. I will choose first row stripe and change the stripe size to two. The second row stripe and change the stripe size to two. Now, when I click okay, you would expect that the pivot table would instantly update to reflect this new style but that does not happen. We are actually creating a brand new style and we have to go back to our gallery and choose new style. I click okay, no change to the pivot table that is expected.
We will go back, open the gallery and scroll all the way to the top. And, if our custom styles show up at the top, choose my style and now I have a style where each alternate color is two rows high. This new style I have created is available on this computer and it is available for all of our workbooks. If you want to share this theme with others, it is located in the up data folder under Microsoft, under themes. Simply copy that file from your computer to other people’s computers and you could basically create a company wide theme for people to use in their pivot tables.
If this is the theme that you like and you want all future pivot tables to use this particular theme, go back to your pivot table styles gallery, right click the style and choose set as default. All future pivot tables that you create will then have this style, so I will hit escape to close that.