Monday, January 13, 2020

Zooming in and Out in Excel


via IFTTT Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn three different methods for zooming in and out in Excel. Each method has its merits. This video covers all three. Here's the practice file for this video: http://bit.ly/checkboxes2 #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/wG3F-3qBFQk

Monday, January 6, 2020

Creating a Calendar in Excel


via IFTTT Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn how to easily and quickly create a customized monthly calendar in Excel. You'll learn how to set up automatic color coding of different kinds of events, how to print your finished calendars, and more. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/_CUnI4NY6c8

Monday, December 30, 2019

Using Checkboxes in Excel - Part 2


via IFTTT Part 1 can be found here: https://youtu.be/qMQ0UB6WyKQ Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel In this Part 2 video on Using Checkboxes in Excel you'll learn how to change the wording results from "True" and "False" to whatever you want the text to be. You'll also learn how to change the cell back ground color and other cell formatting based upon whether or not a checkbox is checked. Here's the practice file for this video: http://bit.ly/checkboxes2 #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/LVu3E64w1-k

Monday, December 23, 2019

Educandy Tutorial - Create Customized Educational Games


via IFTTT Learn how to use Educandy to create fun educational games for students or others to play. Many of the games are simple, such as the anagrams unscramble game, crossword puzzles, word searches, etc., but there's also a crosses and naughts game, a memory game, and more. Each game helps the players to learn or review educational content that you define. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/OD3q4lQaA-E

Monday, December 16, 2019

Quizlet Live - Formative Assessment Game


via IFTTT Learn how to use Quizlet Live to create fun educational games. Quizlet Live is great for classroom use as well as for trainings and other public events. The Quizlet Live game is a collaborative game played in small groups. This video also covers other features of Quizlet, including flashcards, practice tests, spelling activities, and a couple of arcade-type games. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/vt8BoEoZDKQ

Monday, December 9, 2019

Microsoft Word: Using Subscript and Superscript


via IFTTT Learn how to easily add subscripts and superscripts into your Microsoft Word documents. These are great for adding math equations into documents as well as for adding footnotes to reference material, and more. #msword #wordtutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe . https://youtu.be/Pr8XV7KifJs

Monday, December 2, 2019

Using Checkboxes in Excel


via IFTTT Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn how to easily add checkboxes into your Excel spreadsheets. You'll also learn a more complicated method that allows you to link checkboxes to other cells in the spreadsheet. Here's the practice file for this video: http://bit.ly/employeecheckboxes #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/qMQ0UB6WyKQ

Monday, November 25, 2019

Nearpod Collaborate Board Tutorial and Patreon Thank Yous


via IFTTT Learn how to use the free Nearpod Collaborate to quickly collect ideas from a group. Collaborate is great for brainstorming, sharing ideas, and much more, and is useful in the classroom and in the business world. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/L-5KjCaW8SU

Monday, November 18, 2019

Baamboozle - Customizable Educational Game


via IFTTT Learn how to use the Baamboozle website to create fun educational games for the classroom, for staff meetings, corporate trainings, and really for any setting in which you're presenting in front of a group. Baamboozle lets you customize your game to exactly match what you're trying to teach or practice. If you're sick of using Kahoot! over a over, Baamboozle will be a refreshing change. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/eQlfNJZ2TWc

Monday, November 11, 2019

Combining Data From Multiple Cells in Excel


via IFTTT Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn how to easily combine information from multiple cells in Excel and then put the resulting combination into a different cell. This is not the same as adding numbers from multiple cells. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's a link to the practice file that goes with the video: https://ift.tt/2X3sLii https://youtu.be/tkFbTMSiA8I

Monday, November 4, 2019

Using Excel Slicers to Filter Data


via IFTTT My entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn how to use Excel slicers to filter out data that you temporarily don't want to see in your Excel spreadsheets. This is a lesser-known, but very useful, feature that you'll find yourself using more and more. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's the link to a practice file to go with this tutorial: http://bit.ly/excelslicers https://youtu.be/7K_KqD1S2M0

Monday, October 28, 2019

Google Search Secret Tips and Tricks PART 2 - Advanced Search


via IFTTT Learn how to use the Google Advanced Search to search not just for websites but for specific kinds of documents. For example, you can search for Excel spreadsheets, PowerPoint presentations, Shockwave Flash files, Google Earth tours, Word documents and much more. Google Advanced Search can also help you narrow your search results so that you get better results, including searching by language and usage rights. Here's the link to PART 1 of this topic: https://youtu.be/F-pBQwgGoh8 ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Table of Contents: 02:29 - THE WATER CYCLE 02:31 - The Water Cycle 02:34 - Evaporation 02:35 - Evaporation 02:37 - Evaporation 02:38 - Condensation https://youtu.be/QPvc8sinVsU

Monday, October 21, 2019

Google Search Secret Tips and Tricks PART 1


via IFTTT Learn about several hidden Google search tips and tricks, including several handle tools and fun games that are built into Google Search, how to do calculations and conversions, find movie information and more. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/F-pBQwgGoh8

Monday, October 14, 2019

Using the Excel Today Function to Set Target Dates


via IFTTT My entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn about the TODAY function in Excel, which produces the current date. In this video we'll explore how you can use that function to do some really useful and pretty exciting things in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/3hzVcM-orVQ

Monday, October 7, 2019

Easy Screen Recording with Screencastify


via IFTTT Learn how to use the free version of Screencastify to create your own screen recordings or screencasts. Screencastify is a Google Chrome Extension that makes it easy and simple to record your screen. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Check out these two great options for microphones to use with Screencastify: Blue Yeti USB Microphone - Midnight Blue: https://amzn.to/30X2F0M Samson Meteor Mic USB Studio Microphone (Titanium Black): https://amzn.to/2VoqTQz https://youtu.be/v7uScletiPc