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.
@MyOnlineTrainingHub3 жыл бұрын
So pleased to hear I can help, Jimmy! Thanks for sharing our channel, too 😊
@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 kzbin.info/www/bejne/fpXZnXRuosmZjdU
@THE_REAL_HAUTE_CRE10 ай бұрын
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!
@MyOnlineTrainingHub10 ай бұрын
Awesome to hear!
@PrasadCPerera7 ай бұрын
Dear Mynda, Your Excel tutorials are absolutely brilliant. To be honest, I started with a few different KZbin 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.
@darcyg8523 жыл бұрын
Excellent as always!
@MyOnlineTrainingHub3 жыл бұрын
Glad you think so, Darcy!
@sanjitpaul29533 жыл бұрын
Excellent video Ma'am. Learned a lot. Thank you.
@MyOnlineTrainingHub3 жыл бұрын
My pleasure 😊
@MANI8835 Жыл бұрын
Great tutorial. I have learn lot from it
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@daniyalbaghi93952 жыл бұрын
Thanks very good
@MyOnlineTrainingHub2 жыл бұрын
So nice of you :-)
@Sbihis83 Жыл бұрын
Hello , thanks for your video is there some special feature in Excel Tables for conditional formating ? thanks
@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.
@Nicole-lc6gt4 жыл бұрын
This is the best tutorial I have seen on excel tables, thank you.
@MyOnlineTrainingHub4 жыл бұрын
Glad it was helpful, Nicole!
@JJ_TheGreat2 жыл бұрын
Are there any disadvantages of using tables? Thanks.
@MyOnlineTrainingHub2 жыл бұрын
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.
@arturoguzman52303 жыл бұрын
Simple but great 😍
@MyOnlineTrainingHub3 жыл бұрын
Thank you! 😊
@kangsungho17524 жыл бұрын
Simple and essential lesson as alwsys! But I do stll prefer range to table. Range is easy to manipulate for me.^^
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Kang. Sometimes habits are hard to break :-)
@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 Жыл бұрын
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
@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)
@MyOnlineTrainingHub3 жыл бұрын
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.
@yaroslav28893 жыл бұрын
@@MyOnlineTrainingHub It is Office 2013. You can filter table even when it affects rows where table exists?
@yaroslav28893 жыл бұрын
@@MyOnlineTrainingHub shortcuts: for example, I can't use Alt+4 shortcut to filter out by a current selection comparing to usual data range
@shakiraasfoor75994 жыл бұрын
Well Done
@MyOnlineTrainingHub4 жыл бұрын
Hope you can make use of Tables, Shakira.
@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.
@MyOnlineTrainingHub2 жыл бұрын
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.
@alishankarimov10 ай бұрын
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.
@MyOnlineTrainingHub10 ай бұрын
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.
@alishankarimov10 ай бұрын
@@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?
@barrycole59303 ай бұрын
@@alishankarimovbe bold…change the structure of the work 😉
@forestdamian56012 ай бұрын
HI . When I want to make a simple table, it appears with headers even if I don't put a comma in the box. What can i do? I also have pictures if you think you can help me. Thank you
@MyOnlineTrainingHub2 ай бұрын
All tables must have headers. You either enter your own column headers or use the default 'Column1' etc. You can type over the default headers to insert your own. You can now insert pictures in cells with 365, if that's what you mean.
@forestdamian56012 ай бұрын
@@MyOnlineTrainingHub I can send you some pictures so you can understand exactly what it is about
@MyOnlineTrainingHubАй бұрын
Sure. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@saravananm7182 жыл бұрын
in table creater., some times Vlookup formula not using ., how to solve ., ?
@MyOnlineTrainingHub2 жыл бұрын
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@saravananm7182 жыл бұрын
how to remove the table creater
@MyOnlineTrainingHub2 жыл бұрын
Not sure what you mean by remove the table creator?
@redangrybird7564 Жыл бұрын
😮👍
@MyOnlineTrainingHub Жыл бұрын
🙏
@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
@MyOnlineTrainingHub4 жыл бұрын
So pleased you discovered some new things about Excel Tables :-)
@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 Жыл бұрын
Great to hear you're a Tables fan!
@fredreid82655 жыл бұрын
Hi Mynda, i really appreciate your video's and no fuss training style.Thank you for sharing your content. Fred
@MyOnlineTrainingHub5 жыл бұрын
Thanks for your kind words, Fred :-) glad you find the videos helpful.
@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 👍
@MyOnlineTrainingHub2 жыл бұрын
Thanks for spreading the word 😊
@clair91673 күн бұрын
👍🏼Excellent training video! Perfect pace and very clear instructions. Thank you!
@MyOnlineTrainingHub3 күн бұрын
Thanks so much!
@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?
@MyOnlineTrainingHub2 жыл бұрын
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
@phorton9683 жыл бұрын
Excellent KZbin. Just what I was looking for - easy to follow. Your narration is professional and concise. Thank you!
@MyOnlineTrainingHub3 жыл бұрын
Glad it was helpful!
@radu05053 жыл бұрын
!!!!!!!!!!!!!!!!!!!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????
@MyOnlineTrainingHub3 жыл бұрын
You'd need to write some VBA code to make this happen.
@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 Жыл бұрын
Nice! Thanks for sharing.
@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 Жыл бұрын
Yes, you an insert screenshots or even the table itself into PowerPoint.
@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 Жыл бұрын
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.
@TVSCDN2 жыл бұрын
Superb ❤️❤️❤️👍🎉 thanks madam a million 🙏😀
@MyOnlineTrainingHub2 жыл бұрын
My pleasure 😊
@FawziahAbbas Жыл бұрын
Hello, Thank you for your great videos, I have learned a lot form you.
@MyOnlineTrainingHub Жыл бұрын
Glad to hear that!
@martinAbC Жыл бұрын
Employee E038 is getting only 31k at 56 years-old, that's mean
@MyOnlineTrainingHub Жыл бұрын
😁 they’re semi retired, so don’t feel bad for them! 😉
@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 Жыл бұрын
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
@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.
@MyOnlineTrainingHub5 жыл бұрын
Thanks, Zahir. If you want more frequent content then write a weekly blog on Excel here: www.myonlinetraininghub.com/blog
@wavynomad2 жыл бұрын
I throw EVERYTHING in named tables now!
@MyOnlineTrainingHub2 жыл бұрын
Great to hear 😊
@neilgore2 жыл бұрын
Slicers in tables .. just learned of it after 20+ years of excel usage
@MyOnlineTrainingHub2 жыл бұрын
Better late than never, Neil 😊
@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
@MyOnlineTrainingHub2 жыл бұрын
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: kzbin.info/www/bejne/emWXdneXo9ljqNU
@JoaoDuarte-cj9xi Жыл бұрын
Can you add new lines to this table if you protect the worksheet?
@MyOnlineTrainingHub Жыл бұрын
No. Tables cannot be edited in protected worksheets.
@johannesmp310 ай бұрын
If this were true, I would have a job within 3 weeks as opposed to...... Lol. Great vid
@MyOnlineTrainingHub10 ай бұрын
Thanks! That 1% stat came from Microsoft's telemetry. Maybe it's 2% now 😉 good luck with your job search.
@johannesmp310 ай бұрын
@@MyOnlineTrainingHub thx, but I have one for 5 years now. I could have got one much sooner if this were true
@charlie63-p2u11 ай бұрын
Hi there - I created the table but the header row content does not display ?? The info is there but not displayed
@MyOnlineTrainingHub11 ай бұрын
Go to the Table Design tab > in the 'Table Style Options' check the box for 'header row'.
@charlie63-p2u11 ай бұрын
@@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.
@janith582910 ай бұрын
Can add dynamic serial number to the tables?
@MyOnlineTrainingHub10 ай бұрын
Can't see why not 😊
@hsstarmotive46832 жыл бұрын
So different your.'s
@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.
@MyOnlineTrainingHub3 жыл бұрын
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.
@tu4nduc2 жыл бұрын
5:20
@mastergeo300611 ай бұрын
Is there a way to automatically keep a formula from the above cell as you add in a new row into your table?
@MyOnlineTrainingHub11 ай бұрын
As long as all formulas above are the same, the formula will automatically be copied down to new rows.
@mastergeo300611 ай бұрын
@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.
@mastergeo300611 ай бұрын
@@MyOnlineTrainingHub I figured it out, there was a square with FX on it, saying AutoCorrect options after clicking that it started to copy down.
@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
@MyOnlineTrainingHub3 жыл бұрын
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
@TheWid5 жыл бұрын
Really clear and will be really useful; thanks.
@MyOnlineTrainingHub5 жыл бұрын
Glad you liked it, Tony.
@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!
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Mark! Glad you found this tutorial helpful :-)
@luisfevel Жыл бұрын
Thank you for this tutorial! It refreshed my mind on Tables! Ps. I added you on Linkedin.
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@The-Right-is-Right2 жыл бұрын
Would have been helpful if you'd included a link to the spreadsheet so we can download it and follow along...
@MyOnlineTrainingHub2 жыл бұрын
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
@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.
@MyOnlineTrainingHub3 жыл бұрын
Great to hear, Irene. Tables are perfect for this purpose.
@joycep3463 Жыл бұрын
I have looked at many, many excel youtubes. YOU are the BEST! thank you for doing all these.
@MyOnlineTrainingHub Жыл бұрын
Wow, thank you so much, Joyce!
@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?
@MyOnlineTrainingHub4 жыл бұрын
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
@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?
@MyOnlineTrainingHub2 жыл бұрын
Hi Mark, you could use the FILTER function to do this: kzbin.info/www/bejne/kHS0cqqbpKaXhdk
@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 Жыл бұрын
hmmm, that's odd. Have you tried editing the table range to include a new column?
@wandagreer9144 Жыл бұрын
@@MyOnlineTrainingHub Thanks for the idea - will try that.
@ahmad1xa Жыл бұрын
Great tutorial! Thank you very much for sharing your experience with us, appreciate it 🙏🏻
@MyOnlineTrainingHub Жыл бұрын
My pleasure 😊
@Space-O-20013 жыл бұрын
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!
@MyOnlineTrainingHub3 жыл бұрын
Glad I could help!
@daniyalbaghi93952 жыл бұрын
I wish you were talking about absolute and relative in the table
@MyOnlineTrainingHub2 жыл бұрын
You can learn about absolute and relative references for tables here: www.myonlinetraininghub.com/excel-table-absolute-structured-references
@daniyalbaghi93952 жыл бұрын
@@MyOnlineTrainingHub Thank you dear teacher
@daniyalbaghi93952 жыл бұрын
@@MyOnlineTrainingHub It was great, thank you very much
@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.
@MyOnlineTrainingHub3 жыл бұрын
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
@thehank53683 жыл бұрын
@@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!
@khalidarafat7482 Жыл бұрын
شكرا لك
@MyOnlineTrainingHub Жыл бұрын
My pleasure 😊
@lastboomerstanding47 Жыл бұрын
Nice to have mentioned pivot tables assuming we all know how to build them
@MyOnlineTrainingHub Жыл бұрын
Here's my introduction to PivotTables tutorial: kzbin.info/www/bejne/rILPd5yCisaqas0
@POliveira11 Жыл бұрын
Well presented. Clear. Consistent vocabulary. Well-paced words and sentences. Clear voice.
@MyOnlineTrainingHub Жыл бұрын
Thanks for your kind words!
@imthatnggruponthatnag77845 ай бұрын
I overuse them. : )
@MyOnlineTrainingHub5 ай бұрын
Not possible 😂
@zonanagon97643 жыл бұрын
You are awesome! Simple and informative. Thank you and stay healthy 💪🏼.
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it, Jin 😊
@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
@MyOnlineTrainingHub3 жыл бұрын
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.
@williamstan17803 жыл бұрын
@@MyOnlineTrainingHub Tks... It is helpful... Appreciated
@shoppersdream7 ай бұрын
Nice, thanks!
@MyOnlineTrainingHub7 ай бұрын
Our pleasure!
@NamLamH6 жыл бұрын
Great, love your seminar :D
@MyOnlineTrainingHub6 жыл бұрын
Thank you :-)
@SeanMClarke2 жыл бұрын
Really nice tutorial and very well explained - thank you so much Mynda
@MyOnlineTrainingHub2 жыл бұрын
You are so welcome!
@usmaniqbal18362 жыл бұрын
Please share excel file..
@MyOnlineTrainingHub2 жыл бұрын
Hi Usman, that file is part of my Excel Tables course: www.myonlinetraininghub.com/excel-tables-course
@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
@MyOnlineTrainingHub3 жыл бұрын
So pleased to hear you're a Table convert now :-)
@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.
@MyOnlineTrainingHub3 жыл бұрын
Excel could never be boring, Pat :-D Glad you're enjoying it now.
@342crazy666Ай бұрын
Which jobs that involve lots of excel work?
@stephenyoung39173 жыл бұрын
Hello, where can I find a copy of this excel worksheet?
@MyOnlineTrainingHub3 жыл бұрын
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
@anindadatta1646 ай бұрын
very useful
@MyOnlineTrainingHub6 ай бұрын
Glad to hear that 🙏😊
@muhammadyar7328 Жыл бұрын
very very useful
@MyOnlineTrainingHub Жыл бұрын
Glad to hear that 😊
@tommyharris58172 жыл бұрын
Great tutorial; I would like to see advanced filtering in tables
@MyOnlineTrainingHub2 жыл бұрын
Thanks for the suggestion, Tommy.
@ianodonoghue60112 жыл бұрын
Excellent video as always thanks for all the great work you do
@MyOnlineTrainingHub2 жыл бұрын
So nice of you, Ian :-)
@tajumir48 Жыл бұрын
Amazing ❤❤❤
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it!
@kashifafridi95322 жыл бұрын
Thank you
@MyOnlineTrainingHub2 жыл бұрын
Welcome!
@kianoushramezanishabolaghi43262 жыл бұрын
excellent
@MyOnlineTrainingHub2 жыл бұрын
Thank you!
@dshankarwrites6 жыл бұрын
Excellent
@MyOnlineTrainingHub6 жыл бұрын
Thanks, Shankar. Have fun with Tables.
@truewiking2 жыл бұрын
I learned a lot here, Thank you very much
@MyOnlineTrainingHub2 жыл бұрын
Glad it was helpful!
@ambudhimanchanda10364 жыл бұрын
Can you share a video on waterfall chart?
@MyOnlineTrainingHub4 жыл бұрын
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
@kaihsinchu73345 жыл бұрын
Excellent video! I have used Excel for many years and never really know Table can be so helpful and easy to use!
@MyOnlineTrainingHub5 жыл бұрын
So glad you're now interested to use Tables now. They certainly are a huge help.
@praveenk16724 жыл бұрын
Is it possible to merge table headers Mam?
@MyOnlineTrainingHub4 жыл бұрын
Yes, when you merge columns the headers also get merged.
@m1cannas3 жыл бұрын
Amazing knowledge. Super.
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Mario!
@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
@MyOnlineTrainingHub3 жыл бұрын
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.
@odinata3 жыл бұрын
@@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......
@MyOnlineTrainingHub3 жыл бұрын
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.
@odinata3 жыл бұрын
@@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.
@MyOnlineTrainingHub3 жыл бұрын
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.
@saremammar92463 жыл бұрын
Like it. Thank you 😊
@MyOnlineTrainingHub3 жыл бұрын
Great to hear :-)
@andydidyouhear2 жыл бұрын
Excellent video!
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much 🙏
@MrNitKap3 жыл бұрын
👍thanks
@MyOnlineTrainingHub3 жыл бұрын
Welcome 👍
@UncleGwendolyn6 ай бұрын
Is it feasible for reference tables to automatically update prior to my dataset referencing them?
@MyOnlineTrainingHub6 ай бұрын
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.
@UncleGwendolyn6 ай бұрын
@@MyOnlineTrainingHub Not gonna lie, I can't recall what I meant either. The wonders of drink!