Only 1% of Excel Users Know Excel Tables! STAND OUT from the Crowd!

Ғылым және технология

Excel Tables can provide huge efficiency gains, but few Excel users know about them. This video will get you started with Excel Tables and showcase some of their cool features.
🎓 LEARN MORE If you'd like to learn more, including how to reference Excel Tables in formulas, please take a moment to check out my course: www.myonlinetraininghub.com/e...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...

Пікірлер: 202

  • @Nicole-lc6gt
    @Nicole-lc6gt4 жыл бұрын

    This is the best tutorial I have seen on excel tables, thank you.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Glad it was helpful, Nicole!

  • @i3gallery
    @i3gallery3 жыл бұрын

    Elegance in simplicity via a "no-fuss", concise teaching methodology has already made me a fan. I use a range of tools in my self-learning quest aimed at econometrics but I don't have the financial freedom to access paid learning routes for the tools I use so channels like yours are extremely appreciated by people like me. I will be recommending this channel as a "must watch" as one of the best, free Excel learning resources about.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    So pleased to hear I can help, Jimmy! Thanks for sharing our channel, too 😊

  • @cooljoker2027

    @cooljoker2027

    Жыл бұрын

    if any one has a problem with table i was one day looking for the solution as i fever for here and say thanks to her i promised to share her value kzread.info/dash/bejne/epiqzqNxncfMh9Y.html

  • @phorton968
    @phorton9683 жыл бұрын

    Excellent KZread. Just what I was looking for - easy to follow. Your narration is professional and concise. Thank you!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad it was helpful!

  • @fredreid8265
    @fredreid82655 жыл бұрын

    Hi Mynda, i really appreciate your video's and no fuss training style.Thank you for sharing your content. Fred

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    5 жыл бұрын

    Thanks for your kind words, Fred :-) glad you find the videos helpful.

  • @hougrel9514
    @hougrel95142 жыл бұрын

    Thank you. I was using Excel and VBA to a high standard upto 15 years ago. I dont think tables were around then (?). I am now retired but have a project I want to work on. I saw someone else using tables in another Vid (not yours) and knew that I needed to update myself properly. I was so fortunate to find your tutorial straight away. You have a great easy presentation style that flows continuously, simply, and comprehensively. Having subscribed after the first couple of minutes into your presentation I will now take a look and see what else you have to offer (hoping that you do one on the Stocks data object). Again thank you so much - I am looking forward to learning and enjoying your video's xx

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thanks for your kind words, Hougrel! I do have a tutorial on Data Types here: www.myonlinetraininghub.com/excel-data-types and a dashboard which uses them here: kzread.info/dash/bejne/dmhop6aanteWotY.html

  • @kaihsinchu7334
    @kaihsinchu73345 жыл бұрын

    Excellent video! I have used Excel for many years and never really know Table can be so helpful and easy to use!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    5 жыл бұрын

    So glad you're now interested to use Tables now. They certainly are a huge help.

  • @hautecommercialrealestate2114
    @hautecommercialrealestate21148 ай бұрын

    EXCELLENT video; been using Excel most of my adult life, and had no idea how powerful tables can be! Using this for everything going forward, thank you, Mynda!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    8 ай бұрын

    Awesome to hear!

  • @POliveira11
    @POliveira11 Жыл бұрын

    Well presented. Clear. Consistent vocabulary. Well-paced words and sentences. Clear voice.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Thanks for your kind words!

  • @joycep3463
    @joycep3463 Жыл бұрын

    I have looked at many, many excel youtubes. YOU are the BEST! thank you for doing all these.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Wow, thank you so much, Joyce!

  • @xeroxo7210
    @xeroxo72103 жыл бұрын

    Enjoyed this .I am an excel junky, but never really gave thought to how powerful tables could be until now . In fact I normally would would remove them Anytime I see your video ,I just have to click cause I learn valuable things .Thank you for all you share

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    So pleased to hear you're a Table convert now :-)

  • @marksummers463
    @marksummers4633 жыл бұрын

    SIMPLE AND CLEAR!!! No one else mentioned sizing handle as marker of end of table! Like the way you highlight. Most trainers are NOT clear as to what they are highlighting!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much, Mark! Glad you found this tutorial helpful :-)

  • @zonanagon9764
    @zonanagon97643 жыл бұрын

    You are awesome! Simple and informative. Thank you and stay healthy 💪🏼.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad you liked it, Jin 😊

  • @zahir1088
    @zahir10885 жыл бұрын

    One of the best channel related to Excel. I always used to wait for new content. Please make some more videos on power query tool. The only concern is that videos are not uploading frequently.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    5 жыл бұрын

    Thanks, Zahir. If you want more frequent content then write a weekly blog on Excel here: www.myonlinetraininghub.com/blog

  • @mohammedsalman195
    @mohammedsalman1954 жыл бұрын

    I thought: “Tables were very basic things and everyone knows about it” But I was wrong there were many things which I had seen first time! Thank you Mynda ma’am for your lessons😍 #MyExcelQueen #Excel #Tables

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    So pleased you discovered some new things about Excel Tables :-)

  • @pataleno
    @pataleno3 жыл бұрын

    I used to think Excel was very boring and now I’m in a job that requires lots of data work and spreadsheets. I’m falling in love with the power of excel. It’s amazing what you can actually do. I do almost everything in excel now.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Excel could never be boring, Pat :-D Glad you're enjoying it now.

  • @NamLamH
    @NamLamH5 жыл бұрын

    Great, love your seminar :D

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    5 жыл бұрын

    Thank you :-)

  • @ahmad1xa
    @ahmad1xa Жыл бұрын

    Great tutorial! Thank you very much for sharing your experience with us, appreciate it 🙏🏻

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    My pleasure 😊

  • @SeanMClarke
    @SeanMClarke Жыл бұрын

    Really nice tutorial and very well explained - thank you so much Mynda

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    You are so welcome!

  • @utubeAgape
    @utubeAgape3 жыл бұрын

    I am one of those excel self learners who learned most of what I know before I learned about Tables! Because of that, I am not a fan of Tables - however, I like them for an unchanging Pivot Table Report. What I mean about unchanging, is that you build it once and no additional analysis or formatting will be required except to append date to the the source Table. I use tables regularly for such scenarios.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Great to hear, Irene. Tables are perfect for this purpose.

  • @Space-O-2001
    @Space-O-20012 жыл бұрын

    I was going mad as I couldn't work out why some tables retain their row banding when drag copying and some don't and it was because I had areas of no data and needed to select the whole data area and not just create the table from a single cell. Thank you for pointing me in the right direction!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Glad I could help!

  • @ianodonoghue6011
    @ianodonoghue60112 жыл бұрын

    Excellent video as always thanks for all the great work you do

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    So nice of you, Ian :-)

  • @sanjitpaul2953
    @sanjitpaul29533 жыл бұрын

    Excellent video Ma'am. Learned a lot. Thank you.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    My pleasure 😊

  • @darcyg852
    @darcyg8523 жыл бұрын

    Excellent as always!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad you think so, Darcy!

  • @TheWid
    @TheWid5 жыл бұрын

    Really clear and will be really useful; thanks.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    5 жыл бұрын

    Glad you liked it, Tony.

  • @PrasadCPerera
    @PrasadCPerera5 ай бұрын

    Dear Mynda, Your Excel tutorials are absolutely brilliant. To be honest, I started with a few different KZread channels with Excel lessons, but my interest chucked away. I was then trying to filter out the channels by giving every channel a go. Yours was not there on the list either. Frustrated at the lack of good ones, I just took a poke around on Google. I struck gold with your channel. Thanks a million for what you do. Prasad Sweden.

  • @FawziahAbbas
    @FawziahAbbas Жыл бұрын

    Hello, Thank you for your great videos, I have learned a lot form you.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Glad to hear that!

  • @luisfevel
    @luisfevel Жыл бұрын

    Thank you for this tutorial! It refreshed my mind on Tables! Ps. I added you on Linkedin.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Glad it was helpful!

  • @truewiking
    @truewiking2 жыл бұрын

    I learned a lot here, Thank you very much

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Glad it was helpful!

  • @Up4Excel
    @Up4Excel2 жыл бұрын

    Great overview. I can well believe 99% are missing out on these benefits but it's a real shame. I tell anyone that will listen about using tables 👍

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thanks for spreading the word 😊

  • @notesfromleisa-land
    @notesfromleisa-land Жыл бұрын

    Tables are at the core of much of my work. I would have been surprised to learn that 1% of folks use tables.....until I recently started working at a client where clearly tables have not been in the tool kit!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Great to hear you're a Tables fan!

  • @m1cannas
    @m1cannas3 жыл бұрын

    Amazing knowledge. Super.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much, Mario!

  • @MANI8835
    @MANI8835 Жыл бұрын

    Great tutorial. I have learn lot from it

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Great to hear!

  • @notesfromleisa-land
    @notesfromleisa-land Жыл бұрын

    Oh and one of the greatest excel shortcuts to use with tables are shift+ctrl+L to show/suppress filters. (of course there are many shortcuts but that one is newer to me and I wondered how I went so long without it!)

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Nice! Thanks for sharing.

  • @yadali4833
    @yadali48333 жыл бұрын

    Hello Ms. I have just discovered your channel, and I would for sure watch more videos, but for now I have a question, why the fill option does not work in a table? I have a table similar to the one you have here, but when I add new data in a particular row, I want its code no. to update in that place, like in your example from E055 the ID number jumps to E061, without using the drag option, which is very much manual, how could you rename all ID cells in a linear series i.e E055 then E056, then E057 and so on until it gets to E061? Thanks

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Hi Yad, please post your question and sample Excel file on our forum where we can help you further as I'm not sure what you're referring to exactly: www.myonlinetraininghub.com/excel-forum

  • @andydidyouhear
    @andydidyouhear Жыл бұрын

    Excellent video!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Thanks so much 🙏

  • @RamKumar-vb4et
    @RamKumar-vb4et2 жыл бұрын

    Great video. Thank you for sharing. I noticed that in my table, when I change a formula in one particular cell, it automatically updates the forumula for all cells in that column, even though I want to change formula for that particular cell only. I am using Office 365. Is there a way I can control this automatic formula update? Thanks.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Hi Ram, Tables are designed to use best practice formulas where you have the same formula down a column. If you want to override this (which is not advised), you can enter the cell references in the formula rather than the structured references Excel enters for you when you reference cells in a table. You can also CTRL+Z to undo Excel copying the formula down the column.

  • @shoppersdream
    @shoppersdream4 ай бұрын

    Nice, thanks!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 ай бұрын

    Our pleasure!

  • @Sbihis83
    @Sbihis83 Жыл бұрын

    Hello , thanks for your video is there some special feature in Excel Tables for conditional formating ? thanks

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    No, Conditional Formatting works the same way in Tables as it does in regular cells. If you have the latest version of Excel 365 then you'll have updates to fix segmenting of conditional formatting that occurs sometimes in tables when rows/cells are inserted/copied in.

  • @markmohammed126
    @markmohammed1262 жыл бұрын

    Excellent Video. Is there a way to save a filtered result of a table as a second table that will automatically update results when new data is entered in the master table?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Hi Mark, you could use the FILTER function to do this: kzread.info/dash/bejne/jHeFo9men6TKf9o.html

  • @arturoguzman5230
    @arturoguzman52303 жыл бұрын

    Simple but great 😍

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thank you! 😊

  • @williamstan1780
    @williamstan17803 жыл бұрын

    Very informative.. Tks you A question though If the table is an output from power query and I need to add on columns that involve some calculation base on the data consist in the table. How can I do it? How I do it now is I copy and paste link to the table on a new tab and add on the calculation manually Thanks for your help in advance

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad you found the video helpful. You should add any additional columns using Power Query to ensure they always stay synced with the rest of the data in the table.

  • @williamstan1780

    @williamstan1780

    3 жыл бұрын

    @@MyOnlineTrainingHub Tks... It is helpful... Appreciated

  • @tommyharris5817
    @tommyharris58172 жыл бұрын

    Great tutorial; I would like to see advanced filtering in tables

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thanks for the suggestion, Tommy.

  • @kangsungho1752
    @kangsungho17524 жыл бұрын

    Simple and essential lesson as alwsys! But I do stll prefer range to table. Range is easy to manipulate for me.^^

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thanks, Kang. Sometimes habits are hard to break :-)

  • @daniyalbaghi9395
    @daniyalbaghi93952 жыл бұрын

    Thanks very good

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    So nice of you :-)

  • @TVSCDN
    @TVSCDN2 жыл бұрын

    Superb ❤️❤️❤️👍🎉 thanks madam a million 🙏😀

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    My pleasure 😊

  • @saremammar9246
    @saremammar92463 жыл бұрын

    Like it. Thank you 😊

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Great to hear :-)

  • @nghiphan5348
    @nghiphan53483 жыл бұрын

    Hi, could you please help me with this. Do you know how to format cells at Number in the Header Row of the Table. It means when you input the number to cells in Header Row, they are not the number, you can check by Isnumber() command for that Header row's Cells and it gose False. I need the Header row's cells to show as number so I can use my command directly in this Header Row. Thank you for reading.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Tables do not accept numbers/dates in the header row. You might like to add a row above the table that stores the number header that's outside of the table.

  • @muhammadyar7328
    @muhammadyar7328 Жыл бұрын

    very very useful

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Glad to hear that 😊

  • @kashifafridi9532
    @kashifafridi95322 жыл бұрын

    Thank you

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Welcome!

  • @FawziahAbbas
    @FawziahAbbas Жыл бұрын

    I was wondering if I can transfer an excel table(that has forecasts /sale ) into other Excel method? in other word, I take a screenshot of that Excel sheet and paste it on my PPT.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Yes, you an insert screenshots or even the table itself into PowerPoint.

  • @thehank5368
    @thehank53683 жыл бұрын

    I noticed when you open your Name Manager there seems to be some list-definitions with a different icon than used for Named Range or Table. Would this be specific for Excel 2019 and higher and if not, how do you create those?. I'm still puzzled about the fact that it seems not possible to define a data validation list directly from an Excel table-column. I can ofcourse define a named range to be equal to the Excel table column using the Excel table structured reference (i.e. named_range=table[column_name]), and next use that named range for the data validation list, but that seems quite double work....so any comment/view from your side is much appreciated. And last but not least: thnx for the nice videos and blogs.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad you liked it, Henk! The icons might be new, I can't remember exactly. In my Name Manager at the 2 minute mark there are icons for Tables and Slicers. These icons aren't something you can create. They are automatic, so you'd have to upgrade to a later version of Excel to get them. Hope that clarifies things. Yes, not being able to create a DV list from a column reference isn't possible in Excel. The workaround you describe is the next best thing. Mynda

  • @thehank5368

    @thehank5368

    3 жыл бұрын

    @@MyOnlineTrainingHub Thnx Mynda, the other icon must be for a slicer as you mention. I don't use them a lot so I probably never noticed. My take-away of the day :), thnx!

  • @tajumir48
    @tajumir48 Жыл бұрын

    Amazing ❤❤❤

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Glad you liked it!

  • @anindadatta164
    @anindadatta1644 ай бұрын

    very useful

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 ай бұрын

    Glad to hear that 🙏😊

  • @dshankarwrites
    @dshankarwrites5 жыл бұрын

    Excellent

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    5 жыл бұрын

    Thanks, Shankar. Have fun with Tables.

  • @a11312
    @a11312 Жыл бұрын

    Is there a way to protect columns in an excel table while at the same time keep the functionality of the table? When I protect columns, new data does not extend the range

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    No, you're not able to. It's a huge frustration with Tables. If you're capturing data, then another option might be to use Excel Forms and allow the form to put the data in the table. That way the user never has to touch the table. More on Excel Forms here: www.myonlinetraininghub.com/gather-data-with-excel-forms

  • @JoaoDuarte-cj9xi
    @JoaoDuarte-cj9xi Жыл бұрын

    Can you add new lines to this table if you protect the worksheet?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    No. Tables cannot be edited in protected worksheets.

  • @khalidarafat7482
    @khalidarafat7482 Жыл бұрын

    شكرا لك

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    My pleasure 😊

  • @shakiraasfoor7599
    @shakiraasfoor75994 жыл бұрын

    Well Done

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Hope you can make use of Tables, Shakira.

  • @kianoushramezanishabolaghi4326
    @kianoushramezanishabolaghi43262 жыл бұрын

    excellent

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thank you!

  • @MM-ow2md
    @MM-ow2md Жыл бұрын

    Would have been helpful if you'd included a link to the spreadsheet so we can download it and follow along...

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    If you're interested in learning more about Tables you'll find the practice files are included with my Tables course: www.myonlinetraininghub.com/excel-tables-course

  • @lastboomerstanding47
    @lastboomerstanding47 Жыл бұрын

    Nice to have mentioned pivot tables assuming we all know how to build them

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Here's my introduction to PivotTables tutorial: kzread.info/dash/bejne/qIWgqMuFhcTdZM4.html

  • @janith5829
    @janith58297 ай бұрын

    Can add dynamic serial number to the tables?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    7 ай бұрын

    Can't see why not 😊

  • @mastergeo3006
    @mastergeo30069 ай бұрын

    Is there a way to automatically keep a formula from the above cell as you add in a new row into your table?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    9 ай бұрын

    As long as all formulas above are the same, the formula will automatically be copied down to new rows.

  • @mastergeo3006

    @mastergeo3006

    9 ай бұрын

    @MyOnlineTrainingHub That doesn't seem to work. Maybe as I add in more rows, it will learn? I have two columns containing a formula. One of the columns pulls up an old formula I used in the cells before the table that I deleted out, and not the current one I'm using. Perhaps there's some kind of an underlay it picks up. 🤔 just very odd to me.

  • @mastergeo3006

    @mastergeo3006

    9 ай бұрын

    ​@@MyOnlineTrainingHub I figured it out, there was a square with FX on it, saying AutoCorrect options after clicking that it started to copy down.

  • @saravananm718
    @saravananm718 Жыл бұрын

    in table creater., some times Vlookup formula not using ., how to solve ., ?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

  • @JJ_TheGreat
    @JJ_TheGreat Жыл бұрын

    Are there any disadvantages of using tables? Thanks.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    I'd say there are trade offs rather than disadvantages. If your worksheet is protected then you can't update a table. If your data is massive (500k+ rows and 10's of columns with lots of formulas), then a table will make the file slow.

  • @neilgore
    @neilgore2 жыл бұрын

    Slicers in tables .. just learned of it after 20+ years of excel usage

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Better late than never, Neil 😊

  • @justengineer6276
    @justengineer62762 жыл бұрын

    Thanks, Hope to clarify how to fix a cell when it's in an Excel Table, . The header only appears in the formula and don't know how to fix it. Col A , Col B, Col C , Col D Profit%, PRODUCTION , Index JAN, Index FEB, MARC, APR 25%, 6500 , [profit%]*[PRODUCTION]/1, [profit%]*[PRODUCTION]/2, [profit%]*[PRODUCTION]/3 etc How to FIX ColA cell horizontally?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Please see this tutorial on absolute references in Tables: www.myonlinetraininghub.com/excel-table-absolute-structured-references If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

  • @praveenk1672
    @praveenk16724 жыл бұрын

    Is it possible to merge table headers Mam?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Yes, when you merge columns the headers also get merged.

  • @MrNitKap
    @MrNitKap3 жыл бұрын

    👍thanks

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Welcome 👍

  • @stephenyoung3917
    @stephenyoung39173 жыл бұрын

    Hello, where can I find a copy of this excel worksheet?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Hi Stephen, I didn't make this file available outside of my Tables course, sorry. However, this Tables tutorial comes with a supporting file which may be of use: www.myonlinetraininghub.com/excel-tables

  • @fin1158
    @fin11589 ай бұрын

    Hi there - I created the table but the header row content does not display ?? The info is there but not displayed

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    9 ай бұрын

    Go to the Table Design tab > in the 'Table Style Options' check the box for 'header row'.

  • @fin1158

    @fin1158

    9 ай бұрын

    @@MyOnlineTrainingHub Super appreciative of your reply. When I turn on the header box that's when the content disappears. The info is obviously still in the cells though. Its already a large file so maybe I'll do without the table. Thanks again.

  • @ambudhimanchanda1036
    @ambudhimanchanda10364 жыл бұрын

    Can you share a video on waterfall chart?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    I'll make a note for the future. In the meantime I have a written tutorial on waterfall charts here: www.myonlinetraininghub.com/excel-waterfall-charts

  • @visioncybersystem
    @visioncybersystem Жыл бұрын

    PLS. when I use a protect sheet the table doesn't work and also the formulas in it. Can you help me in this? Also when I us it google sheet to open it the formulas give me an error.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    It is a known limitation that Tables cannot be edited when the sheet is protected, however formulas should calculate. I cannot speak for Google Sheets.

  • @yaroslav2889
    @yaroslav28893 жыл бұрын

    Excel Tables are so amazing, you will not be able to imagine life without them! What you get: - Filtering for range outside of Table is not allowed - Usual keyboard shortcut for filtering are not working with Table - Feature Track Changes will not work, if Table exists in Workbook - You can't share a workbook (feature allows two person edit workbook at the same time)

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Sounds like you're using an old version of Excel, because: - I'm able to filter outside the table. - I use the right-click shortcut key > e to open the filter options - I can share workbooks and co-author with Microsoft 365 - track changes is coming soon.

  • @yaroslav2889

    @yaroslav2889

    3 жыл бұрын

    ​@@MyOnlineTrainingHub It is Office 2013. You can filter table even when it affects rows where table exists?

  • @yaroslav2889

    @yaroslav2889

    3 жыл бұрын

    @@MyOnlineTrainingHub shortcuts: for example, I can't use Alt+4 shortcut to filter out by a current selection comparing to usual data range

  • @radu0505
    @radu05052 жыл бұрын

    !!!!!!!!!!!!!!!!!!!Need so help plz!!!!!!!!!!!!!!!! I want to create a simple table with numbers from A1:A10. In cell B1 I want to type the number in, and have that number automatically enter in the table in cell A1. Than when i type the second number in cell B1, i want the number from A1 to drop to A2 and have the new number go on top "A1". I want to do this each time i type a new number in cell B1. How can i create this rule????

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    You'd need to write some VBA code to make this happen.

  • @alishankarimov
    @alishankarimov8 ай бұрын

    Indeed, tables are great tools in excel, but the only reason I'm not able to apply it in my workplace is that we work with yearly data and we need to hide those columns having the historical data, and we have bunch of tables under. Is there a proper solution to hide the columns of the sheet while there are tables? Currently I can't use tables because of this issue.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    8 ай бұрын

    I'm not sure what the issue is because you can hide table columns. If you have multiple tables on the one sheet, then make sure they're beside one another, not under one another.

  • @alishankarimov

    @alishankarimov

    8 ай бұрын

    @@MyOnlineTrainingHub the thing is they have to be under each other due to the structure of the work, therefore I believe it is not possible unless they are put beside each other?

  • @barrycole5930

    @barrycole5930

    Ай бұрын

    ⁠@@alishankarimovbe bold…change the structure of the work 😉

  • @daniyalbaghi9395
    @daniyalbaghi93952 жыл бұрын

    I wish you were talking about absolute and relative in the table

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    You can learn about absolute and relative references for tables here: www.myonlinetraininghub.com/excel-table-absolute-structured-references

  • @daniyalbaghi9395

    @daniyalbaghi9395

    2 жыл бұрын

    @@MyOnlineTrainingHub Thank you dear teacher

  • @daniyalbaghi9395

    @daniyalbaghi9395

    2 жыл бұрын

    @@MyOnlineTrainingHub It was great, thank you very much

  • @wavynomad
    @wavynomad2 жыл бұрын

    I throw EVERYTHING in named tables now!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Great to hear 😊

  • @neilwalker4277
    @neilwalker42774 жыл бұрын

    Good video, but while it shows you can make pivot tables and data in input slightly better, it doesn't answer any of the reasons for using tables, such as when or why to use tables. For example, are calculations faster, does the file size increase, what does it provide that a range with filters, etc cannot, does it add to the data model, ie why would we use or not use a table?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thanks for the feedback, Neil. This is just the first video in my Excel Tables course that goes into a lot more detail: www.myonlinetraininghub.com/excel-tables-course

  • @tu4nduc
    @tu4nduc2 жыл бұрын

    5:20

  • @redangrybird7564
    @redangrybird7564 Жыл бұрын

    😮👍

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    🙏

  • @saravananm718
    @saravananm718 Жыл бұрын

    how to remove the table creater

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Not sure what you mean by remove the table creator?

  • @hsstarmotive4683
    @hsstarmotive46832 жыл бұрын

    So different your.'s

  • @usmaniqbal1836
    @usmaniqbal18362 жыл бұрын

    Please share excel file..

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Hi Usman, that file is part of my Excel Tables course: www.myonlinetraininghub.com/excel-tables-course

  • @johannesmp3
    @johannesmp38 ай бұрын

    If this were true, I would have a job within 3 weeks as opposed to...... Lol. Great vid

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    8 ай бұрын

    Thanks! That 1% stat came from Microsoft's telemetry. Maybe it's 2% now 😉 good luck with your job search.

  • @johannesmp3

    @johannesmp3

    8 ай бұрын

    @@MyOnlineTrainingHub thx, but I have one for 5 years now. I could have got one much sooner if this were true

  • @martinAbC
    @martinAbC Жыл бұрын

    Employee E038 is getting only 31k at 56 years-old, that's mean

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    😁 they’re semi retired, so don’t feel bad for them! 😉

  • @cooljoker2027
    @cooljoker2027 Жыл бұрын

    i dont use it becuase is shit when i add data to table doesnt referch and let it out from the table is oke usefull for analysis a data but now useful to track sales or trading journal u cant make it it as a template is totaly shit

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Sounds like you need some help setting up your file properly. Feel free to seek help from our experts on our forum: www.myonlinetraininghub.com/excel-forum

  • @wandagreer9144
    @wandagreer9144 Жыл бұрын

    This "old dog" is having trouble learning "new tricks". Just me I reckon. Have a table with 70 columns and 910 rows. No matter what I do, I cannot seem to enter a column on the far right of the table. Cannot cur/copy/paste either. Feeling defeated.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    hmmm, that's odd. Have you tried editing the table range to include a new column?

  • @wandagreer9144

    @wandagreer9144

    Жыл бұрын

    @@MyOnlineTrainingHub Thanks for the idea - will try that.

  • @imthatnggruponthatnag7784
    @imthatnggruponthatnag77843 ай бұрын

    I overuse them. : )

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 ай бұрын

    Not possible 😂

  • @odinata
    @odinata3 жыл бұрын

    You start off saying no one uses tables. Then you say "if your table has headers" How do we know if our table has headers? You haven't even told us what a table is...much less what a table header is. SMH

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    As with all tutorials, there's an expectation that you have some prior knowledge of Excel, however as you are completely new to Excel you're missing some of that. To fill in some gaps in your knowledge; headers are column labels. In the video example they are Employee ID, Date Started, Age, Gender and Salary. A table is just a formal structure you give to your data that allows Excel to reference the data, among other things, as shown in the video. Hope that clarifies things.

  • @odinata

    @odinata

    3 жыл бұрын

    @@MyOnlineTrainingHub I was just wondering what a table is, why I would want to use one, whats different from regule Excel.....I guess I just don't get it. I'm googling it right now, but no one really seems to be able to tell me what they are for. Maybe thats why 99% of excel users don't use them......

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    A table is a (smart) format you apply to your data. It allows Excel to recognise and reference your data using the table's name and structured references, as I showed in the video. It's far easier to reference the cells and columns of a table using names than cell references like A11, G2:G99 etc. It also has other built in features like automatically copying formulas down to new rows, Grand Totals and more. However, probably the most important reason for formatting your data in a table is that as you add more data to your table you don't need to update any references to the table that you made in formulas to include the new data as it will automatically be included in the table range. You don't have those features available if you don't format your data in a table.

  • @odinata

    @odinata

    3 жыл бұрын

    @@MyOnlineTrainingHub I just wonder why I would need to, if 99% of people don't think they need to. I'm new to Excel and I need to know if it applies to my use case.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    It's not that 99% of people don't think they need to, it's that 99% of people haven't heard about tables and don't know what they're missing. Most people are self taught. They don't know what they don't know. They're missing out on these amazing tools that make our Excel lives easy. I'm just trying to spread the word and help more people get their work done more efficiently.

  • @UncleGwendolyn
    @UncleGwendolyn4 ай бұрын

    Is it feasible for reference tables to automatically update prior to my dataset referencing them?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 ай бұрын

    Not sure what you mean by a reference table vs a dataset exactly, but if you're referencing anything in a formula, then the formula will automatically update when the data it's referencing changes.

  • @UncleGwendolyn

    @UncleGwendolyn

    4 ай бұрын

    @@MyOnlineTrainingHub Not gonna lie, I can't recall what I meant either. The wonders of drink!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 ай бұрын

    😂

Келесі