The power goes out…
The program stops responding…
You entire system crashes…
Whatever the cause, you just had the program close unexpectedly and your work is gone… gone… gone…
Or maybe not.
If you’ve got the AutoRecover feature active, then you might be in for a pleasant surprise!
With the AutoRecover feature… Continue reading
I don’t know about you but, when I’m using MS Excel, I’m always merging cells to make everything look “just right”.
The problem is that once cells are formatted that way, there are a lot of things you may try to do with your worksheet that will not work with cells merged.
So, now what?
Well, I usually find myself separating… Continue reading
So, you like to use MS Excel’s AutoFilter to take a look at your data? (Click here to read about AutoFilters at WorldStart.com)
Ever find yourself thinking that it would be nice to see the filtered data as a graphic?
Did you try it?
Yes, you can create a chart of the filtered data to truly “see” what the… Continue reading
Ever find yourself looking at a long list of data containing duplicates and it’s your job to remove the extras?
Sometimes there’s duplicate data for a darn good reason and sometimes it for not only a bad reason, but it’s unacceptable to boot!
If you’re in the latter situation and need to get rid of the duplicates, then you’ve got to be looking for… Continue reading
So, you’ve found yourself once again entering a bunch of text into an Excel worksheet… and once again, the text is getting repetitive.
Let’s say that you’ve got a list of employees and need to enter the department they work in for each one. This means that you’re in column B typing the same things over and over again – after all, there are a finite number… Continue reading
Well here we are, several years into learning to work with the Themes that were introduced with Office 2007.
Personally, I really like them, but then again I tend to do a lot with shapes and SmartArt type diagrams with my students, to help them see the connections that they need to make.
At any rate, I use Themes or at least parts of… Continue reading
MS Excel: Excel Has Equal Sign Issues?
Well, sort of…
I’d say that Excel has an issue when you’re actually trying to type an equal sign into a cell without starting a formula – in other words you need to treat the equal sign like text instead of a formula starter.
(I found that my Excel 2007 would let me create… Continue reading
If you tend to take information from Word, PowerPoint, the Web, or wherever to MS Excel, then I’m positive that you know about your formatting choices when you paste.
We’ve all seen the Paste Options button appear. This is where you can decide to have the information keep its original formatting, or have Excel reformat it to match the rest of the worksheet.… Continue reading
When working with a very long document, I often find myself scrolling back and forth between different locations of the document to reference, move or copy information from one place to another.
No doubt about it… it’s frustrating.
There’s nothing worse than going to page 25 to retrieve information, then scroll up to page 8 and forget what you just found, by the time… Continue reading
Do you struggle in a constant battle with Excel and your computer monitor?
Do you always feel like you can’t see enough at one time… whether the problem is a small monitor or a very large worksheet?
Either way, you want to see more without shrinking everything – the eyesight is bad enough – we certainly don’t need to be squinting to read tiny… Continue reading
