Introduction to Excel Tables - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Henk-Jan
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.
reply
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.
reply
radu0505
!!!!!!!!!!!!!!!!!!!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????
reply
!!!!!!!!!!!!!!!!!!!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????
reply
IreneH
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.
reply
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.
reply
Nghi
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.
reply
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.
reply
Yaroslav
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)
reply
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)
reply
Neil
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?
reply
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?
reply
Salama
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?
reply
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?
reply
Williams
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
reply
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
reply
Ram
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.
reply
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.
reply
HAL
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!
reply
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!
reply
Add a review, comment
Other channel videos
7:32
