SchoolCounselor.com eNewsletter #148|
Date of Publication: November 26, 2014
Welcome to SchoolCounselor.com, an electronic newsletter designed to advance counselors' level of technological literacy, application, and integration. You will find practical solutions and answers to technology related problems, especially as they apply to your job as counselor. If you would like to share a tip or trick, or if you would like to ask a question, e-mail Russ Sabella at firstname.lastname@example.org
Please take a moment to visit our Sponsors:
New videos have been added since the last issue:
● Life-Changing Baking Tricks Everyone Can Do
TIPS AND TRICKS
9 Rules For Emailing From Google Exec Eric Schmidt
I like the last one the most which I have found quite useful. From all my accounts, I forward to my gmail account with lots of extra key words. Once in gmail, I can archive the email and make it easy to find later.
Wordcounter is a word count and a character count tool. Simply place your cursor into the box and begin typing. Word counter will automatically count the number of words and characters as you type. You can also copy and paste a document you have already written into the word counter box and it will display the word count and character numbers for that piece of writing. In addition, word counter automatically shows you the top 10 keywords and keyword density of the article you're writing.
Also know that Microsoft Word has a version of this feature available, see here.
Microsoft Excel: Selecting Cells
There are much faster ways to select a dataset than using the mouse and dragging the cursor. Click in the first cell you want to select and hold down Ctrl+Shift, then hit either the down arrow to get all the data in the column below, up arrow to get all the data above, or left or right arrow to get everything in the row (to the left or right, of course). Combine the directions, and you can get a whole column then everything in the rows left or right. It'll only select cells with data (even invisible data). If you use Ctrl+Shift+End, the cursor will jump to the lowest right-hand cell with data, selecting everything in between. So if the cursor is in the upper left cell (A1), that's everything. Even faster: Ctrl+Shift+* (the asterisk) will select the whole data set no matter what cell is selected. (Image)
Want to become awesome with Microsoft Excel? Check out http://www.mydatabootcamp.com/
Great Microsoft Excel Shortcut Keys
Excel, like any great software, has many excellent keyboard shortcuts. Here are some of the best.
●Ctrl+; —Inserts today's date.
● Ctrl+Shift+:—Inserts the current time (the colon is what is in a clock reading, like 12:00).
● Ctrl+Shift+#—Changes the format of a date.
● Ctrl+5—Apples a strikethrough to the text in a cell.
● Ctrl+0— Hides the current column.
● Ctrl+9—Hides the current row.
● Ctrl+F6—Switches between open workbooks (that is, open Excel files in different windows).
● F2—Start editing the current selected cell (much faster than double-clicking).
● Shift+F10—Opens the right-click menu for the cell you're in.Source: http://www.pcmag.com/slideshow/story/327311/20-excel-tips-for-becoming-a-spreadsheet-pro/20
FollowUpThen | Email Reminders via Email Itself
Clear out your inbox. Shorten your to-do list. Never forget to follow up. All with a simple email address.
The Time Elapsed Analysis & Reporting System (T.E.A.R.S.) is a Microsoft Excel add-in that automatically calculates the total amount of time that you have spent in different aspects of your work. After exporting your calendar data from Microsoft Outlook to Excel, this add-in extracts elapsed time, sums up the number of hours in each category, and then produces both a table and a chart. If you ever wondered where your time goes, you will want to use T.E.A.R.S. to learn more.
20 Awesome Things Google Can Do For You
A list of helpful things Google can do for you, along with a few fun secrets that not many people know about.
AVG AntiVirus Free does a great job of blocking and eradicating malware, and it includes extras such as a secure shredder, Do Not Track protection for your browser, and the ability to schedule automated scans.
Also know that many Internet service providers (e.g., Comcast/Xfinity) provide great antivirus software for free. I get Norton Security Suite and I love it. Does more than keep the computer clean but also tuned up and humming. In addition to antivirus, I highly recommend malwarebytes which is available at https://www.malwarebytes.org/antimalware/. The free version needs to be run manually about once a week. I schedule this using Windows task scheduler (see http://windows.microsoft.com/en-US/windows/schedule-task#1TC=windows-7) to learn more.
Test your internet connection speed to make sure you are getting the speeds that your provider promises. I use two of them now and then when I think something isn’t quite right:
WORTHY WEBSITES AND SOFTWARE
Raw is an open web app to create custom vector-based visualizations from your data. That’s a fancy way of saying that it creates fancy charts.
MozBackup is a simple utility for creating backups of Mozilla Firefox, Mozilla Thunderbird, Mozilla Sunbird, Flock, SeaMonkey, Mozilla Suite, Spicebird, Songbird and Netscape profiles. It allows you to backup and restore bookmarks, mail, contacts, history, extensions, passwords, cache etc.
Yet Another Duplicate File Remover
Another duplicate file finder/remover. But this one is ULTRA FAST, safe, easy to use and of course free and open source.
Pixlr has been a favorite online photo editor and mobile app for years. Now, you can get the same Pixlr experience with even more fun and powerful tools on your Mac or Windows computer.
I still love the online version: http://apps.pixlr.com/express/
Quote Pic Maker for Facebook, Twitter, Google Plus, Wallpapers, E-cards, Prints
QuotesCover.com turns any ordinary saying texts into a beautiful typography art picture for use on Facebook, Twitter header, Google Plus, E-Cards, Wallpapers, and Prints.
7-Zip is a file archiver with a high compression ratio.
LastPass Password Manager
Like many of you, I use a lot of sites and services that require a log in with a password. Complex and different passwords for different sites are an absolute requirement these days and I suspect that only people with total recall can get along without a password manager. My favorite is LastPass. This works on multiple platforms and has served me very well.
( OFFTIME ) - Life Unplugged. - Android Apps on Google Play
( OFFTIME ) lets you customize your connectivity so you can do the things that matter. Unplug and focus on your work, be with the people you care about, or simply enjoy some peace of mind.
Calm is a web-based service that helps you to relax after a particularly busy or stressful time. Just sit back, plug in some headphones if you want, then head to the web site. You can choose a period of 2, 5, 10, 15 or 20 minutes for your session. And you can choose whether you just get to hear calming music, or whether there's also a soothing voice too. Combine those with the flowing, meditative graphics on the screen (or just close your eyes if you prefer) and you'll be back to a calm state in no time.
AllDup - Find Duplicate Files
A free tool that helps you to find and remove duplicate files on your PC.
JUST FOR FUN
FlightGear Flight Simulator
The goal of the FlightGear project is to create a sophisticated and open flight simulator framework for use in research or academic environments, pilot training, as an industry engineering tool, for DIY-ers to pursue their favorite interesting flight simulation idea, and last but certainly not least as a fun, realistic, and challenging desktop flight simulator.
Sleep Talk Recorder app
Do you need solid evidence that your spouse snores? Do you talk in your sleep? The Sleep Talk Recorder app listens for noises while people slumber and starts recording the second it hears any mumbling during the night. The Sleep Talk Recorder is active all night, but it doesn't eat up the space on your phone. It turns on when there's a noise, a loud snore.
Story of the#web25
The World Wide Web has gone from “never heard of it” to “can’t live without it” in 25 years. It took off because of its instant user appeal, but also because it’s open and free. From HTML to hacktivism, the W3C to MP3s, lolcats to LulzSec, from one website to over 180 million, here are its defining moments.
SchoolCounselor.com does not knowingly send unsolicited e-mail. This Newsletter is for subscribers only. If you received it and did not subscribe, please let us know using the link on our home page. We will remove your name immediately.
TO SUBSCRIBE to this newsletter, simply go to the signup page at www.SchoolCounselor.com/newsletter and enter your e-mail address. You will receive an e-mail asking you to confirm your subscription. We will add your e-mail address to the list when you reply to the confirmation e-mail.
TO UNSUBSCRIBE from this newsletter, simply visit the signup page at http://www.schoolcounselor.com/unsub.htm and click the unsubscribe button after entering your e-mail address. Important: You will then be asked to click on a link called “click here” to complete the process. Or, you depending on the database you signed up with originally, you may have an unsubscribe link at the bottom of this email...
TO CHANGE YOUR E-MAIL ADDRESS: If your old address will become inactive, PLEASE
UNSUBSCRIBE with your old address and SUBSCRIBE with your new one.
IF ALL ELSE FAILS send a note. Please allow a week or two for changes to take effect.
Want to advertise in this newsletter? Visit http://www.schoolcounselor.com/advertising.htm
The SchoolCounselor.com newsletter may contain links to sites on the Internet owned and operated by third parties. SchoolCounselor.com is not responsible for the availability of, or the content located on or through, any such third-party site. Information in this document is provided "as is," without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose and freedom from infringement. The user assumes the entire risk as to the accuracy and the use of this document. SchoolCounselor.com will not be liable for any damages of any kind arising from the use of this information, including, but not limited to direct, indirect, incidental, punitive, and consequential damages.
Sabella & Associates, LLC, 4922 SW 26th PL, Cape Coral, FL 33914
Wednesday, November 26, 2014
SchoolCounselor.com eNewsletter #148
- ► 2015 (12)
- ▼ November (3)
- ► 2013 (27)
- ► 2012 (39)
- ► 2011 (75)
- ► 2010 (98)
- ► 2009 (55)
Produced by Sabella & Associates, LLC
Copyright, 2009. All Rights Reserved. Contact Dr. Russell Sabella at email@example.com.