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.
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
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!
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
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.
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
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.
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.
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.
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.
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
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 :)
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/
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
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
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.
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!
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.
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.
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).
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.
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.
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.
To get content containing either thought or leadership enter:
To get content containing both thought and leadership enter:
To get content containing the expression thought leadership enter:
You can enter several keywords and you can refine them whenever you want. Our suggestion engine uses more signals but entering a few keywords here will rapidly give you great content to curate.