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

Benefits of Naming Cells in Excel

via IFTTT Learn how to name cells and ranges in Excel. You'll also learn some of the benefits that come from naming important cells and ranges. #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 Here's a practice file that goes with the video: http://bit.ly/namingcells https://youtu.be/wCtQ_Jv70os

Lightning Fast Excel Charts

via IFTTT Learn the quickest and easiest way to create a chart in Excel. With just two steps you'll have a chart in your spreadsheet! You'll also learn how to then customize the chart if needed. 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/lightningexcelcharts https://youtu.be/E9nxO4YIrGI

The Beginner's Guide to Microsoft To Do

via IFTTT Learn how to use Microsoft To Do to track your progress on important projects as well as daily and weekly tasks. Microsoft To Do provides you with a full-featured to-do list, complete with notes, reminders, attachments, and the ability to share lists with others. To Do is an especially good option for former users of Wunderlist. #microsoft #todolist ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/6BfVtLD6iT0

Excel's AutoFill Handle in Depth

via IFTTT Learn all of the amazing time saving wonders that the AutoFill Handle can perform in Excel. You can use it to quickly copy to multiple cells, or extend a pattern or number sequence into multiple cells, and more! My playlist of all of my Excel tutorials: http://bit.ly/tech4excel #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's the practice file for this video: http://bit.ly/autofillexcel https://youtu.be/YKBNNlzPFHs

Password Protecting Your Excel Files

via IFTTT Learn a couple of different ways to password protect your Excel data, including a way to password protect the entire file so that no one can open it without the password. Keep your data private and secure. Here's 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 a link to the practice file that goes with the video: http://bit.ly/protectingexcel https://youtu.be/fiLFqoCWLVY

Fixing Common Excel Errors - Part 3: REF and VALUE

via IFTTT Learn strategies for fixing two of the most common Excel error messages: REF! and VALUE! These errors are annoying and make your spreadsheets look terrible. This video will show ways to fix them. This is Part 3 in a three part series on fixing Excel errors. Here's the practice file for the video: http://bit.ly/excelerrors3 Here's a link to Part 1: https://youtu.be/XxEkWwXs-HQ My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/mmV3b3VObio

Fixing Common Excel Errors - Part 2

via IFTTT Learn strategies for fixing three of the most common Excel error messages: NUM! and NULL! and #####. These errors are annoying and make your spreadsheets look terrible. This video will show ways to fix them. This is Part 2 in a three part series on fixing Excel errors. Here's the practice file for the video: http://bit.ly/excelerrors2 Here's a link to Part 1: https://youtu.be/XxEkWwXs-HQ My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/N-lUU2WI14w

Play a Video Across Multiple PowerPoint Slides

via IFTTT Learn how to insert a video into a PowerPoint presentation and then play that one video across multiple PowerPoint slides. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See below for recommendations on presenter remotes: 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 Doosl Wireless Presenter (Economy model remote with great reviews): http://amzn.to/2vYrvzl Here's my entire playlist of PowerPoint tutorials: http://bit.ly/2PaOmRZ Here's a practice file that goes with the video: http://bit.ly/videoacross ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/9JKQvYHYLwg

Fixing Common Excel Errors - Part 1

via IFTTT Learn strategies for fixing three of the most common Excel error messages: #DIV/0! and #N/A! and #NAME?. These errors are annoying and make your spreadsheets look terrible. This video will show ways to fix them. This is Part 1 in a three part series on fixing Excel errors. Here's the practice file for the video: http://bit.ly/fixingexcelpart1 My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/XxEkWwXs-HQ