Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
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.
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.”
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.
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
A client wants to know how to insert checkmarks into a spreadsheet for printing only.
Tags:Insert check Marks into an Excel Spreadsheet,Excel Lesson,How to Insert check Marks into an Excel Spreadshe,How to insert checkmarks into cells,MrExcel,MS Excel tutorial,Put Check Marks in Cells
Grab video code:
How to Insert Check Marks into an Excel Spreadsheet
Male: The Mr. Excel Podcast is brought to you by Easy-XL.
Bill Jellen: Hey, welcome back to Mr. Excel netcast I'm Bill Jelen. I want to send a big thank you out to everyone who saw yesterday’s podcast and voted. I want to send that big thank you to all of my Australian customers who put up with me at 9:00 P.M, three hours before the deadline spamming them and asking them to vote, it was neck and neck I pulled ahead of Dan English around 6:00 yesterday I did, I did pull ahead those. So congratulations to Dan with his VI Conference Flight Analysis. You should go out to Alpha Geek Challenge and check these out two excel guys under this contest.
Two Shark took 17 million census wrecker through PowerPivot and created this gorgeous map, I still don’t know how he did it, I'm begging Two Shark to tell me. And then I also I took data through PowerPivot created a tag clouding interactive smart art. You know so PowerPivot is an interesting product its sequel server analysis guys and excel guys that are interested in this product. This sequel server analysis guys are you know they know sequel server really well. The excel people are taking excel and stretching it to the their limits so you go check out Two Sharks realization then and mind if you haven’t seen it.
Again thanks for everyone who voted and congratulations to Dan, I'm winning that it was just a lot of fun to try to get reconnect with some folks yesterday. Margaret happened to call the office last night I was there late trying to drum up some votes and Margaret “Hey, I got this project from my manager it’s driving me crazy I need to show check marks”. And check marks are really, really hard to do in excel, really hard to do. Especially if you want to be able to check them on and off but Margaret just want to be able to print the check marks and I have a great solution for that.
So here’s what we’re going to do, we’re going to choose this data where the check marks are going to be and we’re going to put Q or our capital R, so the capital R is there. We’ll make those out large let’s go about 24 point and we’re going to center them and center that. Alright, and then we’re going to go into the font drop down. And all the way at the bottom you have a font called “Wingdings 2” and it’s important that you use Wingdings 2 and check that out. Wingding 2 with the R character is a check mark. And what we’ve integrated for R is Q right. So Q is really nice X so you can create a great visualization it has checkmarks and X’s just by using that font.
Now Margaret called me back about two minutes later and she’s like “Oh, my gosh it quit working all of the sudden I started getting nine’s” and if you have to be really careful with that that Q and the R because if you type a lower case Q you get an eight and a lower case R you get a nine. So you almost want to turn on the caps lock when you type your Q’s and R’s to make sure that that works. So there you go very tricky after all of this hard PowerPivot Podcast that we’ve done recently. I want to thank you for stopping by and see you next time for another netcast from Mr. Excel.