Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
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.
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.
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.
How to use Microsoft Excel - Improving Work Sheet Appearance - part 7 in this educational video from dizzo95.
Tags:Microsoft Excel - Improving Work Sheet Appearance,dizzo 95,dizzo95,dr dan izzo,education,improving work sheet appearance,microsoft excel,part 7,software
Grab video code:
In the last lesson we entered data and formulas on our worksheet. Now we want to improve the appearance of the worksheet. We’ll begin by opening the file. We’ll use the open button on the standard tool bar, we click on the button and the open dialogue box appears. It shows the theater folder because that’s the last folder we used. The file list shows the summer sales file we created and saved. These other files are not part of your software. These are files we created.
To open a file we double click on its file name when we do the file is opened. We’re ready to make some changes. We’ll begin by inserting a blank row above the monthly totals to make them standout more. We select any cell where we want the row inserted then we open the insert menu. We’ll click on rows, when we do a row is inserted and the existing rows will down. Now we’ll add three blank rows at the top for a heading. We select cells in the first three rows. This time we’ll use a shortcut menu, we right click on the selected cells. In the shortcut menu we click on insert, we can insert a block of cells shifting cells out of the way as necessary or we can insert entire rows or columns. We select entire row. When we click on okay three blank rows are inserted. Now let’s look at one of our formulas the cell references have automatically changed to reflect the new location of the data. So the formula results are still correct.
We can insert or delete cells, rows, or columns and our formulas will all adjust accordingly. Now, we’ll type our heading. In the first blank row we type the theater name and press the down arrow. Notice that the text is wider than one cell and overflows into the next cell. This happens at the adjoining cell is empty. In the second row we type in enter the worksheet title with the name of our summer show. Once we’ve entered data we often want to sort it to put it in a different order. Our three ticket price rows are currently in no particular order. We want to sort them by total sales from highest to lowest. To start we select the cell in the column we want to sort by. This button sorts in ascending order from A to Z and from lower numbers to higher. This button sorts in descending order which is what we want. When we click on it the records are instantly sorted by total sales. Half price ticket sales are now on the bottom. Notice that excel sorted the Excel sorted the ticket sales rows including the labels but it left the column labels alone. Excel automatically reads the way a list like this is set up and then sorts it correctly.