Advanced Excel - VLOOKUP Basics 2017 Tutorial

via IFTTT In this advanced Excel tutorial you'll learn how to get started using the VLOOKUP function in Excel. VLOOKUP can help you pull specific information from a spreadsheet based upon a piece of information that you know, for example a part number, title, name, etc. The video mentions a great book called A Wrinkle in Time, and if you're interested in learning more about it, click the link below: http://amzn.to/2BGsJoA https://youtu.be/y8ygx1Zkcgs

Biteable Tutorial 2017 - World's Simplest Video Maker

via IFTTT Learn how to use the "World's Simplest Video Maker" to created fun animated videos or presentations. Biteable makes it easy by providing you with hundreds of pre-made video clips that you can then customize by adding your own text and making a few other adjustments. The results look great! https://youtu.be/iv2mW2z3OtQ

Tech-Lover's Holiday Gift Guide 2017

via IFTTT Learn about some of the best technology gadgets and tools for sale this holiday season. We'll discuss smart home devices, cheap but excellent tech, and lesser-known cool and exotic tech gadgets. Below you'll find links to all of the items mentioned: Amazon Echo Plus: http://amzn.to/2jdoJBy Amazon Echo Dot: http://amzn.to/2klHWnX Amazon Echo 2.0: http://amzn.to/2jQapOC Automatic Pro Car Adapter: http://amzn.to/2jQSxTY TP Link Smart Plug Mini: http://amzn.to/2kk0HIf Google Home: https://goo.gl/ZDZ46x Google Home Mini: https://goo.gl/wB8DmT Ice Orb Levitating/Floating Bluetooth Speaker: http://amzn.to/2Av4nuL Ice 7 Arc Star Floating Bluetooth Speaker (looks like the Death Star): http://amzn.to/2inrkrP Levitating Bluetooth Speaker by ZVOLTZ: http://amzn.to/2kmIdHh iLife A4S Robot Vacuum Cleaner: http://amzn.to/2kmtqfy Kindle Fire 7 Tablet: http://amzn.to/2jf8P9D Fire TV Stick: http://amzn.to/2BICJuz GooDee Mini Portable Projector: http://amzn.to/2A3aglR JFJ Easy Pro Disc Repair Machine: http://amzn.to/2jPyLYS MoviePass: http://ift.tt/yXZSN5 https://youtu.be/tJ6V_Fxcdeo

Uploading Your Music to Google Play Music Library

via IFTTT Learn how to upload your digital music library to the free Google Play Music Library so that you can listen to your music collection in the cloud, on any computer that you sign into and on your mobile devices. Those songs would also be playable on a Google Home or Google Home Mini device. This video also explores the potential educational applications of the Google Play Music Library. Below are links to the music and devices mentioned in the video if you'd like to learn more: https://youtu.be/KZfrqMitgd0

Blended Play Tutorial - Customizable Educational Games

via IFTTT Learn how to use the website Blended Play to create your own customized educational games for your students to play, or for use with family and friends. Blended Play makes it simple for you to enter your curriculum questions into the website and then import those questions into any of the games on the site. This is a great way to play unique, creative games customized to your curriculum. See below for links to some of the buzzer options mentioned in the video: Lights and Sounds Buzzers: http://amzn.to/2rWml86 Learning Resources Answer Buzzers: http://amzn.to/2swm7BQ Lockout Buzzer System: http://amzn.to/2rWJxmK Less expensive Lockout Buzzer System - Wired: http://amzn.to/2rWsaCk Less expensive Lockout Buzzer System - Wireless: http://amzn.to/2s9wHB4 #edgames #blendedplay https://youtu.be/q0DECzjyn-E

Canvas LMS - Creating Custom Navigation Buttons

via IFTTT Learn how to add your own custom navigation buttons to your Canvas courses. This little-known tip is a great way to bring in external websites and resources into your Canvas LMS courses so that they appear right inside your course. #canvas #canvaslms #canvastutorial https://youtu.be/wWWe6PVcRqc

H5P Tutorial - Create Interactives for Your LMS or Website

via IFTTT Learn how to use the H5P website to easily create interactive activities that can be embedded into an online course or onto a blog or website. H5P can also help you take something you've found or created on another website, "import" it into H5P, and then embed it into your course or website. Both of those capabilities should prove to be pretty helpful for teachers who have an online presence of any kind for their classes. #h5p #edgames #edinteractives https://youtu.be/7UH0qWudtp8

Recently the "Technology for Teachers and Students" YouTube channel was named by Feedspot as one of the Top 100 Technology YouTube Channels for Tech Lovers worldwide.  We came in at number 57.  See below for more information.  Perhaps next year we can move up the list to where the channel really belongs. :)

https://blog.feedspot.com/technology_youtube_channels/

Canvas LMS Tutorial - Locking and Unlocking Modules

via IFTTT This Canvas LMS tutorial shows you how to lock and unlock modules so that your students only see your Canvas content that you want them to see, and when you want them to see it. You can make it so that modules automatically unlock when certain conditions are met. #canvaslms #canvas tutorial https://youtu.be/1lCLooPstdE

Using the IF Function in Excel to Program Your Spreadsheets

via IFTTT Learn how to use the IF function in Excel to "program" your spreadsheets to show you certain data. You can create If ________ then _______ statements that can produce powerful results in Excel. #excel #exceltutorial https://youtu.be/atuoioWxiVw

Canvas LMS Tutorial - Setting the Homepage

via IFTTT Learn how to setup your course homepage in the Canvas LMS. In a previous video I showed how to create a Canvas LMS course using modules, but in this short tutorial I show how to determine what the students see as the the course homepage. #canvaslms #canvastutorial https://youtu.be/p6xmxgyVPdM

Canvas LMS Tutorial - Using Modules to Build a Course

via IFTTT Learn how to build your own course in Canvas by using the Modules page to organize and build your course content. Using Modules is the easiest and most logical way to build your Canvas course. If your school or district has signed up to use Canvas, or if you've decided to use the Canvas Free for Teachers account to create your courses, this video covers what you need to know to get started! #canvaslms #canvastutorial https://youtu.be/SjRufr1AR_o

Excel Split Names Tutorial 2017

via IFTTT Learn how to split names in Excel. Sometimes in Excel you end up with too much information in one column, for example first and last names in the same column. This tutorial will show you how to deal with that and easily split the data into two columns so you can more easily sort and filter the data. #excel #splitnames https://youtu.be/yCxnWvD_r_Q

Creating Your Own Excel Templates - Tutorial 2017

via IFTTT Learn how to easily create your own Excel templates so that you can easily and quickly begin filling out an Excel spreadsheet that you use on a regular basis, but one that you need a new copy of each time you use it. This is a time-saving feature of Excel. #excel #exceltutorial #exceltips #exceltemplates https://youtu.be/dgHjAHIBvsI

Advanced Excel - Data Validation and Drop-Down Lists

via IFTTT Learn how to use Data Validation tools in Excel to improve the accuracy of the data in your spreadsheets. One of the Data Validation features you'll learn in this video is how to create Excel drop-down lists so that the person entering data can simply click a button and choose from a list of possible entries. #excel #excel data validation #advancedexcel https://youtu.be/SlWIgMFpsPg