I love it when I see people getting excited about Excel commands. mrmadden77Robert Madden The answer to life’s problems (at least for today): =CONCATENATE(B2, LEFT(A2,2), RIGHT(F2,4)) 19 minutes ago One of my favorite things to teach in an advanced Excel class is the concept of Concatenate, but who can remember that word or how…
Category: Apps
Nudge with shift key in drawing
When I am drawing in PowerPoint or Google Presentation sometimes I need to nudge a shape over, but the arrow keys nudge it over too much. Hold down the shift key while using arrow keys and your object you are trying to move will move one pixel at a time to help you get precise…
Step One: Title your Google Doc
When you start a document in Google Docs it is defaulted with the name “Untitled document.” Before you start anything on your document you want to CLICK on the words “Untitled document” and name it something meaningful. Several times I have received notification that someone has shared with me “Untitled document” which gives me…
Table of Contents in a Google Doc
A feature in Google docs is the ability to create a table of contents. Start a google doc From the insert menu create a table of contents. This will insert at the top where the table of contents will go. You will have to update each time you have new parts to your TOC. The…
Google Voice for Educators
TjHouston.com posted to his blog 5 reasons why every educator should have a Google Voice account. I have blogged previously about my love for Google Voice in the classroom. I will add in a couple of my own reasons. Keeping my cell phone number private, I give out my Google Voice number to students and…
Add a Favicon to your Google Site
Update: Previously I had linked to a blog posting by Jonathan Wylie and his site educationtechnologyblog.com. Unfortunately the posting has been taken down. In response I have posted on my blog the step by step directions for creating a favicon on your Google Site. Click Here to visit my step by step directions. When I create my…
Inserting Images into a Google Spreadsheet
If you want to insert an image into your Google Spreadsheet you will want to use the formula: =image(“url”) Type the formula right into the cell in the spreadsheet. Make sure you start with an equals sign. You will also need quotations around your URL. My favorite trick is to use www.tinygrab.com and take a…
Math Symbols in Google
If you want to put math symbols into your Google Presentations it can be a little tricky. In Google Docs there is an equation editor that will allow you to directly insert equations. (Note: If you know LaTeX you can use the LaTeX notation instead of using the toolbar to save yourself time). However, in…
Google Docs in the Classroom
The information on how to go Google in your classroom was better than I could do, I am copying what was listed: https://docs.google.com/View?docid=dcdn7mjg_72nh25vq Using Google Docs in the classroom: Simple as ABC What is Google Docs? Google Docs is a free, Web-based word processing, presentations and spreadsheets program. Unlike desktop software, Google Docs lets people…
Switch to Google Docs
I am becoming more and more convinced that most people do not need Microsoft Office. There are a few people who need advanced features in Office, but most people do not need it. Here is a link to a list I made in response to someone asking me a question about changing the lame defaults…
Collaborating with Google Docs
I am a fan of collaboration, and I’m always trying to spread the google docs love, but today was just the ultimate for me. I run the neighborhood association and was tardy on making the agenda for the meeting. I duplicated the last months agenda and within a couple of minutes my communications officer, Barb,…
Google Voice in the classroom
What is Google Voice? In short it gives you a new phone number that you can attach multiple phone numbers to. So an individual can call your Google Voice number and it will ring all the phones you put in the settings AT THE SAME TIME. But the beauty of it is that you can…
Google Docs – Text to Columns in a spreadsheet
If you are an avid excel user like me then you probably like the text to columns feature which will take one cell and split it into multiple cells based on a delimiter. I use this a lot when I have a spreadsheet that has peoples names in it. Oftentimes the first and last name…
Sharing a Google Doc
One of the powerful tools about Google Doc’s is the ability to share. This enables collaboration and also to keep others in the loop on your project. To share directly with another person click on the “SHARE” button in the upper right hand corner of your google doc. If students put in your email you…
Google Forms Notifications
When using google docs you can create forms to allow parents/students or colleagues to send you information. One thing you want to make sure you do is Go to docs.google.com Make your form Open your spreadsheet that is created when you make a form. Go to tools Choose notification rules Select for it to email…
You must be logged in to post a comment.