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.
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.