How does one review workpapers with these complex excel formulas?

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

Arixel Explorer

likehelpful

And I spelled it incorrectly, Arixcel Explorer

like

Evaluate Formula. Most long formulas are just smaller formulas strung together. Mathematically, it’s similar to a solving system of equations. Plug it in.

like

If it’s a smaller formula, using Ctrl + [ will help you trace the cells that make up the formula

like

do ^^^ first for a test of one then do "show formulas" and use F2 + enter to make sure the formulas don't have a hidden hardkey. (works best when dataset is 10-200 lines.. otherwise inefficient)

like

I open the file in 3 windows to trace the most significant numbers. Also it’s important to have a reconciliation tab

Related Posts

How do you get out of the burnout cycle? I’ve felt overwhelmed for a while and now I’m in the “can’t function at all” stage. It’s so hard explaining this to my manager because I already have a workload that’s lighter than others (not because of performance or my request). Any tips on how to get re-engaged, since the overwhelming feeling will come back?

like
like

710 GMAT vs 327 GRE, which is better?
Is it true that adcoms are more forgiving of lower gre scores than gmat as they don't have to report it?

like

Just set a phone screen with a recruiter from Asana for a strategy analyst role… anyone here have a sense of what the general hiring process looks like for that? I see something about a take home case on Glassdoor, but I can’t find much more.

helpful

Do you guys think that schools maybe middle/high school should teach economics/investing early on? There is software out there that will let you place hypothetical bets and will follow the markets real time. Get the next generation to be more financially savvy and get them to be familiar with etfs/options/stocks and market cycles.

like

A creative team I started working with recently has decided to ignore my every comment. They take feedback from anyone else but me, and whenever I push them to make said changes, they just pick fights and make snarky comments. Anyone have any idea why this might be?

like

My old agency is soon going to be releasing work that was originally my art director and my idea - got laid off during COVID. It probably has changed since we left, but can we still ask to have our names on the project?

like

AOA everyone! I am a Pakistani currently living in Germany. I am in the final stages of getting a transfer to Canada but can’t decide between Toronto or Vancouver. Both have high COL so I’m trying to weigh the pros and cons. I know Vancouver’s weather is a lot better than Toronto, but any recommendations from Canadians on the bowl?

like

Any interview tips for a program manager PSO role at meta? You can DM me also. I would appreciate your help!

like

My medication (adderall) occasionally makes me very angry.

Any thoughts on how to combat this? Doesn’t happen all the time, but there are a good number of times where I snap over something that probably isn’t too serious

like

Wow, SAVA! Was anyone in it before the spike? Wondering about strategies behind these biotech plays. Seems like you’re playing roulette on results of approvals?

like

Best consulting companies for Healthcare related projects ?

Hi Guys,
How much can I ask for associate consultant Role
Tech Stack : Salesforce
YOE : 2.2 yrs
Ctc: 4.5

Is Associate consultant role inline with my YOE?

like

I am working as a backend developer with 8+ years of experience in .Net. Can someone please suggest any hands on courses for cloud technologies.P.S.- I do not have any exposure to cloud technologies.

How much should a person with a Masters in pharm/tox expect to make?

What is a good pay range for a senior IT auditor in a T2 city, 2 yoe.

like

Started my first job in advertising in paid social, but brand strategy is still my goal. Any advice or tips on how I can steer myself towards that direction?

like

My Last working date at Wipro is 12th of june 2022, So How tax will be calculated for the financial year 2022-2023. My CTC is 8.4L
I will be working only 3 months for this financial year and in April month payslip i can see 6K deducted for tax and in the IT projection it shows around 30k tax deduction gonna happen. I will be joining another Firm in same june month
Please share how tax is calculated in my case and how to save taxes.

Any recommendations on best travel sites to book a blue grotto tour and/or lake Capri boat tour??

1) any good individual therapist recs in LA? East side preferable but any good recs appreciated. 2) any good accountants? Moved to LA during pandemic so don’t know any. Anyone who’s good at working w folks w multi state situations would be great. Thanks!!

like

Additional Posts in Excel Genius

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

Hey, tips for where to look for good excel cheat sheets online? :)

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Is there a way to simultaneously merge spreadsheets (or workbooks) and decide which columns/rows to update without a third party tool?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

What are the most typical models you all build

likehelpful

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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