![Technology for Teachers and Students](/img/default-banner.jpg)
- Видео 525
- Просмотров 142 342 409
Technology for Teachers and Students
США
Добавлен 17 янв 2008
I'm an educator and educational technology enthusiast. The videos on this channel will help you learn how to use a wide range of computer software applications, educational websites, and other technology tools. Watch for a new video every Monday! Connect with me on the services you see below in the Links section.
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...
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
The Microsoft Word Design Tab and Ribbon in Depth
Просмотров 4,8 тыс.2 месяца назад
The Microsoft Word Design Tab and Ribbon in Depth
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
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
Which version of Excel are you using? I'm on 2019, I don't see anything about getting data from pictures or even PDFs.
Helpful
What if you wanted to know whose weight is "between 300-329"?
❤
I constantly have to come to these to refresh my memory. Saving my ass for this Admin Assistant III position. Also PowerPoint was great!!!
Heaven forbid 😂😂😂
HOW DO YOU REQUEST FILES NOT SEND
I have read through so many search options and your video was the first one to make sense and actually work. THANK YOU!!!
You are an Excellent instructor, your tone of voice, not rushed, easy to follow instructions etc.❤
How do you save each document as its own file ? PLEASE HELP
What’s another way for the charts to appear bcz mine doesn’t appear when I hold ALT+F1
thanks
Informative needed for beginners 😊
I have been using excel before but i lerant more in this video, kudos
Thank you so much more useful in this video
🎯 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
Thank you very much
This is a great refresher
thanks a lot for your continued support and interesting what you are sharing with us. thanks again.
how to showing again google sheet template?, because in my google sheet i don't find option turn on.
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!
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.
What's the point in Google My Maps if you can't send a route to a navigation device like Google Maps?
This is better (and faster) than the whole class I had on word and excel! Such a powerful tool!
What if you sum in a view?
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.
oh! great!
Thanks for the video is mind blowing😍 i need a copy of the practical so that i can practice it and compare
Is it possible to insert short video recording of the monitor?
This is perfect! Will use this method going forward 🙏🏿
A great thanks to you
Thank you sir
Akta selari sheet diye video diyen....
❤❤❤❤
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🤦🏽♀️
Thank you
I used the function but somehow i still get errors? @
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
Thank you , you saved me an hour of typing
Really an amazing session. The points are very crystal clear and very easy to understand . Thanks a lot!
digitalsoftwarekey
digitalsoftwarekey
Its new being 8 years old befor the video
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!
Thank you, your videos are so helpful. 😊
good teachings
Free exel. ❤. Thanks a lot sir. I learned a lot today.
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
God bless you sir. Very good lesson.
Very well explained! thank you!!!