Excel Essentials

Excel Essentials

Here are some great links for free Excel tutorials and training:

Using data bars, color scales & icon sets in Excel

Excel Essentials: Raw Data for Pivot Tables

Crash Course in Excel – Video

Understanding Cell References – Video

Working with 3D Formulas in Excel 2016 – Video

Top 25 Excel 2016 Tips & Tricks

Another 15 Excel 2016 Tips & Tricks

Top 15 ADVANCED Excel 2016 Tips & Tricks

Printable Comprehensive Excel 2016 Tutorial

Locking Cells & Protecting Sheets

Training for many software packages, including Excel and Calc – In Pics!

Microsoft Excel Training – broken down by content area

Microsoft Excel 2003 Training

Microsoft Excel 2007 Training

Microsoft Excel 2010 New Features – video

Microsoft Excel 2016 Tutorial

Top 25 Excel 2016 Tips & Tricks

More Excel 2007 Tutorials – includes other Office 2007 Tutorials

Microsoft Excel Chart Tutorial – with voice

OpenOffice Calc Tutorial

OpenOffice Calc Chart Tutorial – printable!

google rocks!

google rocks!

New for 2018:

Google Drive Quick Start Tutorial

Google Drive – Full Tutorial

Google Sheets – 2018 Tutorial

G Suite Learning Center


Here is a brief overview of what Google products have to offer for tech integration in the classroom.


Ten Reasons to use Gmail


All About Google Calendar (printable!)


Powering Your Adult Education Program with Google!

Powering Your Adult Education Program with Google!

Here is the link to the Google Slideshow that was used at my workshop at the 2016 MAEA Conference at University of Maine Farmington. Please feel free to share or use it for PD in your program.

UPDATE: This slideshow has been updated with 2018 resources, and was used to teach a Professional Development workshop at Biddeford Adult Education in Maine.

Apple Devices: How to Use that iPhone or iPad

Apple Devices: How to Use that iPhone or iPad

apple-logo-rob-janoff-01The world seems to be running on iPhones, iPads, and MacBooks these days. If you have recently made the switch, or plan on doing so soon, you could probably use some help. Here are some tips, tricks, and tutorials for your “i” device:

Easy to follow Beginner’s Guide to iPhone (includes initial setup, transferring from old phone, FaceTime, iMessage, camera, and more)

Apple Manuals for all Devices

Video Tutorial Complete Beginner’s Guide – iPhone 5S

Video Tutorial Complete Beginner’s Guide – iPhone 6s & 6s Plus

Video Tutorial Complete Beginner’s Guide – iPhone 7 & 7 Plus





Adobe Photoshop: Demystified

Adobe Photoshop: Demystified

Photoshop is an amazing program with infinite possibilities. For the everyday user, especially the beginner, it helps to have a foundation to get started, and even before attempting to take a class at the college level. My hope with this post is that I can provide you with some of the best tutorials available:

Discover the Creative Cloud Experience

*NEW* Celebrity Before & After Photoshop Images

*NEW* Printable “Intro to Photoshop Tools”

*NEW* Opening multiple images as layers

*NEW* Step-by-Step Instructions on using the Magnetic Lasso Tool

*NEW* Using the Background Eraser Tool (Video Tutorial)


10 Must-Know Introductory Photoshop Skills

What is a layer in Photoshop, and how is it used?

Using the Crop Tool

How to Change a Background in Photoshop

Creative Bloq has done an amazing job of breaking down by content area and ability level. Take it one tutorial at a time, and you’ll be an expert before you know it.


This is a great tutorial introducing Photoshop CC (Creative Cloud): 10 Things Beginners Want to Know How to Do. Check out some of the other videos on that page – pretty cool stuff!

Danny Outlaw has some awesome beginner tips, and much more, in this post.


free “office” options

free “office” options

We have all either sent or received that MSOffice document, spreadsheet or presentation, only to find it’s not a compatible version. It’s also becoming quite costly to purchase the latest and greatest MSOffice version. In my world of education, teachers and students simply don’t have the funds to purchase Office 2007, now 2010…. and beyond. I use all three of the FREE products below.

  1. ThinkFree Online is a wonderful tool that allows the user to log in using their Google account or create a ThinkFree account. PDF’s are easily created out of many file types. Documents, spreadsheets and presentations can be created and shared, or uploaded, edited and/or shared. ThinkFree is friendly to Office 2007 and Office 2010 files. It even has a viewer, should you receive a file that you are unable to read.
  2. Google Docs –  part of the Google suite of free products, Google Docs makes is simple to read, edit and share documents, spreadsheets, presentations and even pdf’s. It does have its limitations – but Google is constantly making changes to improve the quality of Google Docs. I forward anything attachments sent to my work email immediately to my gmail, allowing me to store them in Google Docs.    Here is a simple video to give you an overview: Google Docs in Plain English.
  3. OpenOffice – Don’t purchase MSOffice with your next new computer – simply download OpenOffice, and you’ll be ready for any Office task. OpenOffice is amazing – in many ways, I like it better than MSOffice. Many school systems are moving to OpenOffice, because it saves thousands of dollars in licensing fees. The good folks at Oracle keep OpenOffice fresh, so you are always using a brand new product – not something created in 2003, 2007 or even 2010. There is a bit of a learning curve – especially in Calc and Base – but online resources are plentiful, so don’t panic.
My personal recommendation is to utilize all three of these great packages. I will be posting fresh resources – so check back often, or subscribe to this post for updates. Comment below if you have anything to share, including other similar packages that you like….
The Grand Tour of Google Docs

The Grand Tour of Google Docs

I am thrilled to have the opportunity to present two sessions about Google Docs today to K-5 staff from both RSU57 and Sanford. My colleague, Amanda Doyle, is presenting the same session to 6-12 staff back at Sanford High School. Therefore, we created a companion resource that will assist folks with Google Docs tutorials, tips and resources long after the sessions have ended! Please enjoy these resources, and suggest links that we might add as well.