Channel: Teacher's Tech

Category: Education

Tags: excel tutorialmicrosoft excel tutorialmicrosoft excel tutorial - beginners level 5learn exceljamie keetteacher's tech tutorialsbasic excel tutorialimport data from web in excelmicrosoft excelexcel tutorial for beginnershow to use tables in excel

Description: In this video, I will show you how to import data from the internet to a worksheet in Microsoft Excel and I will show you how to use tables in Microsoft Excel. Want more Excel videos? Here’s my Excel playlist: youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw 0:00 Introduction 1:23 Import data from a webpage to Excel sheet 7:28 Creating tables in Excel 9:30 Sorting in tables 10:55 Styles options in Excel Tables 14:30 Remove duplicate rows in tables 17:09 Create a table shortcut 17:33 Copy data across multiple sheets in Excel 19:33 Format an entire sheet in Excel Practice Sheet: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EbZ7aYXKCY9NijkMHtZjk0sBJVqtN_mT-vFi6yhYaD4P3w?e=dRHzh4 Dive deeper into formulas and functions in excel with this playlist: youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST Subscribe to Teacher's Tech: bit.ly/Subscribe_TeachersTech ***More Videos on Microsoft Excel*** Dive deeper into formulas and functions: youtu.be/tyGaEl3ec8o Microsoft Excel for Beginners - Level 1: youtu.be/k1VUZEVuDJ8 Microsoft Excel for Beginners - Level 2: youtu.be/bhZckWTLkJM Microsoft Excel for Beginners - Level 3: youtu.be/47yu50CsH00 Excel for Beginners Tutorial - Level 4: youtu.be/c8qePWuYleg VLOOKUP Function for Excel: youtu.be/Lw03WcG4mt4 Learn Pivot Tables for Beginners: youtu.be/igSovq_H24A How to QUICKLY Use 3D Formulas in Excel: youtu.be/Ad5QbfQLM2s 10 Best Excel Tips for Beginners: youtu.be/ZthlSLYc5UQ How to Make a Line Graph in Excel: youtu.be/0jdX22qM8JA