Windows 10: Multi-Desktops

 

Windows 10 made its debut in 2014 but people weren’t stampeding to install it – probably because of the disaster that preceded it: Windows Vista. But Windows 10 is here – and it’s pretty terrific with some note-worthy new features. One of which is the ability to have more than one desktop layout. Let’s say you’re working on two projects simultaneously.

 

For Project A, you’ve opened two Word documents, an Excel spreadsheet, and a web browser.

For Project B, you’ve opened a Word document, an Excel spreadsheet and PowerPoint presentation.

That’s mean you’ve got 7 apps running – all entwined – making it cumbersome to jump back and forth between two particular programs.

 

Well…you have two separate Desktops – one for each Project. That means that you never have to sort through any apps that aren’t involved in that project. When you want to work on the other project, just switch over to your other Desktop…and now you’ve only got those programs to deal with.

 

Full tip: Windows tip

Categories: Windows 10

Read Less

Excel: Emailing a Single Sheet from an Excel Workbook

 

SCENARIO: You want to email someone a single sheet from your multi-sheet Excel file.

 

There is no “quick” way to do this. However, there are two ways you can send a single sheet…with work. I’ll give you one method now – and the other next week.

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel: Quick Range Names

 

For intermediate and advanced Excel users, RANGE NAMES are a terrific time-saving feature.

 

But if you have a spreadsheet that contains a lot of range names, you might find yourself forgetting some of the names and having to: open the NAME box to display all the range names – then clicking a name to see what range of cells it represents. And that’s the fast method – going through the FORMULAS tab is more cumbersome.

 

A much faster way to see your range names…

 

Full tip: Excel tip

Categories: Excel

Read Less

Windows 10: Record Quick Videos

 

You’re trying to explain a software function or concept to someone – and they’re just not getting it?

 

Show them exactly what you mean – by sending them a mini-video.

 

If you are doing this on a laptop – you can use the laptop’s built-in microphone. If you’re doing it on a desktop computer – you’ll have to have a microphone plugged in.

 

These instructions assume you’re using a laptop.

 

Full tip: Windows tip

Categories: Windows Windows 10

Read Less

Excel: Generate a Unique List (get rid of Duplicates) – Method #1

 

Scenario:

You have a list of entries listed down a column – a number of which are duplicate/triplicate/etc entries. You’d like the list cleaned up so that you have only ONE of each entry option.

 

Solution:

Use the REMOVE DUPLICATES feature.

 

Full tip: Excel tip

Categories: Excel

Read Less

Outlook: Delegate Replies

 

Scenario:

You’re in charge of an event. You need to email dozens of people about the event. However, any questions or other responses should go directly to a colleague.

 

If you simply ASK, in the email, that people respond to someone else…inevitably some people will miss that part of the message, or forget – and you’ll end up getting the replies that you didn’t want.

 

 

Solution:

Turn on the DIRECT REPLIES TO function.

 

Full tip: Outlook tip

Categories: Outlook

Read Less

Word: Two Table Tips

 

Tip #1: Auto-Number Table Rows

 

Tip #2: Quick-Delete Table

 

Full tip: Word tip

Categories: Word

Read Less

Outlook: Private Appointments

 

Scenario:

You are sharing your calendar with a colleague. You have given them permission to see your appointments – all (Full) details.

 

However, you are making an appointment that you would like to keep private – so your colleague cannot see anything but the title of the appointment.

 

Solution:

Leave their permission level alone – just mark this appointment as PRIVATE.

 

Full tip: Outlook tip

Categories: Outlook

Read Less

Outlook: Making Unread Email Stand Out

 

Full tip: Outlook tip

Categories: Outlook

Read Less

Word: Editing a Password-Protected Document

 

First of all – this tip is NOT about being open a Word document that is locked via a PASSWORD-TO-OPEN password. If you’ve lost that password – you are out of luck.

 

This tip is about how to remove the password from a FILL-IN FORM that you’ve created and locked (FOR EDITING) but forgotten the password (or the employee has left the company, etc.)

 

It’s a lot of steps – but those of you who have been faced with the daunting task of recreating a fill-in form will appreciate that it’s still fewer steps than starting from scratch.

 

Full tip: Word tip

Categories: Word

Read Less