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