[FREE EXCEL COURSE] Lesson 6 - Excel Tables Overview

In this video, you'll learn how to use Excel tables.
Excel tables are amazing, especially if you plan to work with a lot of data/dashboards/models.
And now that new tools (such as Power Query and Power Pivot) are available, it has made Excel tables even more powerful.
In this video, I cover the following topics:
-- Creating an Excel Table
-- Excel Table features
-- Structured references
-- Table slicers
-- Note that table slicers became available only from Excel 2013 -version onward.
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com/learn-excel/
You can also access the Full Excel Training on KZbin here: • Getting Started with E...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzbin.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@Lettilany]

Hi from Hungary. I cannot tell you how much your videos help me. You are an excellent teacher. Thanks a million!

[@amanullaal9531]

I never saw such a simple and easy to understand explanation for excel until I started watching these videos. Thank you

[@trumpexcel]

So happy to hear this. Glad you're finding the videos useful 🙂

[@kookDarling]

i like it when you say ctrl +zeeee.... its cute. but your teaching/explaining skills are awesome

[@prakratisharma9006]

This course is so underated!

[@ChloeSapaden]

Six videos in and I've really appreciate this series and your work!!!

[@trumpexcel]

Thanks Chloe... Glad you're finding the videos helpful 🙂

[@wayneedmondson1065]

Hi Sumit.. another good review. Thanks for sharing this video series for free. Thumbs up!

[@sodiqiyanda7619]

Hi Sumit, How are you doing? I'm Sodiq Iyanda from Nigeria. I blessed the day I came across TrumpExcel. Your contents are so wonderful. You teach and share your knowledge selflessly. What can I say? How can I appreciate you? Thank you for this opportunity to learn Excel at no cost. You are a great and exemplary leader. Thank you, so much!

[@narayanan7771]

Thank you Sumit Bansal for these wonderful Excel course. Learnt a lot from these courses. Stay blessed!!

[@anastasiosdouzinas1080]

Thank you for your videos highly appreciated!

[@aubreyleblanc2843]

I’ve gotta make an inventory excel sheet for my company and these videos are teaching me all I need. Thank you

[@mohammadirkanansari671]

THIS VIDEO AWASOME BECOUSE I FEEL DEFULTY TO SEE LARGE DATA IN WORKSHEET THANK YOU SIR IT MY PLEASURE TO TAKE THIS CLASS

[@nmb2Bryant]

God bless You kind sir ! Greetings from Luxembourg !!!!!!!!!!!!!!

[@hihimanshuu]

Thank You Sumit for your videos. We really enjoyed and learnt from it .

[@carlasofiacarreirajacinto3016]

Thank you so much for this! It is a great opportunity to learn more about excel features! :)

[@ryanmdsouzaa]

Thank You Sumit for sharing this valuable course!!

[@poonampai203]

Really great Explanation! THANK YOU!

[@TimMorello1]

Sumit, you are a legend!

[@ankitachauhan4629]

I am watching this in 2024, I am about to start my MBA journey from an IIM, and I am a bit weak in this laptop work, I watched your past 5 videos and now I am confident that after finishing the whole course, I am ready to work on excel. thank you so much Sumit Bhaiyaa. lots of love.

[@jetxxxx287]

would you please share your preparation journey with me and how you made it into the IIM as i also have started preparation and feeling skeptical whether i would be able to make it or not being a below average student.

[@ravurisurendra6874]

Tq sumit keep on rocking with videos

[@AbukAmanB]

Thank you for ur generous videos was so helpful ☺. Keep it up.

[@mohanvaze1]

Excellent narrative. Thanks a ton :)

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@atharfarid247]

Very much Informative!!!!!!!!

[@mudasirahmad4916]

Kudos to sumit sir. U have done an incredible job.. Keep up the good work.. If u could share the notes of each lecture that would be really awesome... Once again thank u so much.

[@krishnasathya5272]

thank you

[@himi1509]

Thanks Sir

[@nandika3558]

Sumit ji excel ki kuch worksheet bhi download karne ke liye de dete jo aap apni videos mein use kar rahe hain, hum logo ke liye better hota

[@GoGetSP]

Hey Sumit, I am using 2016 version and unselecting Banded rows is causing no change to the table. Kindly help what am I doing wrong?

[@nitinmohane961]

Do you think other than Microsoft MOS certificate for Excel, the other ones that are there, are approved and recognized in the market?

[@user-pm1wz1dl9g]

Hey Sumit Bansil, I just want to know If there is any way to downloads the workbook that are being used in the video? or if someone else knows than please help me.

[@raviprasadvoletiBR16L]

Is merging cells horizontally or vertically possible in this table?

[@KiranHarijan-ih7pg]

Sir can you provide data set for practice

[@manjeshbanawara7957]

How do you move table rows?

[@heeyaboruah9226]

What does ctrl+e do? Also one suggestion, I am just a grade 7 student and during this pandemic I don't surprisingly have a lot of time on my hands so I would gladly appreciate it if these videos could be a bit shorter but I am already very thankful of having these videos! Thank you for helping!

[@heeyaboruah9226]

@@el_benny_ like even 10 minutes is great lmao

[@heeyaboruah9226]

@@el_benny_ I finished it already so it doesn't really affect me now

[@user-kb7ly8yi6b]

@@heeyaboruah9226 this is unsolicited and late advice but i personally like to change the playback speed so the video goes by a little faster without me missing any content. for these videos though, i only hit 1.25x playback speed because sumit already talks in a good speed -- unlike some of the courses i took where the speakers talk so slow and 2x playback speed is still understandable. it's not much but i think it helps esp with boredom

[@techfrom0]

i have a doubt at 17:20 pls help to understand this thing

[@Bhangdu-xg1co]

Aap accha kaam karte ho ,kaam karo

[@importantthings229]

I join computer class for this things ... But know I realise this ... Why I join .... U tell us many things ... Comparison My class😢😢😢

[@Kartikeycool]

english class join karle 👍🏻

[@saumyasundaram8759]

Your audio quality is really harsh 😡

[@heeyaboruah9226]

Yessirrrrrrrrrrrrrrrr Be appreciative that you at least got this for free 😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡 Did I crash your page yet? Hope I did 😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡😡 Yourrrrrrrrrr welcome 😊

[@heeyaboruah9226]

You probably liked you own comment lol

[@el_benny_]

dont watch it then,