Technology for Teachers and Students
Technology for Teachers and Students
  • Видео 525
  • Просмотров 142 342 409
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:
ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin
***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 #e...
Просмотров: 2 045

Видео

How to Quickly Close All Excel Workbooks
Просмотров 1,8 тыс.22 часа назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers...
The Excel Review Tab and Ribbon in Depth
Просмотров 2,6 тыс.День назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutorials...
The Excel CHOOSE Function
Просмотров 4 тыс.14 дней назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire pl...
How to Store Excel Numbers as Text
Просмотров 3,7 тыс.21 день назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Patre...
Essential Google Sheets Math Functions
Просмотров 3,6 тыс.28 дней назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech...
Creating and Using Action Buttons in PowerPoint
Просмотров 3,2 тыс.Месяц назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/technologyforteachersandstudents Here's my entire PowerPoint ...
Adobe Express AI Art Generation and Generative Fill
Просмотров 2,2 тыс.Месяц назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers ...
Using the Excel PERCENTILE Functions
Просмотров 4,9 тыс.Месяц назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoi...
The Beginner’s Guide to Adobe Character Animator STARTER Version
Просмотров 1,5 тыс.Месяц назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Pa...
Using the PowerPoint Animation Painter
Просмотров 3 тыс.Месяц назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Patreon : www.patreon.com/te...
The Amazing Read Aloud Tool in Microsoft Word
Просмотров 2,9 тыс.Месяц назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin 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 say "...
Problem Solving when Trying to Share Google Docs, Sheets, Slides or Sites
Просмотров 2,9 тыс.Месяц назад
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
Просмотров 3,9 тыс.Месяц назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Stu...
Three Ways to Click and Drag Excel Ranges
Просмотров 6 тыс.2 месяца назад
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: ruclips.net/channel/UCYUPLUCkMiUgiyVuluCc7tQjoin Consider supporting Technology for Teachers and Students on Patreon : ww...
How to Change Color of Excel Gridlines or Remove Them
Просмотров 6 тыс.2 месяца назад
How to Change Color of Excel Gridlines or Remove Them
How to Sort Excel Data By Color
Просмотров 7 тыс.2 месяца назад
How to Sort Excel Data By Color
The Microsoft Word Design Tab and Ribbon in Depth
Просмотров 4,8 тыс.2 месяца назад
The Microsoft Word Design Tab and Ribbon in Depth
Moving a Range of Cells in Excel
Просмотров 3,7 тыс.2 месяца назад
Moving a Range of Cells in Excel
Creating Your Own Custom Tabs and Ribbon in Microsoft Word
Просмотров 3,2 тыс.3 месяца назад
Creating Your Own Custom Tabs and Ribbon in Microsoft Word
The Excel TOCOL and TOROW Functions
Просмотров 9 тыс.3 месяца назад
The Excel TOCOL and TOROW Functions
ScreenPal Screen Recorder Tutorial
Просмотров 3,5 тыс.3 месяца назад
ScreenPal Screen Recorder Tutorial
The Excel TEXTSPLIT TEXTBEFORE and TEXTAFTER Functions
Просмотров 6 тыс.3 месяца назад
The Excel TEXTSPLIT TEXTBEFORE and TEXTAFTER Functions
The Microsoft Word Home Tab and Ribbon In Depth
Просмотров 15 тыс.3 месяца назад
The Microsoft Word Home Tab and Ribbon In Depth
How to Combine Multiple Excel Workbooks into One
Просмотров 17 тыс.3 месяца назад
How to Combine Multiple Excel Workbooks into One
The Excel TAKE and DROP Functions
Просмотров 6 тыс.4 месяца назад
The Excel TAKE and DROP Functions
How to Quickly Jump Back to Recent Edits in Microsoft Word
Просмотров 3,9 тыс.4 месяца назад
How to Quickly Jump Back to Recent Edits in Microsoft Word
Use ChatGPT and Artificial Intelligence to Unlock the Hidden Power of Excel
Просмотров 10 тыс.4 месяца назад
Use ChatGPT and Artificial Intelligence to Unlock the Hidden Power of Excel
The Excel COUNTIF and COUNTIFS Functions
Просмотров 80 тыс.4 месяца назад
The Excel COUNTIF and COUNTIFS Functions
Powerful Google Chrome Tips and Tricks
Просмотров 9 тыс.4 месяца назад
Powerful Google Chrome Tips and Tricks

Комментарии

  • @livingcaesarwood
    @livingcaesarwood 15 часов назад

    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 15 часов назад

    Helpful

  • @StephanieLoeb
    @StephanieLoeb 16 часов назад

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

  • @user-ld8mi9fz6l
    @user-ld8mi9fz6l 16 часов назад

  • @EverybodyAuntie
    @EverybodyAuntie 16 часов назад

    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
    @OsasehiDestiny-xs5pq 16 часов назад

    Heaven forbid 😂😂😂

  • @AS-ih2dk
    @AS-ih2dk 17 часов назад

    HOW DO YOU REQUEST FILES NOT SEND

  • @LeahHaymaker
    @LeahHaymaker 17 часов назад

    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 20 часов назад

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

  • @juandredavidtz9755
    @juandredavidtz9755 21 час назад

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

  • @Kr_xxx
    @Kr_xxx 21 час назад

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

  • @robertduffy5805
    @robertduffy5805 22 часа назад

    thanks

  • @priscilla5175
    @priscilla5175 23 часа назад

    Informative needed for beginners 😊

  • @azeezkazeem7573
    @azeezkazeem7573 День назад

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

  • @arulmami6982
    @arulmami6982 День назад

    Thank you so much more useful in this video

  • @TanujSadasivam
    @TanujSadasivam День назад

    🎯 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 День назад

    Thank you very much

  • @kimberlyhaugan9983
    @kimberlyhaugan9983 День назад

    This is a great refresher

  • @ouahibabela8986
    @ouahibabela8986 День назад

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

  • @AnifuddinAfg
    @AnifuddinAfg День назад

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

  • @CallOSaulTitan
    @CallOSaulTitan День назад

    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 День назад

    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 День назад

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

  • @woodworkerroyer8497
    @woodworkerroyer8497 День назад

    This is better (and faster) than the whole class I had on word and excel! Such a powerful tool!

  • @bobgreenfield9158
    @bobgreenfield9158 День назад

    What if you sum in a view?

  • @Patricia-mx7ml
    @Patricia-mx7ml День назад

    Will you please help with this? How can I add a dropdown list within a dropdown list that has the next consecutive number in Excel? I'm trying to make an inventory number list like this: The first dropdown list will have the category of the item. When the category is selected, another dropdown will open, showing the next number available for that particular category.

  • @willykipla7
    @willykipla7 День назад

    oh! great!

  • @augustineella-wp6qu
    @augustineella-wp6qu День назад

    Thanks for the video is mind blowing😍 i need a copy of the practical so that i can practice it and compare

  • @alessandroleone5709
    @alessandroleone5709 День назад

    Is it possible to insert short video recording of the monitor?

  • @SimplisticallyDigital
    @SimplisticallyDigital День назад

    This is perfect! Will use this method going forward 🙏🏿

  • @ANURAG-hd2ji
    @ANURAG-hd2ji День назад

    A great thanks to you

  • @arseniodizon3071
    @arseniodizon3071 День назад

    Thank you sir

  • @mdbabluislam4031
    @mdbabluislam4031 День назад

    Akta selari sheet diye video diyen....

  • @mdbabluislam4031
    @mdbabluislam4031 День назад

    ❤❤❤❤

  • @phionakatz
    @phionakatz День назад

    Got here to learn excel before i go in for my assessment for my new job next week. I hope i can be prepared by then🤦🏽‍♀️

  • @jeffrystephan6992
    @jeffrystephan6992 День назад

    Thank you

  • @laylaalbesher6880
    @laylaalbesher6880 День назад

    I used the function but somehow i still get errors? @

  • @beatricekalimanshi5940
    @beatricekalimanshi5940 День назад

    This looks tougher yet l 'am learning just come across and l'am struggling to learn more so that it will help me for work. Thank you

  • @ellenbushuf873
    @ellenbushuf873 2 дня назад

    Thank you , you saved me an hour of typing

  • @Pavi_9
    @Pavi_9 2 дня назад

    Really an amazing session. The points are very crystal clear and very easy to understand . Thanks a lot!

  • @JemmaBaldwin
    @JemmaBaldwin 2 дня назад

    digitalsoftwarekey

  • @JemmaBaldwin
    @JemmaBaldwin 2 дня назад

    digitalsoftwarekey

  • @user-up1kc3vj8f
    @user-up1kc3vj8f 2 дня назад

    Its new being 8 years old befor the video

  • @freespirit8311
    @freespirit8311 2 дня назад

    Thank you!!! Very helpful tutorial indeed! I use Pages mostly and after looking all over, and couldn't remember where to find the tabs in Word. I Googled for help but couldn't understand other's explanations. Your instructions were clear and concise! If you're still an educator, I am sure your students appreciate your teaching style!

  • @Waqas9157
    @Waqas9157 2 дня назад

    Thank you, your videos are so helpful. 😊

  • @SwarnaEkanayake-er9yj
    @SwarnaEkanayake-er9yj 2 дня назад

    good teachings

  • @njidekaudodike9821
    @njidekaudodike9821 2 дня назад

    Free exel. ❤. Thanks a lot sir. I learned a lot today.

  • @sarahsiddiqui4618
    @sarahsiddiqui4618 2 дня назад

    this is cool I am only 12 and i know how to use excel now and because of I got an A+ in my practical

  • @njidekaudodike9821
    @njidekaudodike9821 2 дня назад

    God bless you sir. Very good lesson.

  • @Miriam-jy7tgz
    @Miriam-jy7tgz 2 дня назад

    Very well explained! thank you!!!