Microsoft Excel Tutorial - Beginners Level 5

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: https://www.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: https://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: https://youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST Subscribe to Teacher's Tech: http://bit.ly/Subscribe_TeachersTech ***More Videos on Microsoft Excel*** Dive deeper into formulas and functions: https://youtu.be/tyGaEl3ec8o Microsoft Excel for Beginners - Level 1: https://youtu.be/k1VUZEVuDJ8 Microsoft Excel for Beginners - Level 2: https://youtu.be/bhZckWTLkJM Microsoft Excel for Beginners - Level 3: https://youtu.be/47yu50CsH00 Excel for Beginners Tutorial - Level 4: https://youtu.be/c8qePWuYleg VLOOKUP Function for Excel: https://youtu.be/Lw03WcG4mt4 Learn Pivot Tables for Beginners: https://youtu.be/igSovq_H24A How to QUICKLY Use 3D Formulas in Excel: https://youtu.be/Ad5QbfQLM2s 10 Best Excel Tips for Beginners: https://youtu.be/ZthlSLYc5UQ How to Make a Line Graph in Excel: https://youtu.be/0jdX22qM8JA