Try your LUCK with MACROS in GOOGLE SHEETS! You'll be the winner!
GOOGLE SLIDES - Insert Audio
It's finally here! We can now INSERT AUDIO in GOOGLE SLIDES!
If you only want audio on the slide where you inserted it, you should select "Stop on slide change" in the Settings. Since your audio file has to be in Google Drive before you can insert it, make sure that you upload it before you go to insert audio. If you record your audio, simply save it to Google Drive. If you're looking for audio files online, there are lots of sites with free audio but I prefer YouTube Audio Library. It will download to your computer and then you can upload it to Google Drive. The awesome Google Slides theme that I used for this presentation is from SlidesMania.
TECH TREAT of the MONTH - FEBRUARY 2020
It makes my HEART so happy that we can finally INSERT AUDIO in GOOGLE SLIDES!
GOOGLE CALENDAR - Calendar Graphics
GOOGLE CALENDAR has built in CALENDAR GRAPHICS that appear when you use specific words in the event title.
Since Google Calendar hasn't put out a list of all of the Calendar Graphics available, you can experiment with words to see if there is a graphic to go with them. For example, if you use the word "movie", there is no graphic, but if you use the word "cinema", you will see a graphic. Not all of the holidays have graphics - yet. Google is always updating so we could see some graphics added as time goes on. The advantage of using the Google Calendar app on your phone is being able to add the emojis. The other advantage is if you're in the Schedule view when using the app on your phone, you will easily see your graphics without having to click on the event.
TECH TREAT of the MONTH - JANUARY 2020
Perk up your GOOGLE CALENDAR for the NEW YEAR and the NEW DECADE with CALENDAR GRAPHICS!
GMAIL - Templates
GMAIL lets you turn frequent email messages into TEMPLATES to save you lots of time!
Templates in Gmail used to be called Canned Responses. They work the same way, they just have a new name! In addition to creating new templates, you can also edit existing templates, and delete templates. I had to do some deleting recently because I had so many templates that my list was really long. They were templates that I no longer needed but I'm sure that I'll be creating many more because I'm such a fan of templates. I use them all the time for everything from simple messages to detailed messages with links and images.
TECH TREAT of the MONTH - DECEMBER 2019
Give yourself the GIFT of time by creating TEMPLATES in GMAIL!
GOOGLE SHEETS - Fill Down
FILL DOWN in GOOGLE SHEETS will amaze you each time you use it!
If a single cell (no pattern) is selected, Fill Down will only repeat the cell contents. When you select cells with a pattern and Fill Down, you will see the pattern repeated. The exception to this is the memorized days of the week and months of the year. You only have to type one day of the week or one month of the year in a cell and when you Fill Down, the pattern will be repeated. This also works with dates and time. If you type a date or time in a cell and Fill Down, it will list the consecutive dates or times. Fill Down will always follow the format (and abbreviation, if used) of the original selected cell(s). Finally, Fill Down can also be used to fill right, fill left, and fill up. P.S. - Fill Down works to copy formulas, too!
TECH TREAT of the MONTH - NOVEMBER 2019
So THANKFUL that FILL DOWN in GOOGLE SHEETS saves so much time!
GOOGLE DOCS - Type with Emojis
Have some fun in GOOGLE DOCS and TYPE with EMOJIS! It works in Google Slides and Google Drawings, too!
Check out each of the emoji categories to see the many emojis that are available. There are even circled and squared letters available under the "Enclosed" category. In addition to being able to change the size of the emojis, you can also change the color of the emoji letters. Even if you don't type with emojis, they are still a great source for graphics.
GOOGLE SLIDES - Paint Format
The PAINT FORMAT tool in GOOGLE SLIDES works great to copy formatting!
The Paint Format tool can also be used to copy the formatting on shapes and text in Google Slides. This is so helpful when you're trying to apply the same formatting throughout a slide presentation. The Paint Format tool is not exclusive to Google Slides. Look for it in Google Docs, Sheets, and Drawings, too, and use it to make your life easier!
TECH TREAT of the MONTH - SEPTEMBER 2019
Using the PAINT FORMAT tool in GOOGLE SLIDES makes it as EASY AS 1, 2, 3 to copy formatting.
GOOGLE SHEETS - Alternating Colors
It only takes 4 clicks to set up ALTERNATING COLORS in GOOGLE SHEETS! How easy is that?!
GMAIL - Create Contact Group (Label)
NEW! Create GMAIL Contact Groups, which are now called LABELS.
With this new way to add people to a Label, you can easily add a person to multiple Labels at the same time. You can also easily move them from one Label to another Label at the same time. When their Contact Card is open, put a check by all the Labels that you want them added to. If you're changing them from one Label to another, uncheck the old Label and put a check by the new Label.
TECH TREAT of the MONTH - AUGUST 2019
Getting ORGANIZED for a new school year? GMAIL CONTACT GROUPS are now LABELS and this is how you create them.
EXCEL - Alternate Row Colors
Easily add ALTERNATE ROW COLORS in EXCEL using the Format as Table
tool.
You can change the design you selected at any time. Just
repeat the original steps to add a design. The filter arrows appear whenever
you select a design. Use the filter arrows to do more advanced filtering and
sorting. If you don't want the filter arrows to appear, click on the Data tab and
click on the Filter icon. Clicking on the Filter icon will turn the filter
arrows on or off. Since a design is selected using the Format as Table button,
the Table Tools will be available to use.
TECH TREAT of the MONTH - JULY 2019
It's VACATION time so let EXCEL do the work for you to add ALTERNATE ROW COLORS!
GOOGLE DOCS - Version History
With VERSION HISTORY in GOOGLE DOCS you'll never have to worry if you delete something. You can restore any version or make a copy of any version!
When you click on File and hover over Version History, you
can select Name Current Version. Naming the version makes it easier to find and
select it when you are scrolling through the Version History. If you select See
Version History and click on an entry from Version History, when you click on
the 3 dots, you can also Name the Version and leave it in the Version History.
Finally, another great option when you click on the 3 dots is the ability to
Make a Copy. This is really helpful because when you Restore a Version, you
lose the current version. With Make a Copy you can keep the current version and
still have a copy of a previous version.
TECH TREAT of the MONTH - JUNE 2019
Don't SWEAT IT if you deleted something in GOOGLE DOCS! Restore it using VERSION HISTORY!
Subscribe to:
Posts (Atom)