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.

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

***More Videos on Microsoft Excel***

[godwinuche]

I will break my tv any day I couldn’t find any of your tutoring videos on YouTube I mean it. You have given me hope to continue learning this excel program because You are very easy to understand. I just discovered your channel and stop going for an excel class I paid for. May Good things never depart from your household. Many thanks from Lagos, Nigeria

[aprilfraize]

I watched all these beginner level videos and you helped me so much! I would love to see intermediate and advanced levels too! You teach very well! Thank you!

[vio]

Thank you teacher Jamie! You're amazing. All your tutorial lessons are concise, clear and comprehensive. Keep up the good work! God bless you!

[advicefree]

You're the best excel teacher on youtube, thanks so much.

[wendyc]

I've enjoyed these sessions. Thank you. You explain things very well. Many of these points I did not learn when I first did Excel.

[elephantsdung]

Thanks so much! These are the best classes so far! I enjoy learning!

[hqmwpnh]

Thank you for the amazing lessons. I never thought learning Excel could be so easy. It seemed impossible until I found your videos.

[tundeakinniyi]

You have made this journey so easy for me cos i never believe i can still learn this again. this course was abandoned over a decade because of bad tutor. I am grateful for this and i hope we meet in the future to thank you once again. from Abuja, Nigeria .

[Sophie-fidm]

@Teacher Tech Literally needed this. So simplified and now I get it!!!!
No idea how much this is helping me - thanks so much ☺

[cristyunorguiapal]

Thank you, teacher Jamie! You're awesome!

[jackycoad]

Have watched all 5 beginners and they are so good, easy to understand

[Dellhpdellhp]

You are best ever teacher man, the way you teach is really easy and fascinating

[shmuelkeller]

Thank you for the five levels for beginners. It was great.

[Preferredbaby]

Thank you so much Jamie! You're an amazing teacher.

[sheenamendoza]

Thank you so much, it was very helpful for a beginner like me. I loved that you also provided us with the data we can practice while watching your tutorial. Thank you so much.

[khanyisilebotolo]

For those using Microsoft (2016), select tab “Data” > select “New Query” under group “Get & Transform” > “From Other Sources” > “From the Web” > Paste URL > Ok > Under “Navigator” select whether you want to attach the entire document or the table > Select “Load”

[mshjtmq]

am so grateful to u sir. have been trying to learn excel from many other channels but i got confused halfway but your explanations are so simple but detailed and easy for even 11 year old to follow. may God reward you sir. some times i just watch your explanations then rewatch again but this time with practice. i love the fact that you time stamped the videos .easy to navigate. love from UK

[attilanagy]

Thanks again for another great tutorial...watched them all so far...

[campingadventures]

Hi, thank you for your video, i'm learning so much, and creating some tables as I'm watching your video, . I'm at the beginners level.thank you learning so much.

[wawps]

you are wonderful tutor Jamie, i can understand all videos you taught