Automatically Color Code Specific Words in Excel

Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join

Use the LEN and SUBSTITUTE Functions to Make an Excel Formula for Word Count

Learn how to create an Excel formula that will perform a word count for you. By using the LEN function and the SUBSTITUTE function, you can make a formula that will let you know how many words are in a particular cell or range of cells. Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/1cUZVo3 Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelwordcount #excel #exceltutorials #microsoft365 #microsoftexcel

Moving a Range of Cells in Excel

Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join

News Flash about Technology for Teachers and Students Channel Memberships

Please consider becoming a channel member! This video announces the membership options for this channel and explains what each tier gets. Join this channel to get access to the perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join

The Excel Page Layout Tab and Ribbon in Depth

Learn the Excel Page Layout Tab and Ribbon tools and options inside and out in this crucial video. This video is one in a series of videos that will explore every part of each of the Excel tabs and ribbons. Table of Contents: 00:00 - Intro 00:10 - Themes Group 02:17 - Page Setup Group 08:51 - Scale to Fit Group 10:14 - Sheet Options Group 11:43 - Arrange Group ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/IQr56SL Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelpagelayout #excel #exceltutorials #microsoft365 #microsoftexcel +++Join this channel to get access to perks+++: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join

Creating Meeting Agendas in Microsoft Word

Learn how to use Microsoft Word to create an attractive and effective agenda for your next meeting. This is just as applicable to the classroom and school as it is to the boardroom. You’ll learn not only how to quickly create the agenda, but also a few different ideas for how to share it with the meeting participants. Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/dlISe8g Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. #msword #microsoftword #microsoft365 #microsoft

Members Only Behind the Scenes Podcast - Episode 1

In this first episode of the podcast, I share the story of how the Technology for Teachers and Students YouTube channel began. This episode and podcast are for channel members only.

Powerful Google Chrome Tips and Tricks

Using Undo and Redo in Excel

Learn everything you need to know about undo and redo in Microsoft Excel. Even long-time Excel users will likely learn something new in this insightful undo redo video! :) Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/9JdYzIZ Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelundo #excel #exceltutorials #microsoft365 #microsoftexcel

The Excel Insert Tab and Ribbon in Depth

Learn the Insert Tab and Ribbon in Excel, in depth.The Insert Tab is a powerful tool that allows you to add various elements and objects to your spreadsheets. Whether you need to insert tables, charts, pictures, or other objects, the Insert tab has you covered. +++Join this channel to get access to perks+++: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelpagelayout #excel #exceltutorials #microsoft365 #microsoftexcel ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/9JdYzIZ

How to Print Huge Excel Sheets on Just one Page

Learn how to ensure that your spreadsheet, regardless of how big it is, fits on just one printed page. The data may show up very small on the page, but it will fit. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/JkFL8Sn Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/printonepage #excel #exceltutorials #microsoft365 #microsoftexcel

Quickly Scroll to the Right in Your Excel Spreadsheets

As your Excel spreadsheets get bigger and bigger, with more columns and data, you'll need to know how to quickly move to the right in your spreadsheet. There are a few different ways to scroll toward the right edge of your data. Learn a few of those ways in this short video! ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/EGjSQKm Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelquickly #excel #exceltutorials #microsoft365 #microsoftexcel

The Excel TYPE Function

Learn how to use the Excel TYPE function to return the type of a value, such as text, number, or logical value. It can be useful in a variety of situations, such as when you need to determine the type of data in a cell or when you want to perform different calculations based on the type of data in a range of cells. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/YEKmlbC Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/exceltype #excel #exceltutorials #microsoft365 #microsoftexcel

3 Ways to AutoFit all Columns and Rows in Excel

It's a constant struggle in Excel to keep columns and rows at the correct width and height in order to show all the important data in your spreadsheet. This video shows three ways to automatically fit your column widths and row heights to the data in your spreadsheet. One of the methods enables you to keep your hands on your keyboard as you work, helping you be a more efficient and effective Excel user. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/rg2oWO3 Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here is the practice file for this video: https://bit.ly/excelautofit #excel #exceltutorials #microsoft365 #microsoftexcel

Inserting Screenshots and Screen Clippings in Excel

Learn how to quickly and easily take a screenshot or screen clipping right from within Excel. Then, customize the screenshot or clipping. This video shows how. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/nO7BIUJ Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. #excel #exceltutorials #microsoft365 #microsoftexcel

How to Create a Book or Booklet in Microsoft Word

Learn how to set up Microsoft Word properly so you can write and produce books and booklets. There are several key settings you need to change and a few factors to consider. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/SvtGKTB Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. #microsoftword #msword #microsoft365 #microsoft

How to Reveal Formulas in Excel

Learn how to reveal formulas in Excel. By default, Excel displays the results of formulas, not the formulas themselves. This video shows how to reveal those formulas. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/3KAnkO1 Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/revealexcel #excel #exceltutorials #microsoft365 #microsoftexcel

Using the PowerPoint Morph Transition

Learn how to use the powerful Morph transition in Microsoft PowerPoint. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/xvsyzda Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/powerpointmorph #microsoft365 #excel #exceltutorials #microsoft365 #microsoftexcel

The Excel Home Tab & Ribbon in Depth

Learn the Excel Home Tab and Ribbon tools and options inside and out in this crucial video. This video is one in a series of videos that will explore every part of each of the Excel tabs and ribbons. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/AVNX2R7 Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelhometab #excel #exceltutorials #microsoft365 #microsoftexcel #excelribbon #exceltabs #excelhometab #excelhomeribbon #usingexcelribbon Table of Contents: 00:00 - INTRO 01:23 - The Clipboard Group 07:13 - The Font Group 13:18 - The Alignment Group 17:07 - The Number Group 20:34 - The Styles Group 24:14 - The Cells Group 28:40 - The Editing Group 37:52 - The Analysis Group 39:25 - The Sensitivity Group

3 Ways to Fit Excel Data within a Cell

When using Excel, there are times when you absolutely need all of the contents of a cell or column to be visible. By default, if there is a lot of information in a cell, Excel only shows you the first part of it, and the rest is either hidden or “spills” over into the next cell or cells. If there’s a large number in the cell, then it may show up as a series of hash symbols ####. There are three excellent methods for making sure all of the contents of a cell is visible. This video will demonstrate them for you. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/Ip8kXmo Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: ZZZZZZZZ #excel #exceltutorials #microsoft365 #microsoftexcel

Quick Tricks for Selecting Text in Microsoft Word

When using Microsoft Word, the more you can keep your hands on the keyboard the better. Yet you’ll definitely need to highlight text, and copy and paste it, etc. In this video, you’ll learn several quick tricks and tips that will help you select exactly the text you need to, and in the most efficient ways. This video is a must for all writing professionals and for students, and for anyone who often uses Microsoft Word. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/o4p2LbS Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/mswordselecttricks #msword #microsoftword #microsoft365 #mswordtutorial Books mentioned in the video: The Shannara Trilogy, by Terry Brooks: https://amzn.to/3P2iwpV Dragon Wing - The Deathgate Cycle, by Margaret Weis and Tracy Hickman: https://amzn.to/44LDPSM

Sorting by Custom Lists in Excel

Most Excel users know how to sort Excel data alphabetically or from lowest to highest (or highest to lowest) number. By watching this video, you'll learn how to sort based on your own custom logic. You get to customize the sort any way you want! ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/5Qwk2Xs Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/customsort #excel #exceltutorials #microsoft365 #microsoftexcel

Quickly Cycle Between Excel Workbooks

Learn how to very quickly cycle between multiple Excel workbooks. This little tip will save you time and hassle, and will help keep your hands on the keyboard while working in Excel. If you tend to open and work with more than one spreadsheet or workbook at the same time, this video is a MUST for you! ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/tqPO4lr Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. #excel #exceltutorials #microsoft365 #microsoftexcel

How to Calculate Range in Excel

Learn how to use Excel formulas and functions to calculate the statistical range of a dataset. /t4t

Excel Basics - Entering Cell Data

Learn all the essential information about entering data into cells in Excel. This video will help give you the foundation you need to succeed in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/7lKrsL3 Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. #excel #exceltutorials #microsoft365 #microsoftexcel

Quickly Select a Large Dataset in Excel

Learn how to very quickly select a big range of data in Excel. This quick tip will come in handy for you again and again. ***Support Technology for Teachers and Students on Patreon***: https://ift.tt/O7eM0on Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: https://bit.ly/excelquickselect #excel #exceltutorials #microsoft365 #excelbasics

Use the FORMULATEXT Function to Show Off Your Formulas FINAL

Learn how to reveal your Excel formulas by using the FORMULATEXT function. ***Support Technology for Teachers and Students on Patreon***: https://ift.tt/3HcUvqx Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: https://bit.ly/formulatext #excel #exceltutorials #microsoft365 #excelbasics

Excel Basics - The Anatomy of a Spreadsheet

Before you try learning Excel, you must understand the unique nature of spreadsheets and become familiar with the layout of Microsoft Excel. This video will get you up to speed very quickly and set you up for success in your journey to learn Excel. ***Support Technology for Teachers and Students on Patreon***: https://ift.tt/TqSR7fK Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. #excel #exceltutorials #microsoft365 #excelbasics

Excel VSTACK and HSTACK Functions

Learn how to use the powerful VSTACK and HSTACK functions in Excel to rearrange your data. ***Support Technology for Teachers and Students on Patreon***: https://ift.tt/vany7D6 Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: https://bit.ly/vstack #excel #exceltutorials #microsoft365

Using the Excel SUBTOTAL Function

Learn how to use the very helpful SUBTOTAL function in Excel to quickly get the sum, average, etc. of a range of information. One nice advantage of using the SUBTOTAL function is that it only includes data that is visible (not filtered out, etc.). SUBTOTAL will come in handy for you as you work in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/JkB8teH Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here's the practice file that goes with this video: https://bit.ly/excelsubtotalfunction #excel #exceltutorials #microsoft365 #microsoftexcel

Wakelet Tutorial - Best Social Bookmarking Tool

Learn how to use Wakelet to bookmark all your favorite websites, videos, articles, online tools, and so much more. Watch to the end of the video to learn how to then share your Wakelet lists with others. Wakelet is a great tool for students, teachers, families, businesses, and more. ***Support Technology for Teachers and Students on Patreon***: https://ift.tt/9lTWnQx Consider saying "Thanks" by clicking the Thanks button below the video. #wakelet #socialmedia #socialbookmarking #edtech #iste23 #iste

Convert Photos into Data in Excel

Learn how to import a photo that you've taken, or a screenshot, and then use Excel to convert it into real, usable spreadsheet data. See this amazing feature in action! ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/iKJuA1s Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. #excel #exceltutorials #microsoft365

Collapse and Expand the Ribbon in Microsoft Excel, Word and PowerPoint

Learn three different ways to quickly collapse and then expand the ribbon in Microsoft Excel, Microsoft Word, and PowerPoint. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/3Vwpy0J Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. #excel #exceltutorials #microsoft365 #microsoftexcel #microsoftword #powerpoint

The Excel TRUNC Function

Learn how to use the Excel TRUNC function to truncate numbers in Excel. Use TRUNC to remote the fractional part of a number. But, it's a bit more complicated than that. Learn all about the TRUNC function in this short video. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/8eKanSw Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here's the practice file that goes with this video: https://bit.ly/exceltrunc #excel #exceltutorials #microsoft365 #microsoftexcel

Using the Excel RANDARRAY Function

Learn how to quickly generate a whole array, or range, of random numbers in Excel by using the RANDARRAY function. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/CSUqIJk Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. #excel #exceltutorials #microsoft365 #microsoftexcel

The Excel INT Function

Learn how to use the Excel INT function to round a number down to the nearest integer. The INT function will come in handy as you continue to use Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/Qhpa802 Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here is the practice file for this video: https://bit.ly/excelintfunction #excel #exceltutorials #microsoft365 #microsoftexcel

Fastest Excel Currency and Accounting Formats

Learn the quickest way to change your Excel formatting to currency or accounting format. These shortcuts will increase your efficiency in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/GEZFkJ8 Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/fastcurrency #excel #exceltutorials #microsoft365 #microsoftexcel

Highlighting Blank Cells in Excel

Learn how to quickly highlight all blank cells in Microsoft Excel. It can be easy to miss important data in Excel. Knowing these techniques will help you never miss important gaps in your spreadsheets. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/t0kQ43W Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelhighlight #excel #exceltutorials #microsoft365 #microsoftexcel

Using the Excel LARGE and SMALL Functions

via IFTTT Learn how to use the LARGE and SMALL Excel functions to create useful formulas that help you to rank data by finding the 1st, 2nd, 5th, 50th, etc. largest number and smallest number. These two functions can do more for you than MAX and MIN. ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/E0l72Ty my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/largesmallexcel #excel #exceltutorials #microsoft365 #microsoftexcel

Channel Art

 This post is simply a record of my current channel art. I'm sure it will eventually change as the years go by, and I'd like a record of that.

The above image is used mostly in merch.

The above image is used on video thumbnails and merch.

The above image has been used on some social media.

The above image is my channel banner.

How to Customize Bullet Points in Google Docs and Google Slides

via IFTTT Add some flair and bling to your Google Docs and Google Slides by customizing the bullet points you use. Turn them into emojis, dice, sunbursts, or airplanes. Whatever you can think of! Learn how in this video. Here's a link to my Google Drive playlist for more Google tutorials: https://youtube.com/playlist?list=PL_iwD7O7FG7hzRQzLrwTXgEPtn2BVCSHS ***Consider supporting Technology for Teachers and Students on Patreon***: https://ift.tt/OoT9lNd and please click the THANKS button below the video. #googledocstutorial #google #googletutorial #googledoc #googledrive #googledrivetutorial #gsuite #gsuiteforeducation #googleworkspace #googleworkspacecertification #googlecertification #googleslides #googleslidespresentation #googleslidestutorial #googledocs