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