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

Creating Easy Data Entry Forms in Excel

via IFTTT Learn how to easily create and access data entry forms in Excel that will help you more accurately and quickly enter data. It takes just a few easy steps to create the form, and then you just need to understand the forms features, and you're all set to use your new data entry form. 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 https://youtu.be/5soiJ5rsqKc

Quickly Enter Current Date and Time in Excel

via IFTTT Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn how to quickly enter the current date and time into an Excel spreadsheet. You'll learn a couple of very helpful keyboard shortcuts that can save you lots of time and hassle. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/kHEFEyZV5sk

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

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