I might expose myself as a non-genius but I've got to ask, what is ever the point of making a table in Excel. I find it annoying and useless.

like
Posting as :
works at
You are currently posting as works at

Ever look at a formula that says Sheet1!$C$2:$C$9 and have absolutely no idea what it's referring to, and now you have to click over to that tab and hunt for those cell references? Tables let me write English like Sales[Sale Date] instead of navigating to a different tab and and click-dragging over what I want, improving both readability and speed.

like

100% agree with Accenture2 and Arup 1. Better formula readability. I can add more data to the bottom of a table and references automatically expand to include it. Formatting updates automatically if I add or remove rows.

And I can add related tables to a data model, making it possible to build pivot tables that draw on data from multiple tables.

Only downside to me is that subtotaling doesn’t work in tables.

Personal reasons:

- Automatic equations, in that one cells equations fills down automatically
- Good-looking formatting

like

well it formats automatically when you update it, one of the most helpful aspects. Also if you’re working with any external tool like PowerBi or Power Automate you need to use tables to add it as a data source.

That isn’t non-genius. That’s the way.

Tables are more trouble than they’re worth.

In some ways, it does seem annoying. However, they come in handy when you want to query various types of data under multiple conditions. They are also useful for data visualization (using pivot tables and charts).

To sum up, if all you want to see is raw data and do not plan on messing around with the data, then tables can be bypassed. If you want to use Excel tools to analyze and visualize the data, then t tables will get the job done much quicker.

Related Posts

Hey Fishes,

Does anyone know any reliable password generator and store application within PWC app store or network?

There is multiple applications and I dont want to strore passwords outside of pwc or in google linked pwc account

like

How can someone find a job localizing marketing content (taking poorly translated material and fixing it up for US consumers)? I've heard that it's a real job but can't find much information about it

like

One of my coworkers thinks she deserves more PTO than it is allowed in our agency because she's "struggling". We all struggle with our own battles but she's being very rude about it. How can we handle this?

like

Hi,
I have 1.9 years of experience in Manual , automation,API and AEM testing. How much package can I ask for?
Thanks in advance

like

I have a younger family member (almost 13) who is very interested in cybersecurity. How can this person learn and grow in a safe manner if he/she isn’t near a city with youth clubs and etc? Idea is to reinforce ethics, but this material is far too advanced for the parents.

like

Hi everyone , I’m trying to build an email template with cross objects. I know that doesn’t work but is there a work around?

like

I am in the process of IVF due to my husband's male factor infertility. I am so grateful for the benefits that EY provides and wanted to know if there is any consideration for reevaluating those benefits? We know that IVF is incredibly expensive and for some of us, having children is a top priority. Does anyone know where or how we can petition for enhanced or shared benefits? I have ideas.

like

Is anyone nervous about the whole Russia situation and how that may affect the market if an actual invasion takes place? Do you think it makes sense to take out investments just until things settle down, or even assuming the fed will increase interest rates? Thoughts?

likesmart

need review on Work life balance and work culture at Bank of America Global Banking and Markets FP&A Projects team, Gurgaon.

Please reply. I need to make a decision.

like

Is anyone a member at the nyc soho house? Is it worth it?

like
like

LTI-Larsen and Toubro Infotech is Hiring for Experience professionals in Oracle. Interested can DM with their Years of Experience and Job Code.

#Oracle #SQl #RPA

Post Photo
like

How much does an entry level Sourcing Specialist earn per year?

like

Hi fishes... I am confused with the below offers.. Can anyone please let me know which company is better to join in terms of wlb and quality of work. Cts - pune - 18 fixed + 70k variable + 1L jb Wipro - Bangalore - 18 fixed + 2L variable + 50k jb Atos - Pune - 20 fixed + 1L variable +1L joining bonus EY - Bangalore - 22 fixed + 3L variable Yoe - 7 years Skill - plsql and Unix shell scripting

like

Anyone work in the Chicago office?

Welcome! Feel free to share any stories about marriage, divorce, other personal issues, etc. This group is to support, and provide POSITIVE advice/feedback to women who might be struggling with a personal issue. Keep it clean, keep it classy, keep it positive. Thanks!

like

Hi,
I am currently working in digital marketing profile with a Germany based magazine company. I have a work ex of 2 years. I am looking forward to move abroad. I am trying to apply for jobs in canada, sweden, Ireland, Germany, not UK since that needs sponsorship.
Can anyone help me on this, what is the right way. I know i have less experience but i want to move out in a young age. I have tried Google jobs and glasdoor so far. I am currently 25 & i think this is a right age for a woman to move

like
like

Who has the best M&A Tax Practice ?

like

Additional Posts in Excel Genius

How long did it take you to become good at excel? Like fast?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Any book recommendations on excel modeling for real world business applications?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Would anyone be willing to teach me vlookup?

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

What are your top Excel ninja tricks? Ones that few people know...

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal