HELP, I need to create an expense report - I know exactly what is needed and how the design should look.
however, I'm basic intermediate when it comes to formulas. if someone could please assist me or if you have one that you could share?

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

If you would like further assistance, feel free to DM me and describe what your sheet should look like. I’m sure I could whip something up for you.

like

I just sent you a message, but if you can’t find it, feel free to put some more details here and I can try to help.

like

Just Google expense report template or find an existing Excel template when you create a new Excel worksheet.

Thank you

Related Posts

Europe!
What is reasonable salary growth coefficient when going from FTE to consultant?
My current reasoning is 2x as
* We get 100% parental leave for 6 months in current company
* Risk mitigation

I have never been a consultant before, what other factors should one consider?

like

How is the City account in Wipro ?

like

I can’t keep up with the pace of consulting. Is there something wrong with me? Is there room in this world for someone who just wants to slow down?

like

I have my offer interview scheduled for next week at EPAM Anywhere . The duration is of 1 hour.
I wonder what happens in this interview that it takes an hour to do. Can anyone share their experience?

like

Protocol for responding (or not) to unsolicited emails from recruiters to your work email? In other words, is it acceptable to just ignore without a response? Or do you prefer to keep the line open with a brief “thanks for thinking of me, I am not interested at this time but hope we can collaborate in the future.”

like

Anyone here in Amsterdam or know their salary range for a Exec Producer level role? I’m in NYC now - I assume I’ll take a HUGE pay cut. But how much? 🤔

like

Does anyone have a tool/ site that calculates what the offer would need to be to leave a current role, all things considered? Of course, it’s anything more than you’re making now, but I’m looking for something that accounts for LTE, the hassle, risk, etc.

like

Zscaler offered me position in Amsterdam for senior Qa. Offering 85k base pay and 20k equity for 4 years. I am 12 year experienced, feel lowballed with the offer.
How much can be negotiated here, what would be a good number to check with HR team?

How do married folks manage finances ..keep them separate or everything common? Have heard married people splitting rent and stuff and not sure I fully understand how common are situations like that.

like

🏆🏆🏆🏆 🇦🇷 vs 🇫🇷🏆🏆🏆🏆

like

Has anybody had any luck with flexible work arrangement (FWA)? I am looking to eventually be part time but still remain on higher level projects. Has anybody had luck at any other firms?

Which one would you pick?

Big name shop. Shitty account, but you get opportunities beyond that.

Shop with bad reputation that lacks PR and hardly enters awards but has a lot of book-worthy projects.

like

Hi 🐠,

I have recently joined Infosys and they have put me in a project where I will be the only guy working in the team and the team lead is at the onsite location. Are such projects good? Because I haven’t worked like this anywhere before.

TIA :)

like

does wipro release offer letter 1week before LWD, I called up HR many times, she is telling they will release final offer 1 week before LWD

like

Let's have a poll on our current work setup!
It's about your current work setup and not about your preferences.

Post Photo
helpfulfunnylikeupliftingsmart

Anybody who recently upskilled from non coding background to a MEAN or MERN stack ? Need guidance

like

Is it just me or is the YouGov Profiles tool completely unintuitive to use?

likefunny

Do travel bans apply from where I originate from or from where my flight is from? For example, I am travelling to Spain and hopefully Amsterdam in May. When I fly to Amsterdam, am I considered traveling from Spain or US for travel restrictions?

like

Does anyone working in Skillsoft? please share your experience

like

What are top firms for a Real Estate practice? Chicago mainly

like

Additional Posts in Excel Genius

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

Would anyone be willing to teach me vlookup?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

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!

Anyone know what these badges are?

Post Photo
likefunny

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

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

Post Photo
likehelpful

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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.

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

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

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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