TECH TREATS: 2017

NEW GOOGLE CALENDAR - SHARE WITH GROUP

It's so much easier with the NEW GOOGLE CALENDAR to SHARE with a GROUP because the NEW Google Calendar recognizes created Groups.

GOOGLE CALENDAR - NEW GOOGLE CALENDAR

GOOGLE CALENDAR has a NEW Look! I think you're going to love it! I do!

If you use certain words in the description of your event, Google has a picture for that event. For instance, if you use "breakfast", "lunch", or "dinner" Google will put a picture of one of those on your event. Google will also put a picture on the event if you use the name of the holiday (try Christmas and New Years Day!) or use the words "wedding", "bridal shower", "baby shower", etc.

TECH TREAT of the MONTH - DECEMBER 2017

Check out the NEW GOOGLE CALENDAR! What a great CHRISTMAS treat!

GOOGLE CALENDAR - SHARE WITH LARGE GROUP

Need to SHARE your GOOGLE CALENDAR with staff or a LARGE GROUP of people? Here's a little trick! Don't type all of those emails!

GOOGLE SHEETS - DROPDOWN LIST

If you want consistent information in your GOOGLE SHEET, control what's entered in your Sheet by using a DROPDOWN LIST.

EXCEL - INSERT DROPDOWN LIST

INSERT a DROPDOWN LIST in EXCEL to control what's entered in your spreadsheet. I'm all about control - except in real life!

Inserting a dropdown list in Excel works best if you create your list ahead of time. I type the list on another sheet within the spreadsheet so that it's easy to access. If you need to edit your dropdown list, you can just edit the list on the other sheet and it will update the dropdown. You can even have multiple lists on the sheet if you have other questions that need a dropdown list. I also hide the sheet with the list so that it can't be accessed by other people. To do this, right click over the sheet tab and select Hide.

TECH TREAT of the MONTH - NOVEMBER 2017

You'll be THANKFUL that you learned in EXCEL how to INSERT A DROPDOWN LIST!

POWERPOINT - REUSE SLIDES

Add slides from another POWERPOINT to your presentation with REUSE SLIDES. It's a great hidden Tech Treat!

WINDOWS - SNIPPING TOOL

Find the SNIPPING TOOL in Windows installed apps, pin to taskbar, and start snipping! One of my Favorites!

WORD - SAVE AS PDF

If you don't want your WORD document to be altered when other people open it - SAVE IT AS A PDF! It's so easy to do!

PDF actually stands for Portable Document Format so the name tells you that it's meant for documents that are being sent. One of my pet peeves is when people send official documents to me in Word format. I'm always astounded that they aren't worried about the document being altered. On the reverse side of SAVE AS PDF is the most common question that I get asked - "How do I edit a PDF?" The main reason that I usually SAVE AS A PDF is so that my document can't be edited! Most people don't really understand that PDFs are not meant to be edited but that doesn't stop them from trying - or asking!

TECH TREAT of the MONTH - OCTOBER 2017

Choose SAVE AS PDF and don't be HAUNTED by WORD documents that are altered when opened by others!

GOOGLE DOCS - CAPITALIZATION

Use CAPITALIZATION in GOOGLE DOCS to Change the Case of text with the click of a button! Never re-type the text again! This is definitely one of my Favorites!

EXCEL - FLASH FILL

This still blows my mind! EXCEL FLASH FILL is amazing!! Type a few words and EXCEL knows exactly what you want to do! Wow!! You can see why it's one of my Favorites!

GMAIL - PREVIEW PANE

Want a faster way to check your emails? Try the PREVIEW PANE in GMAIL and quickly preview your email messages!

TECH TREAT of the MONTH - SEPTEMBER 2017

Change your GMAIL view to PREVIEW PANE to handle all of those BACK TO SCHOOL emails!

POWERPOINT - LINK TO ANOTHER SLIDE

Here's my nod to Hurricane Harvey - LINK TO ANOTHER SLIDE in POWERPOINT and make your presentations interactive!

GOOGLE SLIDES - LINK TO ANOTHER SLIDE

It's easy to LINK TO ANOTHER SLIDE in GOOGLE SLIDES and it makes your presentations interactive!

GOOGLE CALENDAR - FIND A TIME

Trying to schedule a meeting? Use FIND A TIME in GOOGLE CALENDAR to see who's available before you set up the meeting!

GMAIL - ATTACHMENT WARNING

How often have you forgotten to ATTACH a file with your email?? GMAIL will WARN you - if you use the word "attached" in your email! Wow!!

GMAIL - ENABLE UNDO SEND

If you ever make mistakes or forget anything, you need UNDO SEND in GMAIL! ENABLE it and have up to 30 seconds to recall a sent email! Amazing!

TECH TREAT of the MONTH - AUGUST 2017

Who needs an ERASER when you can use UNDO SEND in GMAIL? Be sure to enable it!

GOOGLE SHEETS - FILL DOWN

Like Excel's Fill Handle, use FILL DOWN in GOOGLE SHEETS to fill cells, repeat patterns, copy formulas, and save lots of time!

EXCEL - FILL HANDLE

Use the powerful FILL HANDLE tool in EXCEL to fill cells, repeat patterns, copy formulas, and best of all, save lots of time!

GOOGLE DOCS - EMOJIS

Have fun with technology this summer! Type with EMOJIS in GOOGLE DOCS. See what's on the menu!

GMAIL - VACATION RESPONDER

It's vacation time! Let people know you're not available with VACATION RESPONDER in GMAIL, then relax and enjoy!

TECH TREAT of the MONTH - JULY 2017

Going on vacation this summer? Use VACATION RESPONDER in GMAIL to notify anyone who emails you.

GOOGLE SLIDES - IMPORT SLIDES

IMPORT SLIDES is a fast and easy way to insert slides from another GOOGLE SLIDES presentation into your presentation.

TECH TREAT of the MONTH - JUNE 2017

Need to use a slide from another presentation? No sweat! Use IMPORT SLIDES in GOOGLE SLIDES!

GOOGLE - MORE FONTS

It's so easy to add MORE FONTS to your Font List in GOOGLE! You can do it in Docs, Sheets, Slides, and Drawings! I love fonts! This will always be one of my Favorites!

POWERPOINT - PHOTO ALBUM

Need to create a slideshow with lots of photos? PHOTO ALBUM in POWERPOINT is a fast and easy way to do it!

GMAIL - CANNED RESPONSES

Save time and use CANNED RESPONSES in GMAIL for any emails that you send regularly! You can even include pictures and links!

EXCEL - TEXT TO COLUMNS

EXCEL has it all! You can split the text in a column with TEXT TO COLUMNS. It only takes 2 easy steps! Check it out!

WORD - QUICK PARTS

Use QUICK PARTS in WORD to save any content and insert it in a document later. Perfect for signatures!

GOOGLE SHEETS - SPLIT TEXT TO COLUMNS

You can SPLIT TEXT TO COLUMNS in GOOGLE SHEETS with just a few clicks! It couldn't be any easier!

TECH TREAT of the MONTH - MAY 2017

Life will be ROSY when you use SPLIT TEXT TO COLUMNS in GOOGLE SHEETS!

GOOGLE SLIDES - PAINT FORMAT

And finally . . . . PAINT FORMAT is not just for copying formatted text in GOOGLE, either. See what it can do for pictures in GOOGLE SLIDES!

POWERPOINT - FORMAT PAINTER

The FORMAT PAINTER is not just for copying formatted text. See what it can do for pictures in POWERPOINT (it works for pictures in Word, too)!

GOOGLE SHEETS - PAINT FORMAT

Good news! PAINT FORMAT in GOOGLE SHEETS is just like the Format Painter in Microsoft Excel. So glad that Google wants to make it easy for you to copy formatting in SHEETS, too!

GOOGLE DOCS - PAINT FORMAT

PAINT FORMAT in GOOGLE DOCS is just like the Format Painter in Microsoft Word. Google wants to make it easy for you to copy formatting, too!

EXCEL - FORMAT PAINTER

Guess what?!? The FORMAT PAINTER is amazing in EXCEL, too! So easy to copy formatting and saves you so much time!

WORD - FORMAT PAINTER

The FORMAT PAINTER in WORD is amazing! It makes it so easy to copy formatting and saves you so much time!

GOOGLE KEEP - INSIDE GOOGLE DOCS

You can access and insert your GOOGLE KEEP notes, voice notes, lists, pictures, and more INSIDE GOOGLE DOCS!

TECH TREAT of the MONTH - APRIL 2017

GOOGLE KEEP will help you stay organized! No FOOLING!

Your notes, voice notes, lists, pictures, and more will be on all your devices.

GOOGLE DOCS - UPDATE on CAPITALIZATION

UPDATE: You don't need an Add-On in GOOGLE DOCS to Change Case now. CAPITALIZATION is now under the Format tab.

GOOGLE DOCS - VOICE TYPING

This is amazing! VOICE TYPING will actually type in a GOOGLE DOC for you, letting you truly be "hands-free" with one click!

GOOGLE SHEETS - QUICK SUM DISPLAY

GOOGLE SHEETS has a QUICK SUM DISPLAY that is just like the Status Bar in Excel. It's a great easy way to get sums, averages, counts, and more without having to enter a formula.

EXCEL - STATUS BAR

EXCEL has so many hidden treasures and the STATUS BAR is one of them!

GOOGLE DOCS - CAPITALIZATION

I love the Change Case button in Word so much that I had to find it in GOOGLE DOCS, too! It's called CAPITALIZATION and it's under Format. It's one of my Favorites!

WORD - CHANGE CASE

Finding the CHANGE CASE button in WORD was the best discovery! No more re-typing text that I wanted to change to uppercase or lowercase! It's one of my Favorites!