LearnKey Blog

How to Add a Calculator to the Toolbar or QAT in Excel

Excel, of course, is a powerful calculator in its own right. Sometimes, though, when you are working on a spreadsheet you just want a regular old calculator in which you can figure something out real quick. You can add one to the toolbar (in Excel 2003) or the Quick Access Toolbar (in Excel 2007 or 2010) to have a standard calculator always at the ready.

To add the calculator button to the ribbon in Excel 2003, go to the View menu, click Toolbars and select Customize. Go to the Commands tab. Click Tools in the Categories list. Click Custom under Commands on the right side of the dialog. The Custom icon should look like a little calculator. Drag the calculator to the toolbar and drop it there. Close the Customize dialog. When you click the new button, the calculator opens just like that.

In Excel 2007 or 2010, you can add the button to your QAT (if you are unfamiliar with this term, the Quick Access Toolbar is the little toolbar up at the very top left of your Office 2007 or 2010 program window).

Click the arrow at the right end of the QAT and select More Commands. On the left side of the window, in the Choose Commands From drop-down list, select Commands Not in Ribbon. Click on Calculator in the list of commands (the commands are in alphabetical order, so it is pretty easy to find) and click the Add button. Click OK and the calculator is now at your fingertips on the Quick Access Toolbar.

(Article found on officeusers.org)

Woman Turns Alien via Photoshop

Adobe Photoshop is useful for many things, whether it’s touching up old photos, refining recent photographs or even creating completely new digital compositions.

As a graphic designer with a fascination for digital art, I am always on the lookout for new things to create. As an example, a few weeks ago I was searching the web for fun-looking tutorials, and I came across this tutorial at marcofolio.net on how to transform a human into an alien using Photoshop. I was intrigued, so I followed the tutorial using an image I got from iStockphoto, occasionally modifying steps as I went along.

In just a little under ten minutes, I was able to totally transform a picture of a pretty young woman into a strange-looking alien. What do you think? Pretty cool eh?

alien

If you’re interested in learning how to master Photoshop, be watching for our new Photoshop CS5 training that we will be filming next week or check our product page here for the Photoshop CS4 course.

Tricky Trivia Winner and New Question!

Tricky Trivia Logo

Hey, hey… It’s that time again!

First, CONGRATULATIONS to Jake Toughill for being the winner of last week’s Trivia Question!! The answers to the question- In “The 10 Commandments of a PC Tech” with Mike Meyers, what are the 2nd, the 4th and the 10th commandments– are:

2nd: DON’T TECHNO BABBLE OTHER TECHNICIANS

4th: PASS IT FORWARD

10th: ASK FOR HELP

Second, here are the rules for this week’s question…

Just answer the question correctly in the comments to be eligible to win . Once you’ve submitted the correct answer in your comment, we’ll have a drawing and randomly pick a winner. The winner, who will be contacted via email by a LearnKey staff member, will be posted next Thursday, along with a new trivia question for the week.

Here we go!

How about a little LearnKey history this week… (answer can be found on learnkey.com)

Since LearnKey’s earliest days, when founder and CEO John Clemons filmed training videos for users of WordPerfect in a small basement studio, LearnKey has remained at the forefront of evolving technology, pioneering multimedia-based training. What year was LearnKey founded?

GOOD LUCK!

This week’s prize: A totally rockin’ LK tie-dye bandana!

tie-dye J and K

Contest run time: Thursday July 1st- Wednesday July 7th

Winner posted: Thursday July 8th

North American residents only*

*In order to receive prize notification, you must provide a valid email address with your comment*

ISTE Winners!

ISTE 2010 has been GREAT so far! We are on our last day and we have had so much fun here in Denver. Here’s a recap of what we’ve been up to.

As a part of the show, we thought it would be fun to hold a contest where you could literally Unlock Your Potential. Prior to the show, we sent out a bunch of keys to educators across the nation and we asked them to bring the key with them to ISTE. The participants were then given the opportunity to see if their key unlocked the LearnKey prize box for a chance to win a Kindle, i-Pod shuffles, or flash drives!

Here are a few of our winners!

kindlewinnerISTE
Kindle Winner: Lisa Westmoeland from Derby, KS

ipodwinnerISTE
iPod Shuffle Winner: Helen mowers from Killeen, TX

ipodshuffle2ISTE
iPod Shuffle Winner: Peggy Perkins from Bastrop, TX

Tom’s Blooper Reel

We love Tom Carpenter here at LearnKey! Actually he’s heading back into our studio today to begin the filming of Server+ and because we love him so much, we thought that this time around we should honor him! So, we brainstormed for a couple of weeks about what we could do to express our gratitude publicly and well, we all agreed that this video would do the job perfectly!

ENJOY!

Thanks for being a good sport Tom!