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

 Want to learn all the essentials of Excel in 1 video? Mark your calendar for Monday, August 22nd, and watch the premiere!

https://youtu.be/wbJcJCkBcMg #exceltutorial #Microsoft365 #Excel #edtech #ISTE #Microsoft #microsoftexcel

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

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

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

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

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

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