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

Categories: Excel Outlook

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

Categories: Excel

Read Less

WORD: Getting Rid of Word’s Automatic List Indent

 

Word now indents number and bullet lists – specifically .25” from the left margin.

 

Don’t like it? You can change it – but so far…only for a document at a time (hey…that’s better than having to do it for EVERY list in your document!)

 

Full tip: Word tip

Categories: Word

Read Less

PowerPoint: Eight invaluable keyboard shortcuts

 

Full tip: PowerPoint tip

Categories: PowerPoint

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

Categories: Excel

Read Less

Word: Quick table-row numbering (after that fact)

Wish you had numbered the rows in a Word table?
(I caught someone typing in the numbers in each cell by hand…may they rest in peace).

Full tip: Word tip

Categories: Word

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

Categories: Excel

Read Less

Excel: 3 common error messages and what to do about them

Error #1: #NAME?

 

Error #2: #VALUE

 

Error #3: This message appears:

Full tip: Excel tip

Categories: Excel

Read Less

Word: Go back, Jack

You know how, when you open up an Excel spreadsheet it automatically places the cell pointer at the location where you were when you last saved/closed it?

 

Do you ever wish Word would let you know where you were working last time you saved/closed one of its documents? (Just say “yes”…otherwise this tip will be moot).

 

Full tip: Word tip

Categories: Word

Read Less

Windows 10: Two nifty shortcuts

Tip #1: Short and sweet

We often work on multiple documents (and programs, of course) at once.
The next time you need to open another (second, third, etc) document in a program (like Word or Excel) that is already running…

 

Tip #2 (better!): Quickly jumping between folders/drives when Opening or Saving File

If you are tired of having to maneuver between various drives and folders when in File Explorer or when using the OPEN or SAVE AS windows in Word, Excel, PowerPoint or Access – add your most-used folders to the QUICK ACCESS list…

 

Full tip: Windows 10 tip

Categories: Windows 7

Read Less