Category Archives: Google

Google Docs – 8 more tips

The article with the details can be found HERE.

Here’s the summary:

  1. Show all keyboard shortcuts:
    • On Mac, press ⌘ /
    • On Windows, press Ctrl /
  2. Use Gmail keyboard shortcuts in List View
    • J  Navigate to the next item in the list
    • K  Navigate to the previous item in the list
    • X  Select/unselect an item
    • S  Star/unstar an item
  3. Less distracting –> Edit Fullscreen [View menu–> Fullscreen. Hit the ESC key to exit.]
  4. Hack the Header styles to quickly add formatting:   To create a new header style, simply format your text how you’d like and highlight it. Then go to the Title menu, click one of the right facing arrows next to a header, and select Update ‘heading X’ to match with X being the header number.
  5. Use the Google Templates to get started:   directory of templates
  6. Let Docs create the Table of contents – only works if you’ve used the header levels in the Title menu. Insert menu –> Table of Contents
  7. Use Conditional Formatting to change the color of a spreadsheet cell based on the contents. For example, you can have the cell color automatically change to red if the test score is less than a 75.
    To do this, hover over the column header and click the arrow icon that appears to bring up a menu. Then click the Conditional formatting… option towards the bottom.
  8. Extrapolate sets of related terms. You’ll just have to read the original for this – but it IS pretty cool – useful is another question altogether, though!

Email Groups in Gmail

Here’s the quick version:

Top left corner, where it says “MAIL” with the down arrow.
Click the arrow, select CONTACTS.
New Group [left side]. Give it a name.
Click on the group name in the list [on the left].
Button up top – add names to the group.
You can manually type ’em in, copy/paste [I presume], etc.
Save the group.
To send to the group you type in the group name in the address field of the new message.

Want more details?

Creating Contact Groups – Gmail help

Quickly create large contact groups – Youtube video

How to make a mailing list in gmail

Google Docs – 100 TIps for Teachers and Students

This is from a Google Doc [naturally]. The links in each tip takes you to a web page with more info.


 

100 Great Google Docs Tips for Students & Educators

Students and educators at online universities have a wealth of learning and productivity tools available to them online. Google offers some of the highest-quality resources on the web to meet all your study and teaching needs, and all you need to access them is an internet connection.

The Google Docs collection provides a streamlined, collaborative solution to writing papers, organizing presentations and putting together spreadsheets and reports. But besides the basic features, there are lots of little tricks and hacks you can use to make your Google Docs experience even more productive. Here are 100 great tips for using the documents, presentations and spreadsheets in Google Docs.

 Keyboard Shortcuts

Navigate your documents and screen a lot faster when you use these keyboard shortcuts for formatting and more.

  1. Ctrl+Home: Get back to the top of your doc.

  2. Ctrl+B: Bold.

  3. Ctrl+E: Center alignment

  4. Ctrl+L: Back to left alignment.

  5. Ctrl+M: Insert comment.

  6. Ctrl+H: Replace.

  7. Ctrl+End: Go to last cell in data region.

  8. Ctrl+Home: Go to first cell in data region.

  9. Shift+spacebar: Select entire row.

  10. Ctrl+Z: Undo.

  11. Ctrl+Y: Redo.

  12. Ctrl+spacebar: Select entire column.

  13. Ctrl+J: Full justify.

  14. Ctrl+Shift+L: Bulleted list.

  15. Ctrl+Shift+Space: Insert non-breaking space.

  16. Page Down: Move down one screen.

  17. Ctrl+K: Inset link.

  18. Ctrl+Shift+F: Full screen.

  19. Page Up: Move up one screen.

  20. Ctrl+Space: Remove formatting.

  21. Ctrl+: Heading style 1. Change the “1” to any number 1-6 and get the corresponding header.

 Productivity Hacks

These hacks will make your Google Docs experience even more efficient and streamlined.

  1. Templates: Use Docs’ 300 templates to get started on different types of documents.

  2. Work offline: View and edit documents even when you don’t have access to an Internet connection.

  3. Create shortcuts: Create shortcuts and bookmarks for new documents, Google Docs home and more frequently visited pages.

  4. Save as different file types: Instead of converting docs to different file types, you can simply change it to HTML, RTF, PDG, ODT and more whenever you save it.

 Features and Tools

Make use of features and tools like Docs Translation or CSS Editing to customize your docs and make them work for you.

  1. Polyline: Draw shapes and lines in Google docs to make graphs, images and examples.

  2. Docs Translation: Find the docs translator under Tools.

  3. Snap to Guides: With this Edit feature, you can line up shapes in your doc automatically.

  4. Reference tools: Google docs comes with access to a dictionary, thesaurus and encyclopedia that you can use within the document.

  5. CSS Editing: Change the display of your doc by manually plugging in your CSS text.

  6. HTML tags: Docs supports, or partially supports, some HTML tags, shown here.

 Collaboration

One of the best things about Google Docs is that you get to share and collaborate on projects with others. Learn how to make the most of these features here.

  1. Shared foldersCreate shared folders and drag-and-drop items from other folders.

  2. Privacy: You can choose to have documents published publicly or privately.

  3. Share, don’t email: Instead of emailing docs back and forth, type in email addresses of people you’d like to share your Google document with, and they’ll be sent an editable, web copy.

  4. Make changes at the same time: You and your classmates can log into the same document at the same time to make edits.

  5. Share a folder: Share entire groups of documents saved in a single file with coworkers and students.

  6. Invite mailing lists as collaborators: You can share a document with all members of your email mailing lists with this function.

  7. Make a presentation in real-time: Invite others to view a presentation you’ve made as you see it too.

  8. Data validation: Make sure everyone is entering data into the spreadsheet the same way by controlling data validation settings.

  9. Allow people to edit without signing in: This means anyone, even if they don’t have a Google account, can sign in and edit your piece.

  10. Remove collaborators: If you want to take someone off a project, click None next to the name of the person you want to remove.

  11. Forum: If you get stuck with a docs problem, you can head over to the forums and find help from other users.

  12. Change ownership: Switch ownership of Google docs as project leaders change.

Files, Folders and Filters

Find out how to use files, folders and filters for optimum organization and a clearer display.

  1. View and unviewed: You can mark new shared documents as viewed or unviewed, like an inbox.

  2. Create subfolders: Make subfolders for better organization. Create, then choose to move it wherever you want.

  3. Drag-and-drop folders: Drag-and-drop folders and docs to spreadsheets, documents and presentations.

  4. Tag: Tag items with certain keywords instead of going to the trouble of moving them to a folder.

  5. Star: You can also star documents, like you would in Gmail.

  6. Upload multiple files: Click “select more files” to upload multiple files in Google Docs.

Organization

These hacks are designed to organize your Google Docs, from starting a new assignment to sharing and publishing.

  1. Color code folders: Color-code the names of folders.

  2. Insert bookmarks: Insert a link to another part of your document, like in a table of contents.

  3. Zip archive: Export Google docs, spreadsheets and presentations in a single ZIP archive.

  4. Block quote: Use this setting to automatically indent and set aside a long quote in your document.

  5. Minimize: Star only the docs you want to see at one time, and minimize everything in the left pane for a minimized view.

  6. Annotate with footnotes: Insert annotations as footnotes to your document easily.

  7. Preview templates: Preview a template before committing to it.

 Edits

With these editing tools, you’ll track comments, save editing history and more.

  1. Color-code comments: You can color-code live comments in Google Docs.

  2. Revision pruning: When you have too many revisions, they’ll automatically collapse, or prune, but can still be viewed in revision history.

  3. Track edits and changes: In Google Docs you can go back and forth between edits that you or collaborators made.

  4. Revision history: View older versions of your document, and choose to “revert to this one” if you choose.

  5. Find and replace: This version of find and replace lets you match cases, match whole words, find previous words, and more.

 Synchronization

Make your Google Docs work with other tools too.

  1. Preview docs in Gmail: You can preview Google docs attachments in Gmail.

  2. Google Finance: Enter information from Google Finance into spreadsheets with this formula Syntax: =GoogleFinance(“symbol”; “attribute”).

  3. Sync with Office Documents: With Syncplicity, you can sync Google Docs with Microsoft Office.

  4. Sync with your server: To work offline, your documents will have to be synced to your server.

  5. Google Mobile: Use Google Mobile to access docs on your phone.

Search

Google Docs uses Google search to find documents and more.

  1. Search PDFs: There’s a search box in the upper right corner of your PDF document.

  2. Search for docs using keywords: If you don’t remember the title of a doc, type in keywords from the document instead.

  3. Advanced search: Find documents by selecting who you’ve shared with, keyword, title, and more.

  4. Search the web: Highlight a word and search the web for matching websites and images.

  5. Search operators: Search operators will help you find starred, hidden and other documents quickly. Example: [is:starred]

 Presentations

Learn how to make and present projects with videos, images and more.

  1. Embed a presentation in a website: Add your class presentations to your website or blog by publishing and pasting the HTML code that is revealed.

  2. Insert tables: You can insert tables into Google Presentations, too.

  3. Sequentially reveal objects on a slide: Bullets and text boxes will be revealed one at a time if you select this option.

  4. Custom colors: You can choose custom colors to add to your presentation.

  5. Hide the gray bar: In presentation view, click on the icon in the upper-right corner of the gray bar at the bottom of your screen to make it disappear.

  6. Chat: Chat with your audience in view presentation mode. You’ll need Adobe Flash Player 8 or above.

  7. Insert videos: You can add videos to your presentation, minimize and maximize it, and move it around your screen.

  8. Hide chat: Keep everyone quiet during your presentation by clicking the left side of the chat module.

  9. Organize slides: You can reorder slides, make duplicate slides, and insert new slides wherever you want.

  10. Replace image and video placeholders: Depending on your presentation’s template, you can replace placeholders with an actual image or video.

 Spreadsheets

With spreadsheets, you can create forms, reports, invoices, portfolios, and other docs that solve problems, save email addresses and more.

  1. Google search inside your spreadsheet: Highlight a word, right click, and select Search the web.

  2. Print as PDF: Choose to print your spreadsheet as a PDF if you want all formatting to stay intact.

  3. Live lookup: Use the following formula in a cell to ask Google to look up quantitative information: Syntax: =GoogleLookup(“entity”; “attribute”).

  4. Roman function: Have numbers displayed as Roman numerals with this formula =ROMAN(number, form).

  5. Create forms: Google Spreadsheets has various templates for forms you can create and have people fill out.

  6. Edit forms: Add section headers to make it easier to divide up forms and make them easier to fill out.

  7. List view: Select list view to load spreadsheets faster, view from your mobile phone and access basic editing features.

  8. Protect sheet: Select Protect sheet to prevent certain collaborators from editing it.

  9. Automatically add email addresses: If you have Google Apps, the email addresses of the people who fill out the form will automatically be saved.

  10. Scientific notation: Adjust spreadsheets so that cells display in scientific notation.

  11. Solve: Maximize and minimize values when you solve problems in your cells.

  12. Add and delete comments: You can add, delete and edit comments in spreadsheets too.

  13. Freeze columns and rows: Freeze rows and columns to stop editing.

 Tasks

These tasks, from printing to tracking tournaments, are examples of other ways you can use Google Docs.

  1. Print as a webpage: You can print your doc so that it displays as a web page.

  2. Insert mathematical equations: Insert Equation makes an equation editor dialog box appear to add an equation to your doc.

  3. GoogleTournament: Create brackets, and let Google automatically update data according to the Men’s and Women’s NCAA Division I Basketball Championship.

  4. Enable offline access: You can install offline access for Google Docs to edit existing documents anywhere.

  5. Track analytics: Track visits to published documents.

  6. Update posts: You can republish posts that are already on your web page if you want to make edits and support an updated version.