Category Archives: Excel

Excel: Prest-o Chart-o

Get ready….this one’s pretty darn exciting….

 

Next time you need a chart…

 

Full tip: Excel tip

Read Less

PowerPoint: Three Little Shortcuts Worth Using

Faster is always better. So…here are a few ways to do things faster in PowerPoint.

1. Duplicate an object

2. Selecting Multiple Objects

 

Full tip: PowerPoint tip

Read Less

SHADING ALTERNATIVE SPREADSHEETS ROWS

If you have a long spreadsheet to print sometimes it’s nice to make it easier to read (across) by shading every other row…

 

Full tip: Excel tip

Read Less

Excel: Transpose a Data Table

Have you ever created a spreadsheet then realized that you should have had the one set of headings go ACROSS the spreadsheet (instead of down) and the other set of headings go DOWN the spreadsheet (instead of across)? Of course you have.

 

Here’s an incredibly quick fix.

 

Full tip: Excel Tip

 

Read Less

Excel / Outlook: Linking Dates in Excel to your Outlook Calendar

What? Three Outlook tips in a row? Well, I was going to do something else but someone asked me a great question last week about taking “due” dates from an Excel spreadsheet and making Outlook reminders out of them. So, you can thank Pam from Elliot Lake for this one…

 

Full tip: Excel and Outlook tip

Read Less

Excel: [CTRL] Freak

The [CTRL] key is the “shortcut key” for all Office programs – but it’s not just useful for things like [CTRL]B (for BOLD) and [CTRL]S (for SAVE). Here are two other uses for the [CTRL] key in Excel…

 

Full tip: Excel tip

Read Less

Excel: Identifying those nasty text cells

To perform calculations – of course you need NUMBERS. But in Excel you can sometimes have cells which appear to contain numbers but they really contain text. DATE cells especially.

 

To identify whether a cell contains text…use the T function and you’ll catch the culprit(s).

 

Full tip: Excel tip

Read Less

Excel: Alternative-row shading

You’ve got a big long spreadsheet to print. You’d like to make it easier to read by shading every other row. Do NOT (not, not, not) do it by hand (using the [CTRL] key to select every other row…because it’s incredibly wrong).

 

One method (you know there is always more than one way to do anything in Excel…ie, FORMAT AS TABLE (but it comes with baggage)) is to use CONDITIONAL FORMATTING. It will take of this quickly and easily for you – and allow you to insert and/or delete rows within the formatted range…without mussing up your paint job.

 

Full tip: Excel tip

Read Less

Excel: What is your Problem?

This is not the most exciting tip I’ve ever put out (and I know some of them are downright spine-tingling!) but sometimes a tip can be helpful by – not telling you what to do…but by telling you what not to do. Below is a list of the most common error messages that you see in Excel; what they mean – and how to fix them fast.

 

NOTE: When you see an error indicator in a cell you’ll also likely see an error alert (a little green triangle in the upper-left corner of the cell). If you click on the cell then just hover over the green triangle – it will tell you what the problem is. Some of these pop-ups are clear…some are so unclear – they’re not worth the effort to read (yeah…I’m talking about YOU little Mr. #NULL!).

 

Full tip: Excel tip

Read Less

EXCEL: Quicker Data Entry

Pretty dinky little tip today – but hey…don’t whine…it’s a tip.

 

Full tip: Excel tip

Read Less