Distance Learning, mLearning, Digital Education, Technology
16.5K views | +0 today
Distance Learning, mLearning, Digital Education, Technology
Your new post is loading...
Your new post is loading...
Scooped by Dennis Swender
June 22, 2020 1:02 PM
Scoop.it!

Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)

Discover hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST.

In this video I'll show you in about 10 minutes, how simple it is to create a pivot table and get quick insights into your data. I'll also throw in some Excel Pivot Table tips and tricks not everyone is aware of. To top it off we'll also add Pivot Slicers to get a professional visual to apply filters to our Pivot Table.

⯆ DOWNLOAD the workbook so you can practice with this Pivot Table example data: https://bit.ly/LeilaPivotTable

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

Time Stamps
00:00 Why use Excel Pivot Tables?
01:35 Convert Data to Excel Tables
02:46 Create Pivot Table
04:08 Change aggregation in Pivot Table to average or count
04:40 Adjust number format in Pivot Table
05:10 Add filter to Pivot Table
05:28 Add column fields to Pivot Table
05:50 Removing Grand Totals and Sub Totals in Pivot Table
06:27 Update Pivot Table layout and design
07:14 How to bring back Pivot Table Fields dialog box
07:42 Update Pivot Table column header without errors (pivot table field name not valid)
08:33 Sort values in Pivot Table
08:41 Lock column width on Pivot Table refresh
09:00 Add Value as percentage of grand total in Pivot Table
10:22 Add Pivot Table Slicers to Filter Data
11:10 Connect Slicer to multiple Pivot Tables
11:50 Refresh Pivot Tables
12:40 Benefits of Pivot Tables

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel
No comment yet.
Scooped by Dennis Swender
June 22, 2020 1:00 PM
Scoop.it!

The Beginner's Guide to Excel - Excel Basics Tutorial

If you like this video, here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel
Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.
***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents

Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels: http://amzn.to/2xTpck1
Ladyhawke: http://amzn.to/2xOhLsA
Stardust: http://amzn.to/2yjJvs9
Young Sherlock Holmes: http://amzn.to/2xaJJNv
No comment yet.
Scooped by Dennis Swender
June 22, 2020 12:57 PM
Scoop.it!

30 Ultimate PowerPoint Tips and Tricks for 2020

The ultimate compilation of PowerPoint tips and tricks to enhance your skills using Microsoft PowerPoint. I’ve combined long-established tips and tricks featured in previous videos with prominent new ones Microsoft added in 2019 and 2020. You’ll find these tips and tricks useful whether you’re using PowerPoint for the first time or just wanting to enhance your PowerPoint skills.

Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533

Contents
1. Stock Images 0:40
2. Remove Background 1:25
3. Edit Shape 2:26
4. Morph Transition 3:00
5. Enhanced Morph 3:32
6. Ctrl-Drag to Copy 4:50
7. Design Ideas 5:05
8. QR4Office 5:45
9. Filled Map 6:47
10. Dictate & Translate 7:49
11. Quick Alignment 9:00
12. Ink to Text 10:03
13. Eyedropper 12:43
14. Chart Animation 13:39
15. Alt-Shift Order 14:40
16. Quick Access Toolbar 14:59
17. Smart Lookup 16:04
18. Slideshow Tricks 16:45
19. Animate Images 18:06
20. Instant Photo Album 19:04
21. Reuse Slides 20:14
22. Link to Excel 21:06
23. Animated GIF 22:24
24. Layered Images 24:00
25. Slideshow Loop 26:46
26. Embed Fonts 27:30
27. Compress Media 28:05
28. HD Video Export 29:06
29. Shape Intersect 30:27
30. Picture Fill 32:09
No comment yet.
Scooped by Dennis Swender
June 22, 2020 12:51 PM
Scoop.it!

Teaching online: Clear Introduction to Padlet Online Collaboration Tool #teachingonline

A video on tutorial using the excellent Padlet online collaboration tool. This is a great tool for online discussions, online project work, online timelines, online back channel discussions. I often use this tool in isolation or as part of an online course using Moodle or Edmodo

This video includes all the updates to the latest version of Padlet. It shows you how to set up a Padlet and how to then share it with your students to get them to participate and collaborate together. Padlet has a number of features that I really like. For example you can create an online electronic corkboard, an online discussion channel or even an online timeline, You can get students sharing project work, having discusssions or even brainstorming and thinking of new ideas etc. I have used Padlet in a number of contexts. Students can even comment on each others contributions or even rank or score them.

This video is a complete 101 of all the options in Padlet. This will take you through all the key features in Padlet plus a few really useful tips that will help you get the most out of Padlet. This is ideal for students or teachers looking to build more collaboration in their teaching and learning online. If you want to get students to work in groups, do project work together, collaborate both in class or out of class, set up activities that involve brainstorming or sharing ideas then this is a great tool. In this video I will cover

1) Different types of Padlets
2) How to create a Padlet
3) How to share you Padlets
4) How to shorten the link/url to your Padlet
5) How to make a PDF or Image from your Padlet
6) Lots of ideas on how to use Padlets

If you are looking for quick online collaboration which is free, easy to set up and offers a nice variety of tools then I think you might like Padlet

If you want to learn about advanced features in Padlet then watch this video
https://youtu.be/gfrz_b-NQrs
No comment yet.
Scooped by Dennis Swender
June 22, 2020 12:38 PM
Scoop.it!

Zoom-Make the lessons more student-centered-Practical Ideas #zoom #teachonline


This video demonstrates some practical ideas about making Zoom lessons more student-centred. It suggests two great tools that combine really effectively with Zoom and can help to take pressure off the teacher and can lead into breakout room activities.

Many teachers are struggling with ideas that will work in Zoom but also with tools they can use when teaching with Zoom that might take the pressure off the teacher and help to make the lessons more student centred. In this video I show you examples using Padlet and examples using Google Forms and these are two tools that I often use when working with Zoom or other tools.

Learn to use Padlet
https://www.youtube.com/watch?v=X3Uf6pmpiG8

Advanced Padlet
https://youtu.be/gfrz_b-NQrs

Learn to use Google Forms
https://youtu.be/3EqBR4jgBLI




https://www.teachertrainingvideos.com/

No comment yet.
Rescooped by Dennis Swender from Edumorfosis.it
June 22, 2020 12:37 PM
Scoop.it!

Converting your outdated eLearning content

Converting your outdated eLearning content | Distance Learning, mLearning, Digital Education, Technology | Scoop.it

What if I told you that converting your obsolete eLearning content into engaging training doesn't have to be difficult and that all you need to do is to follow a few tips, and you'll get it all done? In this article, we'll be exploring a few methods that you can utilize to convert your outdated eLearning content into highly engaging training. However, before we get into that, let's first take a look at a few reasons why it's essential to convert your obsolete content.


Via Edumorfosis
No comment yet.
Rescooped by Dennis Swender from Edumorfosis.it
June 22, 2020 12:37 PM
Scoop.it!

How the shift to Remote Learning affects students 

How the shift to Remote Learning affects students  | Distance Learning, mLearning, Digital Education, Technology | Scoop.it

Previous experience with eLearning seems to be a key factor in the preparedness, as reported by Barnes & Noble Education [1]. The survey conducted in March 2020 found that 60% of respondents found the switch to be relatively easy.

The setting of their learning environments is another reason for worry. Not everyone has a home environment that will allow them to work or study from home. 64% of students expressed concern over staying motivated and maintaining focus, as they get easily distracted.

Students at a collegiate level seem to be more understanding of the scenario. For many, the assignments and readings were mostly done online already. Today, even several standardized and aptitude tests [2] are also conducted online. The only difference is that the lectures have moved online.


Via Edumorfosis
No comment yet.
Rescooped by Dennis Swender from Digital Technologies
June 22, 2020 1:25 AM
Scoop.it!

Here Is An Excellent Tool to Create Interactive Games and Presentations to Use in Class

Here Is An Excellent Tool to Create Interactive Games and Presentations to Use in Class | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
Free resource of educational web tools, 21st century skills, tips and tutorials on how teachers and students integrate technology into education

Via NextLearning
No comment yet.
Rescooped by Dennis Swender from iPads, MakerEd and More in Education
June 22, 2020 1:16 AM
Scoop.it!

Kids Are So Over Zoom. Here's What To Do About It. | HuffPost UK Parenting

Kids Are So Over Zoom. Here's What To Do About It. | HuffPost UK Parenting | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
Video calls can be a harsh reminder of the sudden changes in your child's life.

Via NextLearning, John Evans
Joseph Aguilar's curator insight, September 12, 2023 5:11 PM
COVID essentially changed our workplace and how education is being delivered drastically. This article talks about how kids are being affected when it comes to online Zoom meetings. It's important to realize kids need that social interaction amongst their peers. This article offers information on what you could do as a parent and educator to help the child through their online journey.
Rescooped by Dennis Swender from Education 2.0 & 3.0
June 22, 2020 1:11 AM
Scoop.it!

10 fun games to play on Zoom

10 fun games to play on Zoom | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
Netflix and Zoom is so last week. Instead, play one of these entertaining Zoom games.

Via Yashy Tohsaku
No comment yet.
Rescooped by Dennis Swender from The Student Voice
June 22, 2020 1:08 AM
Scoop.it!

Why are students failing to study online?

Why are students failing to study online? | Distance Learning, mLearning, Digital Education, Technology | Scoop.it

Why are students failing to study online? Find out 10 reasons why students drop out of their online courses and learn the solutions that can help.


Via Peter Mellow
No comment yet.
Rescooped by Dennis Swender from Learning with Technology
June 19, 2020 4:21 PM
Scoop.it!

Virtual Training Blind Spots And How To Avoid Them

Virtual Training Blind Spots And How To Avoid Them | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
Read this insightful article to discover the 4 common virtual training blind spots to avoid when moving your content online.

Via NextLearning
No comment yet.
Rescooped by Dennis Swender from MiniTool Software Solution
June 19, 2020 4:21 PM
Scoop.it!

How to Make Time-Lapse Video (with Pictures)

How to Make Time-Lapse Video (with Pictures) | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
How to make time-lapse videos to record the drifting clouds, or others? This article shows different ways to create time-lapse videos.

Via MiniTool Software
No comment yet.
Scooped by Dennis Swender
June 22, 2020 1:01 PM
Scoop.it!

Excel 2016 Advanced

Excel 2016 Advanced Tutorial

Exercise Files: https://bit.ly/37PhfeM

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Named Ranges 0:03
Creating Named Ranges from Selection 5:24
Named Ranges (Continued) 8:31
IF Functions 11:15
Formula Auditing Tools 19:26
IF Functions (Continued) 26:05
Nesting Functions 30:51
VLOOKUP 38:42:19
Autofill VLOOKUP & IFERROR 47:20
VLOOKUP Range 54:01
VLOOKUP Range with Nested Functions 59:31
HLOOKUP 1:07:27
SUMIF 1:11:17
AVERAGEIF 1:19:20
SUMIFS 1:23:12
Date Functions 1:27:47
Text Functions 1:34:27
Consolidating Data 1:41:00
Consolidating Data Without Structure 1:45:28
Complex Solver Tool 1:48:27
Solver Tool 1:54:09
Scenario Manager 2:02:11
Data Table 2:09:38
Turning on the Developer Tab 2:16:08
Recording Macros 2:18:18
Editing Macros in VBA & Recording a Second Macro 2:23:46
Adding Macros to the QA Toolbar 2:31:27
Adding Macro Buttons to the Worksheet 2:33:46
Conclusion 2:36:52
No comment yet.
Scooped by Dennis Swender
June 22, 2020 12:59 PM
Scoop.it!

Make Your Photos �COME TO LIFE� PowerPoint Tutorial

� PowerPoint Zoom Course �
✅ Get 30% Off: https://www.udemy.com/course/slide_zoom/?couponCode=D5E1535EC80BBEA3C85F

� PowerPoint Parallax Course �
✅ Get 30% Off: https://www.udemy.com/course/powerpoint-parallax/?couponCode=F30405A85E9848BDBE84

� I am using Camtasia for screen recording and video editing
✅ Try it for free: https://techsmith.z6rjha.net/Kmv3x

�I am using PowerPoint Office 365
✅Try it for free: https://microsoft.msafflnk.net/yAvvb

In this PowerPoint Tutorial you will learn how to animate photos in PowerPoint and make them look alive. With the help of a couple of PowerPoint animations and a Scribble tool you take any part of your photo and make it move, how awesome is that? Let's get started :)

This tutorial was inspired by this awesome video by Spoon Graphics:
https://www.youtube.com/watch?v=kw07wyP3qm4
WATERFALL PHOTO:
by Rio Hodges
https://unsplash.com/photos/nNPONh2aXeQ

�MUSIC:
Buddha by Kontekst►https://soundcloud.com/kontekstmusic
Creative Commons — Attribution 3.0 Unported— CC BY 3.0 ►
https://creativecommons.org/licenses/by/3.0/
Music provided by Audio Library ►https://youtu.be/b6jK2t3lcRs

� MICROPHONE:
Rhode NT Usb Microphone ► Get It Here ► https://amzn.to/2KEAKyy

� MORE AWESOME PPT VIDEOS:
� Beginner PowerPoint Tutorials ► https://goo.gl/RybRbt
� Slide Design PowerPoint Tutorials ► https://goo.gl/aHPpRR
� PowerPoint Infographics Tutorials ► https://goo.gl/PHbg2k
� PowerPoint Morph & Parallax Tutorials ► https://goo.gl/2ApgHp

�BUSINESS INQUIRIES → 1oneskill1@gmail.com

#powerpoint #microsoftpowerpoint #powerpointtemplate
No comment yet.
Scooped by Dennis Swender
June 22, 2020 12:54 PM
Scoop.it!

How to Teach Remotely with Padlet

Learn how to teach remotely with Padlet, an online bulletin board where students can have interactive conversations, show their thinking, showcase their work, and much more!

In this week's education technology tutorial, Sam Kary shows you how to use Padlet for online learning. You'll learn how to optimize the settings and customize Padlet to best fit your teaching needs, how to upload different types of media, and create different kinds of boards. Along the way, Sam also gives you different tips and ideas for creative ways to use Padlet with your students.

Click here for to visit The New EdTech Classroom for tips, ideas, and resources for how to use education technology to increase engagement, rigor, and creativity in your classroom: https://www.newedtechclassroom.com/

Follow Sam Kary on Twitter: https://twitter.com/newedtechclass

Facebook: https://www.facebook.com/NewEdTechClassroom

Pinterest: https://www.pinterest.com/newedtechclassroom/

Interested in the software I use to create my videos? Check out the affiliate links below! Many of these products offer a free trial to start and just clicking on the link helps to support The New EdTech Classroom and this channel!

Screenflow is a dynamic, intuitive video editing software that I use to create all of my YouTube videos. They're currently offering a free trial! Get more details here: https://telestream.8bx6ag.net/c/2242743/352742/4900

I use Adobe Spark Post to design all of my YouTube thumbnails, as well as for the graphics and web page creation, as well as video projects I make with my students. More information here: https://clk.tradedoubler.com/click?p=264355&a=3154632&g=24531570

If you're interested in creating a website, these are a couple of programs I personally use and highly recommend:

Bluehost is a web host that offers a professional platform for your website. You can check them out here: https://www.bluehost.com/track/newedtechclass/

Elementor is a powerful tool that helps with clean visual design for your website as well as marketing to further your website's influence. More details here: https://elementor.com/?ref=11213
No comment yet.
Scooped by Dennis Swender
June 22, 2020 12:49 PM
Scoop.it!

Make your PDFs and Worksheets Editable Online - Using Google Slides

Remote learning tips for teachers. This video tutorial will show you how to take your worksheets or pdfs and turn them into an editable worksheet online using Google Slides. I then will show you how to use Google Classroom to hand out this worksheet. This will help while students are learning online.

Read the article on this topic here: https://teachers.tech/make-your-pdfs-and-worksheets-editable-online-using-google-slides/

9 Best Website for Teaching Online from Home: https://youtu.be/quWBd3GeH6w

Learn how to start your Youtube channel: https://youtu.be/vcMCRDAjNt8
Google Classroom Tutorial for Beginners: https://youtu.be/pl-tBjAM9g4
Use your iPhone to scan documents in Notes: https://youtu.be/16nwB3P78GQ

I use Camtasia to create my video tutorials:

Use this coupon code: TEACHCAM10
Camtasia purchase with 10% OFF code applied: https://techsmith.z6rjha.net/c/1264585/701976/5161
Camtasia EDU 10% OFF with code applied: "https://techsmith.z6rjha.net/c/1264585/704928/5161
Camtasia Download page: https://techsmith.z6rjha.net/c/1264585/489271/5161DISCLAIMER:

DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for the support!
No comment yet.
Rescooped by Dennis Swender from Edumorfosis.it
June 22, 2020 12:38 PM
Scoop.it!

The role of AI in your EdTech App

The role of AI in your EdTech App | Distance Learning, mLearning, Digital Education, Technology | Scoop.it

Education is a unique industry.

It’s devoted to intensive individualization. Every group of students, whether they are in third grade, 8th grade, or college, expects personalized instructional services. Although all learners must demonstrate that they understand the learning goals for each level, how they get there can take vastly different paths. Technology can help with that personalization.

Teachers customize learning for their students so that every child and young adult can master concepts and move on. Regardless of a student’s prior learning experiences and levels, the teacher must move the student forward at least one academic year. Some students require extensive intervention to meet this goal. In recent years, educators have been turning to artificial intelligence to help them bridge learning gaps and meet student needs.

If you’re designing an edtech app, think about the role AI will play in your design. Artificial intelligence is support teachers and students expect to have. When done right, it’s engaging. Finally, it’s already in use in instruction.


Via Edumorfosis
No comment yet.
Rescooped by Dennis Swender from Edumorfosis.Work
June 22, 2020 12:37 PM
Scoop.it!

Virtual Learning Success: Guidance for Instructors

Virtual Learning Success: Guidance for Instructors | Distance Learning, mLearning, Digital Education, Technology | Scoop.it

It was announced in May that the largest four-year college system in the U.S., California State University (CSU), will continue to be held online through the fall due to the spread of the coronavirus. This news marks a definite shift to a world where, more and more, learning of all kinds will now take place virtually. Even at institutions that remain hopeful about the possibility of a return to on-campus learning sooner than later, the role of virtual and eLearning tools and platforms will undoubtedly play a bigger role than ever before. In light of this, we are sharing some guidance for instructors themselves on how to pivot successfully to virtual learning, and what to look for when selecting new eLearning tools and platforms.


Via Edumorfosis
No comment yet.
Rescooped by Dennis Swender from Digital Technologies
June 22, 2020 1:26 AM
Scoop.it!

The 31 Educational Web Tools Every Teacher Should Know about

The 31 Educational Web Tools Every Teacher Should Know about | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
Free resource of educational web tools, 21st century skills, tips and tutorials on how teachers and students integrate technology into education

Via NextLearning
No comment yet.
Rescooped by Dennis Swender from Digital Technologies
June 22, 2020 1:25 AM
Scoop.it!

Design an arcade game | Digital Technologies Hub

Design an arcade game | Digital Technologies Hub | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
Get involved in our Arcade Game competition while you are learning at home. Students are invited to create an arcade game, film the game in use and submit their videos to be in the running to win some great prizes. The competition is offered in two sections; one for primary-aged students (aged 5-12), the other for secondary-aged students (aged 13-17).

Via NextLearning
No comment yet.
Rescooped by Dennis Swender from Digital Delights for Learners
June 22, 2020 1:14 AM
Scoop.it!

CristinaSkyBox: Live Polling for Collaboration and Sharing

CristinaSkyBox: Live Polling for Collaboration and Sharing | Distance Learning, mLearning, Digital Education, Technology | Scoop.it

Via Ana Cristina Pratas
No comment yet.
Rescooped by Dennis Swender from MiniTool Software Solution
June 22, 2020 1:09 AM
Scoop.it!

What Are YouTube Video Chapters and How to Add Them? [2020]

What Are YouTube Video Chapters and How to Add Them? [2020] | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
This post shows you what YouTube video chapters are and how to add them to your video process bar to help viewers find the sections they are interested in.

Via MiniTool Software
Gary Heggins's curator insight, June 23, 2020 11:20 PM
I think this video is very informational to any one that would like to learn how to put time stamps in the YouTube videos. This article also shows how to add links in certain parts of the video of the time stamps. it shows veiwers how to watch certain parts of an video or movie that you prefer to watch and it allows you to get more info in the time stamp link when u click on the video that you want to watch. I think its very reliable info because its coming direct from the source.
Rescooped by Dennis Swender from MiniTool Software Solution
June 19, 2020 4:22 PM
Scoop.it!

3 Methods - How to Convert WebP to JPG for Free

3 Methods - How to Convert WebP to JPG for Free | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
Are you looking for a way to convert WebP to JPG? Then you’re in the right place. Here will detail 3 practical methods to convert WebP to JPG at ease.

Via MiniTool Software
No comment yet.
Rescooped by Dennis Swender from Learning with Technology
June 19, 2020 4:21 PM
Scoop.it!

The Ultimate Guide To Setting Up A Virtual Classroom

The Ultimate Guide To Setting Up A Virtual Classroom | Distance Learning, mLearning, Digital Education, Technology | Scoop.it
What is a virtual classroom? Find out in our ultimate guide to setting up a virtual classroom in a remote teaching environment during COVID-19. Click to learn more.

Via NextLearning
No comment yet.