Monday, November 9, 2020

PowerPoint File Extension Tricks


via IFTTT Learn some simple but powerful file extension tricks that can help you use PowerPoint more effectively and efficiently. Here's my entire playlist of PowerPoint tutorials: http://bit.ly/2PaOmRZ ***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 #powerpoint #powerpointtutorial https://youtu.be/zTKMIP94IAU

Monday, November 2, 2020

The Excel Quartile Function


via IFTTT Learn how to use the Excel quartile function to quickly calculate the four quartile numbers of any range of data. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: http://bit.ly/excelquartile #excel #exceltutorial https://youtu.be/nv6Ho9j9RMc

Monday, October 26, 2020

The Excel SUMIFS Function


via IFTTT Learn how to use the SUMIFS function in Excel. This useful function enables you to add up specific cells based on criteria that you specify. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: http://bit.ly/excelSUMIFS #excel #exceltutorial #advancedexcel https://youtu.be/jPajIyavh_0

Monday, October 19, 2020

Aligning and Arranging Graphics in PowerPoint


via IFTTT Learn how to align and arrange graphics, text, and more in PowerPoint. The arrange options can really save you time and effort as you build PowerPoint presentations. Here's my entire playlist of PowerPoint tutorials: http://bit.ly/2PaOmRZ ***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 the practice file that goes with the video: http://bit.ly/arrangingppt #powerpoint #powerpointtutorial https://youtu.be/ngiFTaCS5BI

Monday, October 12, 2020

The Function Keys in Excel


via IFTTT Learn what each of the Function Keys (the F keys) do in Excel. These are great time-savers that will help you use Excel more efficiently. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: http://bit.ly/excelfunctionkeys Here's more information about the new Killers CD, "Imploding the Mirage": https://amzn.to/3k48N1y #excel #exceltutorial https://youtu.be/-2i8sQvG73M

Monday, October 5, 2020

The Excel FORECAST Function


via IFTTT Learn how to use the Excel FORECAST function to forecast the future, based upon past results. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: http://bit.ly/excelforecast #excel #exceltutorial https://youtu.be/g6KCZOfBONU

Saturday, October 3, 2020

Graphic Organizers in Google Classroom


via IFTTT Learn how to quickly create or import useful graphic organizers for use in Google Classroom. Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #google #googleclassroom List of Sites with Pre-Made Graphic Organizers: https://ift.tt/3jtcyO0 https://ift.tt/2AEqbXh https://ift.tt/3ipNHJG https://ift.tt/2AHiuzC ***Consider supporting Technology for Teachers and Students on Patreon*** https://youtu.be/I5VpC2boHMU

Monday, September 28, 2020

Using Microsoft Translator in Microsoft Word


via IFTTT Learn how to use Microsoft Translator within Microsoft word to conveniently and quickly translate your Word documents into other languages. Watch my entire Microsoft Word playlist here: http://bit.ly/2FY6NVT ***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/translateinword #msword #wordtutorial https://youtu.be/DxNwTzecc7Y

Monday, September 21, 2020

The Excel Status Bar


via IFTTT Learn about all of the useful information and tools that the Excel Status Bar gives you in Excel. This powerful and underused Excel feature will become indispensable to you! ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: http://bit.ly/excelstatus #excel #exceltutorial https://youtu.be/6BWviK7dYSk

Saturday, September 19, 2020

Google Classroom: Providing Effective Feedback


via IFTTT Learn how to use Google Classroom's built-in feedback tools to help you easily provide effective feedback on student work. Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #google #googleclassroom https://youtu.be/44LaDdCS8Ew

Monday, September 14, 2020

Using Excel Hyperlinks


via IFTTT Learn how to use hyperlinks in Excel to quickly jump from one place in your Excel workbook to another. Hyperlinks can also connect to other workbooks, to websites, and more! Find my full Excel playlist here: http://bit.ly/tech4excel . ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's the practice file for the video: http://bit.ly/linksexcel https://youtu.be/giTvvCu9ZvI

Saturday, September 12, 2020

Integrating Google Classroom with Quizlet


via IFTTT Learn how to integrate Quizlet with Google Classroom so your students can easily access Quizlet activities from their Google Classroom. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist #google #googleclassroom https://youtu.be/8SR-zHsktS8

Monday, September 7, 2020

Excel 3D Formulas


via IFTTT Learn how to create a 3D formula in Excel, a formula that pulls data from the same cell in more than one spreadsheet. It can be a little tricky, but after watching this video you'll understand how to do it. This is a new and improved version of a classic video. Find my whole excel playlist here: http://bit.ly/tech4excel . ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here's the practice file for the video: http://bit.ly/3dexcel https://youtu.be/1p3X_DuUvYk

Monday, August 31, 2020

Excel's Large Function and Small Function


via IFTTT Learn how to use the simple but powerful LARGE function and SMALL function in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here's the practice file that goes with the video: http://bit.ly/excellargesmall #excel #exceltutorial https://youtu.be/_Fh7W8jxPFQ

Friday, August 28, 2020

Creating Narrated Slideshows with iMovie


via IFTTT Learn how to use iMovie to create narrated slideshows, complete with images, music, voice recordings, and more. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Here are the images and music used in this video in case you want to download and use it to practice: http://bit.ly/imovieslideshow Please also watch my Beginner's Guide to iMovie: https://youtu.be/nV_1eCZ360M Two great microphones to use with iMovie (I use the Yeti): Blue Yeti USB Microphone - Midnight Blue: https://amzn.to/30X2F0M Samson Meteor Mic USB Studio Microphone (Titanium Black): https://amzn.to/2VoqTQz ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/rzERbKWSx0I

Thursday, August 27, 2020

Google Jamboard Software Tutorial


via IFTTT Learn how to use the free Google Jamboard software to create interactive and collaborative experiences for your students or co-workers. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #google #googleclassroom https://youtu.be/xDkPvDUSfoE

Wednesday, August 26, 2020

Make a Tri-fold Brochure in Word


via IFTTT Learn how to create a tri-fold brochure in Microsoft Word. This makes for a great school project for students, as well as being very useful in many business and professional situations. Watch my entire Microsoft Word playlist here: http://bit.ly/2FY6NVT ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #msword #microsoftword https://youtu.be/fsmh4NMztJI

Tuesday, August 25, 2020

Integrating Google Classroom with EdPuzzle


via IFTTT Learn how to integrate EdPuzzle with Google Classroom so your students can easily access EdPuzzle activities from their Google Classroom. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist #google #googleclassroom https://youtu.be/EyMIvhlgtJk

Monday, August 24, 2020

Using the Excel Data Types Tools


via IFTTT Learn how to use the new Excel Data Types tools to quickly bring in information about geography and stocks. These tools are found in the form of buttons on the Data tab in Microsoft 365 versions of Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here's the practice file that goes with the video: http://bit.ly/exceldatatypes #excel #exceltutorial https://youtu.be/dvN29rufxPA

Wednesday, August 19, 2020

Using Google Meet inside Google Classroom


via IFTTT Learn how to set up and use Google Meet inside of Google Classroom so you and your students can have high-quality video meetings. This excellent option for video conferencing makes it easy to connect with your students and teach them "face to face." ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist #google #googleclassroom https://youtu.be/TSeYZ8nIRgA

Monday, August 17, 2020

The Excel Ideas Button


via IFTTT Learn how the Excel Ideas button can tap into the power of artificial intelligence to help you quickly and easily generate beautiful and powerful visuals for your spreadsheets and workbooks. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here's the practice file that goes with the video: https://bit.ly/ideasbutton #excel #exceltutorial https://youtu.be/fv46KLlco04

Monday, August 10, 2020

Using Hidden Text in Microsoft Word


via IFTTT Learn how to hide text in Microsoft Word, and learn why this is such a useful feature for educators and business people. Watch my entire Microsoft Word playlist here: http://bit.ly/2FY6NVT ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #msword #microsoftword https://youtu.be/dvl9kL-w4SQ

Monday, August 3, 2020

Changing Slide Dimensions in PowerPoint


via IFTTT Learn how to change the default slide sizes or dimensions in PowerPoint so that your presentation looks right on different screens. Here's my entire playlist of PowerPoint tutorials: http://bit.ly/2PaOmRZ ***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 the practice file that goes with the video: https://bit.ly/pptslidedimensions #powerpoint #powerpointtutorial https://youtu.be/vaE7epGvLJ4

Monday, July 27, 2020

Creating Organization Charts in Excel


via IFTTT Learn how to easily create an org chart (or organization chart) in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here's the practice file that goes with the video: https://bit.ly/excelorganization #excel #exceltutorial https://youtu.be/sm4NDobHTMI

Thursday, July 23, 2020

Six Tips for Using Google Classroom


via IFTTT Learn my top 6 tips for using Google Classroom more effectively! You'll see better ways to organize your course content, easy ways to add new assignments and reuse old assignments, how to see a "student view," to-do lists, and more. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist #google #googleclassroom https://youtu.be/omBz4Ci2yqk

Monday, July 20, 2020

The Excel Quick Analysis Tool


via IFTTT Learn how to use the Excel Quick Analysis Tool to quickly add colorful visuals to your spreadsheets. The visuals include colorful conditional formatting, charts, icon sets, pivot tables, sparklines, and more. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here's the practice file that goes with the video: https://bit.ly/excelquick #excel #exceltutorial https://youtu.be/jyP_kIwB5Ss

Saturday, July 18, 2020

Beginner's Guide to Camtasia - 2020 Tutorial


via IFTTT Learn the basics of using Camtasia to create and edit screenrecordings and much more. TechSmith's Camtasia software balances ease of use with powerful features. It's a great option for most people wanting to create YouTube videos, professional quality videos for their business, or even just awesome family videos. But it can be intimidating at first. This tutorial will get you editing high quality videos in just minutes. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe #camtasia Camtasia Education Discount: https://ift.tt/397o8K8 Camtasia without Ed Discount: https://ift.tt/2WOGmeP Link to TechSmith, who produces Camtasia: https://ift.tt/2OI52AR Two great microphones to use with Camtasia (I use the Yeti): Blue Yeti USB Microphone - Midnight Blue: https://amzn.to/30X2F0M Samson Meteor Mic USB Studio Microphone (Titanium Black): https://amzn.to/2VoqTQz ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/0EeSV-LIKtw

Monday, July 13, 2020

Inserting Excel Data into Microsoft Word


via IFTTT Learn the best ways to bring data and charts from Excel into Microsoft Word. This is very helpful when creating reports and handouts for presentations, board meetings, and other business meetings. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here's the practice file that goes with the video: https://bit.ly/exceltoword Here's my entire playlist of Word tutorials: http://bit.ly/2FY6NVT #excel #exceltutorial #msword https://youtu.be/SX40N9JdSFc

Monday, July 6, 2020

Customize the Excel AutoFill Handle


via IFTTT Learn how to customize the Excel AutoFill Handle so that it produces custom series or patterns in your spreadsheets. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel #excel #exceltutorial https://youtu.be/7gEyabXWQuk

Monday, June 29, 2020

Create Text Shortcuts in Excel Word and PowerPoint


via IFTTT Learn how to create text shortcuts that will make it easier and faster for you to type long or difficult phrases. If you use Excel a lot, this video will save you loads of time! ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel #excel #exceltutorial #msword #powerpoint https://youtu.be/RRTxJpFHrb4

Monday, June 22, 2020

Enter the Same Data in Multiple Excel Cells


via IFTTT Learn how to simultaneously enter the same data into many different cells in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: https://bit.ly/multiplecells #excel #exceltutorial https://youtu.be/9cjQHoO3qaw

Wednesday, June 17, 2020

Creating Multiple Custom PowerPoint Shows


via IFTTT Learn how to create multiple versions of the same presentation and save them all within just one PowerPoint file. This is especially useful if you'll be using the same presentation with different audiences; you could tailor and customize the presentation based upon the current audience. Here's my entire playlist of PowerPoint tutorials: http://bit.ly/2PaOmRZ ***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 the practice file that goes with the video: http://bit.ly/customppt https://youtu.be/sUraWNKMx5I

Monday, June 15, 2020

Intermediate Guide to Excel Get & Transform / Power Query


via IFTTT Learn how to use Excel's Get & Transform (also known as Power Query) features to import data from the Web and then clean up the data, fix import errors, etc. This powerful feature in Excel is under-used and not well understood, until now. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: https://bit.ly/gettransform2 You'll find the Beginner's Guide here: https://youtu.be/yE8sLnywPAg #excel #exceltutorial https://youtu.be/VTKfG4AfUtA

Thursday, June 11, 2020

Automatically Advance Slides and Record Narration in PowerPoint


via IFTTT Learn how to time your PowerPoint slides so that they automatically advance. You'll also learn how to record your voice and add it as narration for the presentation. Here's my entire playlist of PowerPoint tutorials: http://bit.ly/2PaOmRZ ***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 the practice file that goes with the video: https://bit.ly/advancenarrate Great options for microphones for voice recordings: 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 #powerpoint #powerpointtutorial https://youtu.be/cllW-ybFQDg

Monday, June 8, 2020

Beginner's Guide to Excel Get & Transform / Power Query


via IFTTT This video will show you the basics of Excel "Get & Transform" (also know as Power Query) so you can get started using it. Get & Transform can help you clean up irregular data in Excel, and this video shows you how to do so. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here is the practice file that goes with this video: https://bit.ly/gettransform1 You'll find the Intermediate Guide here: https://youtu.be/VTKfG4AfUtA #excel #exceltutorial https://youtu.be/yE8sLnywPAg

Saturday, June 6, 2020

Conducting Student Surveys in Google Classroom


via IFTTT Learn how to use Google Classroom to create and deploy a survey for your students to answer. Google Classroom integrates very well with Google Forms, making it very easy for you to collect important information from your students. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist #google #googleclassroom https://youtu.be/d6sT_eY2ubE

Monday, June 1, 2020

Mail Merge from Excel to Microsoft Word


via IFTTT Learn how to perform a mail merge from Microsoft Excel to Microsoft Word in order to produce mass mailings to a group of people. If you ever need to send form letters, this video will save you a lot of time and will teach you everything you need to know. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel Here are the practice files that go with this video: https://bit.ly/mailmergefiles My entire playlist of Word videos: http://bit.ly/2FY6NVT #excel #exceltutorial https://youtu.be/mFqCvTOpOL0

Thursday, May 28, 2020

Creating Google Slides Assignments in Google Classroom


via IFTTT Learn how to use Google Classroom to assign your students to create or customize a slideshow presentation. Google Classroom integrates very well with Google Slides (and all of Google Drive for that matter), and you can easily set up a template presentation for your students to customize in order to show mastery. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe Please watch all of my Google Classroom videos here: https://bit.ly/googleclassroomlist #google #googleclassroom https://youtu.be/QDRlBwcnivw

Monday, May 25, 2020

Automatically Open Several Excel Files


via IFTTT Learn how to set up Excel so that when you start Excel, one or more Excel files automatically open up. This trick is a real time saver, especially if you use Excel a lot and if you use more than one Excel workbook at a time. #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel #excel https://youtu.be/wOcmWm2A8Is

Monday, May 18, 2020

Generating Random Numbers in Excel


via IFTTT Learn how to quickly and easily create a list of random numbers in Microsoft Excel. You'll see two different methods: one that generates a random decimal between 0 and 1, and one that generates a random number between any two whole numbers that you specify. #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe See my entire playlist of Excel videos: http://bit.ly/tech4excel https://youtu.be/cXXdZ9PimGU

Friday, May 15, 2020

Creating Drawing Assignments in Google Classroom


via IFTTT Learn how to create a drawing activity or assignment in Google Classroom so students can draw in order to show mastery of a concept, and then they can easily turn in their drawing for evaluation. Google Drawings integrates very well into Google Classroom. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/2HXqSfe https://youtu.be/8e7S0hnm5Ug

Monday, May 11, 2020

Beginner's Guide to Excel Functions and Formulas


via IFTTT Learn or review the basic Excel functions that everyone needs to know: SUM, AVERAGE, MAX, MIN, COUNT, and COUNTA. ***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/functionsinexcel #excel #exceltutorial https://youtu.be/7V4xF3zCSoI

Monday, May 4, 2020

Creating Pie Charts in Excel


via IFTTT Learn how and when to create pie charts in your Excel spreadsheets. Pie charts are a popular way to illustrate key data in Excel, and they're not as hard to create as you might think. ***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/excelpie #excel #exceltutorial https://youtu.be/FPUN8avV8Qs

Monday, April 27, 2020

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

Thursday, April 23, 2020

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

Monday, April 20, 2020

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

Friday, April 17, 2020

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

Tuesday, April 14, 2020

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

Monday, April 13, 2020

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

Saturday, April 11, 2020

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

Thursday, April 9, 2020

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

Monday, April 6, 2020

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

Monday, March 30, 2020

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

Wednesday, March 25, 2020

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

Monday, March 23, 2020

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

Friday, March 20, 2020

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

Wednesday, March 18, 2020

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

Monday, March 16, 2020

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

Monday, March 9, 2020

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

Sunday, March 1, 2020

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

Wednesday, February 26, 2020

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

Monday, February 24, 2020

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

Monday, February 17, 2020

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

Thursday, February 13, 2020

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

Monday, February 10, 2020

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

Thursday, February 6, 2020

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

Monday, February 3, 2020

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

Monday, January 27, 2020

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

Monday, January 20, 2020

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

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