Using Spin Buttons in Excel

via IFTTT Learn how to add spin buttons to your Excel spreadsheets, making it much easier to adjust numbers up and down with just the click of a button. Spin buttons are some of the most useful form controls that Excel has to offer. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe My entire playlist of Excel tutorials: http://bit.ly/tech4excel Here's the practice file that goes with the video: https://bit.ly/excelspinbutton #excel #exceltutorial #exceldashboards https://youtu.be/RWgySRg8_bk

Creating Quizzes in Google Classroom

via IFTTT Learn how to create quizzes in Google Classroom, including the many options and features you can use to make your quizzes more effective. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/oRddkNOTeZI

Beginner's Guide to Microsoft Office Web Apps: Excel, PowerPoint & Word

via IFTTT Learn how to use Microsoft Excel, PowerPoint, and Word, online and for free by using an Office.com web apps acccount. You'll learn how to gain access to online versions of these great tools, how to switch between them, and some of the basics of using them. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See below for recommendations on presenter remotes to use with PowerPoint: Logitech Spotlight (Best of the best): https://amzn.to/30sPS6u Logitech R800 (This is the one I use now. Excellent but a bit pricey.): http://amzn.to/2vbPZY7 Logitech R400 (Cheaper version but still great): http://amzn.to/2vbG4Sg ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/qNbX1qIz1uQ

Beginner's Guide to Zoom Web Conferencing

via IFTTT Learn how to set up and conduct your own Zoom online meetings, classes, and more, by using a free Zoom account. Zoom is web conferencing / video conferencing / remote conferencing software that helps bring people together virtually. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Check out these great options for microphones to use with Zoom: Blue Yeti USB Microphone - Midnight Blue: https://amzn.to/30X2F0M Samson Meteor Mic USB Studio Microphone (Titanium Black): https://amzn.to/2VoqTQz Logitech USB Headset: https://amzn.to/2RIse3R https://youtu.be/73POgvtkFgs

Web Conferencing Options in 2020: Zoom, Webex, and Adobe Connect

via IFTTT Learn about three great options right now for doing web conferencing, video conferencing, remote conferencing, etc. We'll examine the features and options that Zoom, Webex, and Adobe Connect give you for free. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/XSUJN5MHj4E

Intermediate Guide to Excel Dashboards

via IFTTT This video will extend your Excel dashboard skills by showing you how to create links to more detailed information, how to add charts to the dashboard, how to pull data from a completely separate Excel file, and how to improve the look and readability of the dashboard. This video in the 2nd in a series. Here's a link to the first in the series: https://youtu.be/s0E2pmXQcPA Here's the practice file that goes with the video: https://bit.ly/intermdashboards ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #excel #exceltutorial #exceldashboards My entire playlist of Excel tutorials: http://bit.ly/tech4excel https://youtu.be/thmQ63nTn84

Transposing Columns into Rows in Excel

via IFTTT Learn how to easily transpose columns into rows in Excel. In other words, you'll learn how to make your column headings become row headings, and vice versa. #exceltutorial My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's the practice file that goes with this video: http://bit.ly/exceltransposing https://youtu.be/YM49FvS8eck

Loom Screencast Tool - Screen Recording Software

via IFTTT Learn how to use Loom to make your own screen recordings / screencasts for free. Loom can be used either as a Google Chrome extension or as software installed on your computer. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/nN8uWjaBSs4

Using Watch Windows in Excel

via IFTTT Learn how to create a watch window to help you keep an eye on Excel data that is typically far away or hard to find in your spreadsheets. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel The practice file that goes with the video: bit.ly/watchwindows https://youtu.be/f807KA6g-oM

Using LEFT RIGHT & MID Functions in Excel

via IFTTT Learn how to use the LEFT, RIGHT, and MID functions in Excel to extract information from the left side, right side, or middle of your existing data. These functions can be life savers for you when you need to clean up a spreadsheet or separate out certain data. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel The practice file that goes with the video: http://bit.ly/excelstring https://youtu.be/PbWRI7ANjsE

The Beginner's Guide to iMovie

via IFTTT Learn everything you need to know to start using Apple's iMovie to edit your videos. You'll see how to import videos, images, and audio, edit and adjust them, and then finalize your movie project. #imovie ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here is the video footage in case you want to download and use it to practice: https://bit.ly/archesvideos https://youtu.be/nV_1eCZ360M

Using the New IFS Function in Excel

via IFTTT Learn how to use the great, new IFS function in Excel. IFS lets us create up to 127 IF statements in one formula! This can make the old nested IF strategy completely obsolete. In the video you'll see two different examples of how useful the IFS function can be. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Here's the practice file that goes with the video: http://bit.ly/excelifs https://youtu.be/HVSTB4ACBjg

Grading in Google Classroom plus Other New Features - 2020 Update

via IFTTT Take your knowledge of Google Classroom further by learning about the grading options and settings in Google Classroom, as well as several other fairly new features. This follow up video to my Google Classroom Full Tutorial https://youtu.be/M6L-nZGIUTE covers all of the new features that I didn't cover in that first video. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #googleclassroom #googleclassroomgrading #googletools https://youtu.be/D5Sv39JgBdY

Using the Camera Tool in Excel

via IFTTT Learn how to use the camera tool in Excel to pull data together from multiple places in your spreadsheet, or even from a totally different spreadsheet, and then display that data together. The amazing part is that when the underlying data is updated, the camera snapshots also update. #exceltutorial Watch all of my Excel tutorials here: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's the practice file that goes with the video: http://bit.ly/cameraexcel #excel #exceltutorial #excelcamera https://youtu.be/kKygT17SIzs

Exporting Excel Files to PDFs

via IFTTT Learn how to export Excel spreadsheets into PDF format so that they're accessible to anyone you want to send them to. This is great for emailing Excel reports to clients, business partners, student and their parents, etc. #exceltutorial My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Practice file that goes with this video: http://bit.ly/exportingtopdf https://youtu.be/bou04_4MZ3I