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