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!

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.

GMAIL:

Ten Reasons to use Gmail

GOOGLE CALENDAR:

All About Google Calendar (printable!)

GOOGLE DOCS:

• Excellent Tour of Google Docs
• Google Docs in Plain English:
• Google Docs: A Tutorial (printable)!
• Idea: Docs for Teachers
• Using Forms in Google Docs:
• Collaborate in Google Docs
• Advanced: Creating images with Google Spreadsheets
• Advanced: Teach Collaborative Revision with Google Docs:

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.