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