Excel: Quick Fractions

 

Just a wee one this week…

 

If you want numbers to appear yet still equal (in equations) the decimal equivalent – there is no need to choose the FRACTION format from the Number drop-down (although you want if you want).

 

Full tip: Excel tip

Categories: Excel

Read Less

PowerPoint: Add a Ticker Tape Readout to Your Presentation

 

PowerPoint has a tremendous amount of special effects – but you can also create your own…like a ticker tape readout…

 

Full tip: PowerPoint tip

Categories: PowerPoint PPT

Read Less

Windows 10: File Explorer (now called Windows Explorer) Gems

 

TIP #1: SEE MORE DETAIL ABOUT YOUR FILES

 

TIP #2: SO MANY MORE WAYS TO FILTER YOUR FILES!

 

Full tip: Windows 10 tip

Categories: Windows Windows 10

Read Less

Windows 10: Customizing It

 

TIP #1:           You can resize the Start menu.

 

TIP #2:           Add more programs (across) without having lower categories migrate up beside your original list (as mentioned in the tip above).

 

TIP #3:           Pin APPS

 

Full tip: Windows 10 tip

Categories: Uncategorized

Read Less

Windows 10: Instantly Tidy Up Your Desktop

 

We all do it – quickly save files to our Desktop just to save them in a hurry without having to think about where we should store them. Or maybe we know we’ll only need the files for a short while. Before you know it, your Desktop is one cluttered mess and you can barely see that beautiful picture of a Cuban sunset that you have for your background.

 

Full tip: Windows 10 tip

Categories: Windows Windows 10

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 10 tip

Categories: Windows Windows 10

Read Less

Word (and PowerPoint): How to Obtain Unicode Characters

 

I was writing a manual and needed a ? character to describe file security. I didn’t want a GRAPHIC IMAGE – that would have been bigger than my texts and, frankly, cumbersome.

 

Well, there are many special characters that can be obtained – not through Wingdings (although that is one way to obtains special characters) – but using the UNICODE method.

 

First, you need to know the Unicode for the symbol/character, you want. Here are some fun ones…

 

Full tip: Word tip

Categories: Word

Read Less

Windows 10: PIN a specific folder to Windows 10 File Explorer

 

I use my CTC OneDrive (for Business) folder more than any other on my computer. So, when I open the File Explorer, 99% of the time it’s because I want to access that particular folder.

 

But the File Explorer opens to your Quick Access list, by default. What to do?

 

It’s too many steps to create a custom Windows 10 shortcut that automatically opens to that folder. Besides…sometimes you might want to open File Explorer to a different folder.

 

So, I say…PIN your favourite folder to the File Explorer icon located down on your taskbar at the bottom of the screen…

 

Full tip: Windows 10 tip

Categories: Windows Windows 10

Read Less

Excel: Seven dandy keyboard (gotta love them) shortcuts

 

Some of these are repeated from earlier tips – some are new.

 

How many are you using?

 

Full tip: Excel tip

Categories: Excel

Read Less

Outlook: Are You Using These Two Time-Saving Shortcuts?

 

CONTACTS (PEOPLE) TIP (Contacts is now PEOPLE in the latest version of Outlook (2016)).

If you need to create multiple new contacts – from the same company…

 

MAIL TIPS

What a productivity killer: to keep getting distracted by email notifications for every single piece of email that arrives – especially when you’re only CC’d or spammed in many of them.

So – set up a RULE to limit desktop notifications to only emails sent DIRECTLY TO YOU.

 

Full tip: Outlook tip

Categories: Outlook

Read Less