Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Go behind the scenes with some of the biggest digital celebrities to see what life is like when the blogging and tweeting stops.
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.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
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.
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.
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.
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.
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.”
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
Hank Azaria’s touching, humorous, and often enlightening journey from a man who is not even sure he wants to have kids, to a father going through the joys, trials and tribulations of being a dad.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
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.