Here’s the scenario:
You just finished working on a masterpiece in MS Word and you’re in the Print Preview window taking one last look at it. You know, just to make sure it’s perfect.
Then suddenly, there it is. A mistake!
What do you do?
Close the Print Preview window, taking you back to the document where you… Continue reading
Ever have a presentation to give and some information you’d like the participants to know as they are coming into the room and settling down? Information maybe along the lines of a welcome, your name, materials to pick up, whatever…
What did you do?
Did you create a slide with a list of information and just
Have you ever needed to use exponents in an MS Excel formula, but you didn’t know how?
I mean, maybe you need to square the value of a cell or something similar.
Either way, wouldn’t it be nice to know how to enter the power properly? You know, so you can avoid the whole multiplying the same number over and over in your formula… Continue reading
Ctrl + Alt + V : Displays the Paste Special dialog box after the completion of a cut or copy.
Ctrl + Z : Undo
Ctrl + Y : Redo
Ctrl + F : Opens the Find & Replace dialog box (except in Outlook).
Ctrl + L : Left aligns text (except in Excel).
Ctrl + E : Center aligns text (except in… Continue reading
Have you ever found yourself working in MS Excel and needed to enter fractions? What did you do?
(Besides have flashbacks to middle school where you labored endlessly over those dreaded things!)
I know I’ve made them into formulas before. Basically, I divide the numerator by the denominator, add on the whole number and then convert the whole thing to a decimal in the… Continue reading
Did you give yesterday’s Date Picker feature for MS Word 2007 a try?
I know that I really love the idea… especially for templates.
Anyway, as I was working with the Date Picker I noticed, as I’m sure so did you, that the date is formatted in a way that I would rarely use…
12/30/2009
This… Continue reading
Do you have a Word 2007 file or template containing a date that you must change every time you use it?
When you get to that point what happens?
I don’t know about you but more times then I’d like I’m either digging out a calendar or going to the one on my computer. Either way, it’s annoying.
And what about… Continue reading
So, if you remember this tip then you’re up to speed on one way to liven things up when you’re working with charts in MS Excel… multi-colored bars are easy and definitely more interesting than the default.
If you’re like most people I’ve seen using Excel then you created the chart as quickly as possible meaning that you have rectangular bars… or, maybe if you… Continue reading
So, you’ve got a great presentation that’s simply perfect. The right information, color scheme, design and animations… too bad you need to get rid of the animations for this go-around.
You’ve got a more limited presentation time so you need to keep things moving at a little faster pace then you would with the animations.
Or, maybe you’ve just got an audience… Continue reading
Ever try to paste information into Excel from some other application?
Did you get something that looks a bit strange? Maybe like this…
Looking to get rid of the garbage that came along with the information? (I just bet you are since the other options involve a lot of work along the lines of manually editing or entering all the… Continue reading
What’s your preferred View when working in MS Word?
If it’s the Print / Page Layout view then you don’t have a clue about what I’m about to ask, but for the rest of you…
Do you find that when working in MS Word you’re constantly scrolling left and right to see all of your text?
Maybe your monitor… Continue reading
Have you ever found yourself playing the highlighting game in MS Excel? You know, you’re trying to highlight a certain area with your mouse, but instead, you find the file flying by, creating incredibly huge highlighted areas.
Now, many of you may know a lot of keyboard tricks for highlighting using the Shift key combined with the arrows, Page Up, Page Down, Home and End… Continue reading
OK – So while I’m on the “good downloads” trend let’s talk about one I recently ran across for Outlook 2007.
Specifically, let’s talk about printing an Outlook 2007 calendar.
If you’re like me, you don’t carry around a planner or some portable electronic device that has your calendar on it but yet you find yourself sitting in meetings wondering if what your schedule… Continue reading
OK – So I’m well aware that the stores have wanted us to be in the “spirit” since before Halloween… but now with the holidays actually upon us I thought you might like some of the spirit for an upcoming presentation.
You can get free holiday PowerPoint templates like these at Presentation Magazine.
You’ll even find templates… Continue reading
When you work with MS Excel do you use the Ctrl + End feature – you know, the one that takes you to the very last column and row of your data?
Have you ever tried to use this one and found yourself way beyond the data?
I have and when I got there I found myself thinking that I hadn’t had data in… Continue reading
Over the years I have found that there are many people who would like to use the right-click menus my tips are always referring to but just hate the mouse.
These right-clicks are great for everyone who’s comfortable with the mouse. And many people aren’t even remotely interested in trying to remember all the key combinations necessary to replace all the stuff the right-click can do.… Continue reading
Do you frequently copy / paste information from documents, emails or the Internet into MS Excel?
If you don’t have your paste options set to match the destination formatting (and quite frankly don’t want it set that way) then you may be getting tired of all the formatting changes you have to complete to make the pasted information match the formatting of the existing data in the… Continue reading
Have you ever created a table in MS Word at the beginning of a document, only to find that it was a mistake? I mean, since you began the document, you’ve probably redone the layout and some of the text just has to go above that table.
But, of course, you’re learning the hard way that MS Word isn’t going to cooperate very easily.… Continue reading
Need to find a contact’s information in MS Outlook now, now, now?!?
Or maybe you just don’t feel like the effort and time it takes to switch to your contacts, choose someone then open up their information to find what you need…
Either way, a time crunch or just looking for an easier way to access the information, I’ve got what you need to… Continue reading
We all know that with an object selected (such as a shape, picture, textbox, etc…) you can use the arrow keys in PowerPoint to nudge them around the slide.
Basically, the amount of movement you get depends upon the grid size setting. The larger the grid spacing is set to be the bigger the nudge the arrow keys will give your object.
But what… Continue reading
Sounds unbelievable – how in the world will we preview the printed version of a worksheet while we edit?
We’re all very used to creating our worksheets then going to print preview. The process always seems to hold surprises. It doesn’t split from one page to the next in any way we had anticipated… the header is so large that it overlaps the worksheet content… the list… Continue reading
If you’re like me, you like to work in MS Word using the Print Layout view.
I simply like to be able to see my whole page, margins and all. I also like to keep an eye on the layout of the document without always jumping to Print Preview.
Now, once in awhile, I find myself working on
Ever find yourself in need of both a left and right alignment of text on the same line in MS Word?
What did you do?
I know some pretty determined people and I’ve seen all kinds of solutions for this. Many included things like a lot of extra spaces and multiple columns and at first, these may seem like a good idea, but they… Continue reading
Have you ever had a chart in a PowerPoint presentation and wondered if it could be animated?
I’m sure you have and if that’s what you needed you simply applied the animation of your choice, watched the whole chart enter at once and didn’t think about it again.
But, I must ask, did you ever wish that you could animate the chart elements (bars, lines, pie pieces, etc…) in a… Continue reading
Or down. Or left. Or right.
Yep, that’s what you can do with a few quick keystrokes in MS Excel. That is, if you know the “magic” combination.
Okay, so it’s not exactly magic, but it still could be a pretty useful skill and worth a look.
If you’ve ever had a cell selected in MS Excel and wanted to quickly… Continue reading
Have you ever accidentally hit one of the Ignore buttons (especially the Ignore All button) when spellchecking an MS Word document?
How maddening is that?
Now, Word isn’t even noting the problem, and you’ve got to very carefully pick through the document to check for the problem, with no assistance from Word whatsoever.
Do you use MS Word’s Find feature?
Ever discover that the Find window is in the way when you’re trying to locate the same text phrase multiple times?
I mean, it really is easier to leave the window open to use the Find Next button repeatedly than it is to close that window and start over each time. The inconvenience of the open window… Continue reading
