Technology for Teachers and Students
Technology for Teachers and Students
  • 525
  • 142 563 399
Set Up Custom Sheet Views in Excel
Learn how to set up custom Sheet Views in Microsoft Excel! By using this feature, you can set up multiple sort and filter views that you can switch between easily. This is especially great for when you share a workbook with other people. Each one can have a custom sheet view.
Join this channel to get access to perks:
czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin
***Consider supporting Technology for Teachers and Students on Patreon***: www.patreon.com/technologyforteachersandstudents 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: bit.ly/sheetviews #excel #exceltutorials #microsoft365 #microsoftexcel
zhlédnutí: 2 776

Video

How to Quickly Close All Excel Workbooks
zhlédnutí 2,1KPřed 14 hodinami
If you use Excel a lot, you may end up with multiple workbooks open at the same time. Learn how to quickly close all of them when you're done working. Learn a handy Excel shortcut that closes all Excel workbooks at once. You’ll use this useful tip over and over. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teach...
The Excel Review Tab and Ribbon in Depth
zhlédnutí 2,8KPřed dnem
Learn the Excel Review Tab in depth! You'll master how to use the spell check tool, accessibility, comments, language settings, and much more. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutori...
The Excel CHOOSE Function
zhlédnutí 4,1KPřed 14 dny
Learn how to use the powerful Excel CHOOSE function to make it easy for the spreadsheet user to select one of several options, and then display the corresponding data. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire...
How to Store Excel Numbers as Text
zhlédnutí 3,8KPřed 21 dnem
When you use Excel, there are times when you enter a number into your spreadsheet, but you need the number to be treated as text and NOT as a number. This video shows you how to do that. You'll also learn additional related tips as a bonus. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Pa...
Essential Google Sheets Math Functions
zhlédnutí 3,7KPřed měsícem
Learn how to use all of the most essential math functions in Google Sheets. This video will hold your hand through it all! Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutorials: HTTP://bit.ly/t...
Creating and Using Action Buttons in PowerPoint
zhlédnutí 3,3KPřed měsícem
Learn how to create and set up Action Buttons in Microsoft PowerPoint! These powerful tools can add new dimensions to your slideshows and make them stand out. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire PowerPoi...
Adobe Express AI Art Generation and Generative Fill
zhlédnutí 2,4KPřed měsícem
Learn how to use Adobe Express to create artificial intelligence AI Images and then make edits to them. You can also use Generative Fill to magically add or subtract elements to/from your images. This call all be done on a completely free Adobe Express account. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teache...
Using the Excel PERCENTILE Functions
zhlédnutí 5KPřed měsícem
Learn to use the Excel PERCENTILE function to quickly calculate percentiles. This function is very useful for teachers trying to figure out what percentile test scores fall into, for businesses calculating the percentiles for their sales force, etc. You'll ask learn to use PERCENTILE.EXC and PERCENTILE.INC Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.html...
The Beginner’s Guide to Adobe Character Animator STARTER Version
zhlédnutí 1,6KPřed měsícem
Learn how to create your own almost instant character animations by using Adobe Character Animator! This video focusses on the Starter mode in Character Animator, which simplifies the process significantly and gives you great gesture features. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on...
Using the PowerPoint Animation Painter
zhlédnutí 3KPřed měsícem
Learn how to wield the power of PowerPoint Animation Painter like a pro! Discover how to seamlessly transfer animation effects from one object to another with just a few clicks, revolutionizing your presentation game. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com...
The Amazing Read Aloud Tool in Microsoft Word
zhlédnutí 2,9KPřed měsícem
Learn how to use the Microsoft Word "Read Aloud Tool." It's a powerful feature that should be used more. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Microsoft Word tutorials: bit.ly/2FY6NVT Please sa...
Problem Solving when Trying to Share Google Docs, Sheets, Slides or Sites
zhlédnutí 3KPřed měsícem
This video goes in depth on how to share your Google Drive documents, sheets, slides or even sites with other people so that they can actually see them or even collaborate with you on those files. Almost everyone has had the experience of either sending or receiving a link or invitation to a Google Drive file, only to find that it's not accessible to them. This video will help you to solve that...
Create FREE Character Animations with Adobe Animate from Audio
zhlédnutí 4,1KPřed měsícem
Learn how to create your own character animations online and for FREE. Adobe Express has a little-known feature called Animate from Audio, and it's fantastic. This video will teach you everything you need to know to start using this amazing and fun tool. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and ...
Three Ways to Click and Drag Excel Ranges
zhlédnutí 6KPřed 2 měsíci
Learn three different ways to click and drag Excel ranges. If you need to move part of your Excel data, cutting and pasting may not be the best method for doing so. Watch this video to learn other, more convenient and easier methods. Join this channel to get access to perks: czcams.com/channels/YUPLUCkMiUgiyVuluCc7tQ.htmljoin Consider supporting Technology for Teachers and Students on Patreon :...
How to Change Color of Excel Gridlines or Remove Them
zhlédnutí 6KPřed 2 měsíci
How to Change Color of Excel Gridlines or Remove Them
How to Sort Excel Data By Color
zhlédnutí 7KPřed 2 měsíci
How to Sort Excel Data By Color
The Microsoft Word Design Tab and Ribbon in Depth
zhlédnutí 4,9KPřed 2 měsíci
The Microsoft Word Design Tab and Ribbon in Depth
Moving a Range of Cells in Excel
zhlédnutí 3,8KPřed 2 měsíci
Moving a Range of Cells in Excel
Creating Your Own Custom Tabs and Ribbon in Microsoft Word
zhlédnutí 3,3KPřed 3 měsíci
Creating Your Own Custom Tabs and Ribbon in Microsoft Word
The Excel TOCOL and TOROW Functions
zhlédnutí 10KPřed 3 měsíci
The Excel TOCOL and TOROW Functions
ScreenPal Screen Recorder Tutorial
zhlédnutí 3,6KPřed 3 měsíci
ScreenPal Screen Recorder Tutorial
The Excel TEXTSPLIT TEXTBEFORE and TEXTAFTER Functions
zhlédnutí 6KPřed 3 měsíci
The Excel TEXTSPLIT TEXTBEFORE and TEXTAFTER Functions
The Microsoft Word Home Tab and Ribbon In Depth
zhlédnutí 15KPřed 3 měsíci
The Microsoft Word Home Tab and Ribbon In Depth
How to Combine Multiple Excel Workbooks into One
zhlédnutí 17KPřed 4 měsíci
How to Combine Multiple Excel Workbooks into One
The Excel TAKE and DROP Functions
zhlédnutí 6KPřed 4 měsíci
The Excel TAKE and DROP Functions
How to Quickly Jump Back to Recent Edits in Microsoft Word
zhlédnutí 3,9KPřed 4 měsíci
How to Quickly Jump Back to Recent Edits in Microsoft Word
Use ChatGPT and Artificial Intelligence to Unlock the Hidden Power of Excel
zhlédnutí 11KPřed 4 měsíci
Use ChatGPT and Artificial Intelligence to Unlock the Hidden Power of Excel
The Excel COUNTIF and COUNTIFS Functions
zhlédnutí 82KPřed 4 měsíci
The Excel COUNTIF and COUNTIFS Functions
Powerful Google Chrome Tips and Tricks
zhlédnutí 9KPřed 4 měsíci
Powerful Google Chrome Tips and Tricks

Komentáře

  • @immortal_yoga_studio
    @immortal_yoga_studio Před 45 minutami

    I have google Earth 🌎🌍

  • @user-bb3ir2wl9e
    @user-bb3ir2wl9e Před hodinou

    My God!... Thank you so much, I have been crazy editing the template now I found you... this lesson I got it! thanks... mwah! I will follow you now.

  • @abdirahmanjeesaaw368
    @abdirahmanjeesaaw368 Před 3 hodinami

    Your series lessons

  • @Lynhdaaa
    @Lynhdaaa Před 8 hodinami

    Love your videos! easy to follow

  • @palmerrr
    @palmerrr Před 9 hodinami

    VIVA CHILE!!!

  • @Lynhdaaa
    @Lynhdaaa Před 10 hodinami

    GREAT VIDEO! THANK YOU.

  • @agustinvidalmusic
    @agustinvidalmusic Před 14 hodinami

    Does the map refresh when the spreadsheet is edited?

  • @lawrencekazibwe9751
    @lawrencekazibwe9751 Před 15 hodinami

    Thanks alot,Boss.It's been very informative 🎉

  • @mariarodrigues5482
    @mariarodrigues5482 Před 16 hodinami

    Thank you so much, God bless you.

  • @kaushik6804
    @kaushik6804 Před 18 hodinami

    This is so much helpful for beginners great work!!!

  • @dardaus.danmusa7623
    @dardaus.danmusa7623 Před 19 hodinami

    thank you so much for this video

  • @feleciabrown9199
    @feleciabrown9199 Před 19 hodinami

    Thank you. This PowerPoint class is very informative ❤

  • @renfroela
    @renfroela Před 21 hodinou

    this is GREAT THank you

  • @tarakimlayman
    @tarakimlayman Před 23 hodinami

    I followed the steps I get no numbers with page indicator the references jumps to the table of contents and contents lists under references. Frustrating

  • @mrsk2720
    @mrsk2720 Před 23 hodinami

    Thank you!

  • @pamelayuwun9770
    @pamelayuwun9770 Před dnem

    I just Got schooled thank you Sir

  • @carrie4579
    @carrie4579 Před dnem

    Great video. I have a question: how to add online pics under insert ribbon?

  • @user-yu1fo6gm9x
    @user-yu1fo6gm9x Před dnem

    Thanks! Very helpful. I have 800 pictures that need to be shown at a party and this is perfect!

  • @lilyvoo2463
    @lilyvoo2463 Před dnem

    Old timer user of powerpoint, still picking up tips. Thank you!

  • @uzmajawed100
    @uzmajawed100 Před dnem

    Excellent explanation thank you

  • @ajauguste7984
    @ajauguste7984 Před dnem

    I found this video very helpful. Thank you for sharing. Can Transform also put it on Amazon /kindle?

  • @eugenekheyfets5806

    This videos is very helpful, thanks.

  • @user-fe1jd3zf1d
    @user-fe1jd3zf1d Před dnem

    Aapka version Hindi language mein bhi h kya

  • @elijahboyersebastiani

    I love how passionate he is about synth-pop

  • @xavierdes1
    @xavierdes1 Před dnem

    Thanks for explaining and excellent explanation knowledge and good luck guys 🔥💞💝🥰🌸🌺✅⭐️⭐️⭐️⭐️

  • @sjn0202
    @sjn0202 Před dnem

    Good explanation of how to utilize the tool. Obviously, if "the color" is included in what you would like to keep you will need a more advanced technique or program. These days it only takes a minute in Adobe Photoshop. However, I like this instruction. It's well done.

  • @davidMW007
    @davidMW007 Před 2 dny

    None of the text formatting shortcuts outlined at the beginning of this video are working for me. I have Word 365, if that makes a difference. I tried using Ctrl, Option, Cmd - none of them work.

  • @livingcaesarwood
    @livingcaesarwood Před 2 dny

    Which version of Excel are you using? I'm on 2019, I don't see anything about getting data from pictures or even PDFs.

  • @giftynyahe6880
    @giftynyahe6880 Před 2 dny

    Helpful

  • @StephanieLoeb
    @StephanieLoeb Před 2 dny

    What if you wanted to know whose weight is "between 300-329"?

  • @user-ld8mi9fz6l
    @user-ld8mi9fz6l Před 2 dny

  • @EverybodyAuntie
    @EverybodyAuntie Před 2 dny

    I constantly have to come to these to refresh my memory. Saving my ass for this Admin Assistant III position. Also PowerPoint was great!!!

  • @OsasehiDestiny-xs5pq

    Heaven forbid 😂😂😂

  • @AS-ih2dk
    @AS-ih2dk Před 2 dny

    HOW DO YOU REQUEST FILES NOT SEND

  • @LeahHaymaker
    @LeahHaymaker Před 2 dny

    I have read through so many search options and your video was the first one to make sense and actually work. THANK YOU!!!

  • @feleciabrown9199
    @feleciabrown9199 Před 2 dny

    You are an Excellent instructor, your tone of voice, not rushed, easy to follow instructions etc.❤

  • @juandredavidtz9755
    @juandredavidtz9755 Před 2 dny

    How do you save each document as its own file ? PLEASE HELP

  • @Kr_xxx
    @Kr_xxx Před 2 dny

    What’s another way for the charts to appear bcz mine doesn’t appear when I hold ALT+F1

  • @robertduffy5805
    @robertduffy5805 Před 2 dny

    thanks

  • @priscilla5175
    @priscilla5175 Před 2 dny

    Informative needed for beginners 😊

  • @azeezkazeem7573
    @azeezkazeem7573 Před 2 dny

    I have been using excel before but i lerant more in this video, kudos

  • @arulmami6982
    @arulmami6982 Před 2 dny

    Thank you so much more useful in this video

  • @TanujSadasivam
    @TanujSadasivam Před 3 dny

    🎯 Key points for quick navigation: 00:29 *📊 Excel Workbook Creation and Anatomy* - Excel workbooks contain sheets, with each sheet being a spreadsheet. - Spreadsheets are made up of columns, rows, cells, and ranges. - Each cell in Excel can be identified by the intersection of its column and row. 04:06 *🖥️ Excel Layout Overview* - Excel has tabs at the top for different functions like Home, Insert, and Data. - Each tab has a ribbon consisting of groups of tools. - In addition to tabs and ribbons, Excel also has scroll bars, a zoom slider, and the formula bar. 07:17 *🔄 Entering Cell Values and Data* - To modify a cell in Excel, it needs to be selected first before entering data. - Using the fill handle is an efficient way to extend patterns in Excel. - Shortcuts like Ctrl+C for copy and Ctrl+V for paste are helpful for data entry tasks. 21:05 *🧮 Excel formula basics* - Excel formulas consist of cell references and operators. 23:48 *🔄 Autofill handle usage* - Excel autofill handle can copy and extend formulas automatically. - Autofill handle adjusts cell references based on relative references. 26:06 *🔒 Using absolute cell references* - Absolute cell references in Excel are indicated by using dollar signs. - Absolute cell references ensure formula consistency when copied to different cells. 30:42 *➕ Excel functions introduction* - Excel functions such as SUM, AVERAGE, MAX, MIN, COUNT are powerful tools. 39:13 *💰 Formatting numbers in Excel* - Excel offers various number formats like Currency and Accounting. - Changing number formats in Excel helps differentiate data categories like money and time. 42:39 *🎨 Formatting in Excel* - Format Painter copies formatting to other cells - Use double-click on Format Painter for consecutive formatting - Add Auto Format tool to Quick Access Toolbar for quick formatting options 44:16 *📊 Creating Basic Charts in Excel* - Easily create charts by selecting data and using Alt + F1 - Modify chart types and elements in Chart Design tab - Utilize Page Break Preview to adjust chart positioning for printing 47:02 *🖨️ Printing and Publishing Options in Excel* - Check data fitting in print preview under the File tab - Adjust orientation and scale settings for printing optimization - Utilize "Save as PDF" feature for easy sharing and publishing options Made with HARPA AI

  • @danielcivil9967
    @danielcivil9967 Před 3 dny

    Thank you very much

  • @kimberlyhaugan9983
    @kimberlyhaugan9983 Před 3 dny

    This is a great refresher

  • @ouahibabela8986
    @ouahibabela8986 Před 3 dny

    thanks a lot for your continued support and interesting what you are sharing with us. thanks again.

  • @AnifuddinAfg
    @AnifuddinAfg Před 3 dny

    how to showing again google sheet template?, because in my google sheet i don't find option turn on.

  • @CallOSaulTitan
    @CallOSaulTitan Před 3 dny

    Studying for my Healthcare Finance Training’s assessment exam that has an Excel portion; hope I pass! Will update soon if this video helped me or not!

  • @minhazulislam9131
    @minhazulislam9131 Před 3 dny

    Can you change the voice (Male/Female)? - My type of use case is, I often need to read through large table of information that, I feel very exhausting for my eyes as Excel spreadsheet cells are also small. I like to listen to them using speak cells.

  • @ashleyhouse9690
    @ashleyhouse9690 Před 3 dny

    What's the point in Google My Maps if you can't send a route to a navigation device like Google Maps?