I'm going to have to use Google Sheets for a client. It's my first time. Is it pretty much the same as Excel or am I going to face a steep learning curve?

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

It’s pretty much the same, it doesn’t have as many formulas and advanced features as excel but it has all the basic stuff you’ll probably need and what it has works the same.

like

Leave the client

likefunny

Lol

The basic use is very similar: same formulas, similar actions possible (filter, sort, pivot tables,…)

There are notable differences though, here is a short list:
* Google adds some extra functions that are very useful such as QUERY, IMPORTXML or GOOGLEFINANCE, GOOGLETRANSLATE
* VBA is replaced with google apps script which is based on JavaScript
* the charts in google sheet are much less flexible
* speed and capacity is much less on google sheet
* google sheets is much better to share / cowork on one spreadsheet: you can comment,
* also there is version control

Related Posts

What to do when manager is not approving leaves because of an important project but leaves are expiring in year end

like

I got an offer from teksystems India for hpe client. My question is what will happen if someday HPE don't want us to work for them anymore or maybe project development ends...so will teksystems move us to different client within 2 month (as they say) or will they fire us?

Secondly how is tbe appraisal cycle at teksystems India? How are the benefits?

like

How are Ogilvy and McGarry Bowen these days, creative wise, client retention, good “place” to work, work-life balance, etc.?

like

My client wants both parties to list assets & liabilities as an exhibit to their prenup without values, but waive the right to know the actual valuation of those in the prenup itself. My initial thought is this is a terrible idea & would probably make the prenup easily voidable since a main requirement for a prenup is for both to understand the nature and value of the other’s assets. I will research in my jurisdiction to confirm, but has anyone ever heard of/done this? Thoughts?

like

How are the client interviews here in Globant?

How long does is usually take to get staffed on the first project? Joined 11/15 and still no project... Fyi, I am in the commercial side. Should I be worried? Ive contacted my RM couple times and am reaching out to my network 😢

like

I want to be a client instead of an investment banker. Where do I sign up?

likefunny

I am looking to get a referral to a Fintech company! Preferably in operations or project management.

like

Lol a client just emailed saying they want to sign a $1.5bn deal (we are sell side) not at some point before or by, but rather ON CHRISTMAS DAY.

What the hell is wrong with people?

likefunny

Interesting all the noise about these PPT, my take:

The pandemic took all the upside of an IB analyst life (client meetings in person, fancy trips, suit up, worshiped at networking events) and left all the juniors with the downside (long hours, monkey-like type of job, aggressive work environment).

Not that the complaints are not sort of legitimate but you may need to revise the decision-making process that led you to accept a return offer. Specially if you were looking for less hours.

like

Just FYI, if you ever miss an issue in an agreement that you don’t catch until late in the deal process, don’t try to blame it on the other side to your client. You’ll get caught.

likehelpful

Looking to transition into an HR leadership position. 17+ years experience in running a startup managing 50-100 people (15 years) and handled all facets of hiring, firing, compensation, negotiation, training and employee relations. Responsibilities also include other non HR functions such as business dev., client relations and expansion, logistics. Currently studying for the SPHR and plan to take the GPHR as well. Thoughts on difficulty of moving into an HR leadership role?

like

Are you new to project management / you want to know what next step to take when pivoting into project management? Please drop your questions in the comment section.

Post Photo
like

Job Opening

Job Title - Project Coordinator

Only W2 Candidates (No C2C)
Locations - Charlotte, NC; Minneapolis, MN; Des Moines, IA; Chandler, AZ; & Antonio, TX
Hybrid Model ( 3 days onsite & 2 days remote)

Industry - Banking / Finance ( Wells Fargo )

like

Hey guys, so I am currently a business project coordinator. I am looking for new endeavors due to management changes. Have my MBA in project management, however still young and lack the required experiences. Having a hard time landing interviews, what should I be searching to apply for? Does anyone have any referrals or tips for someone just starting out? Anything helps, thanks!

like

Looking for some advice here: I work for a client that loves me & I love him back as well. Get along super well with the creative team and we’re like “one team” . However, I am having problems with the management of my agency. I thought of maybe talking with my client about it (the CMO) to see if he pressures the account MDs. Any tips on how to solve this situation?

like

Do you feel that in SEO there are too many ways of conducting the same tasks. I have had a string of managers within the past year, it’s starting to get very annoying as each person says method A is wrong and B is right, another manager would have the complete opposite view. Have you had similar experiences when this practice and adjustment begins to interfere with client deliverables.

like

Hi guys I am posting this again I have offer of almost same package from Accenture and IBM . Accenture offering is very slight more but that's not my key consideration. Which company is better in terms of job security, work life balance. That's the top most factor I am considering. Learning and project and latest niche technology is the other important factor after first 2 factors .

like
like

Tiger Analytics has started firing their new joineers(freshers) as they don't have adequate projects. I don't know where the freshers will go as they haven't done any project as such.

This is just pathetic from organization. They are just firing people owing to failing a test of certification, for which other company gives 3 trials but they are giving only one try with negative markings

like

More Posts

I currently work at Amazon as an SDE, am I allowed to start an Amazon FBA business?

like

How long does is usually take to get staffed on the first project? Joined 11/15 and still no project... Fyi, I am in the commercial side. Should I be worried? Ive contacted my RM couple times and am reaching out to my network 😢

like
like

Hi, My current CTC in Accenture is 14.5LPA and Total years of experience is 9yrs. Thinking about job change. How much CTC I should ask for the next company for 9yrs of experience.

like

Can we get work permit to Canada without job ?

likefunny

@Amadeus @Netcracker @TCS @CTS What would be Hand Salary for 35LPA Fixed(Gratuity +Com Contribution to PF Included)??

22- Asked to upload document in ibegin
23- Verified all documents
What next ?
Current status as show below on ibegin

Post Photo
like

So grateful I have my GC and orange cheeto can’t get me now!
F-1 to H-1 to GC to Citizenship ✈️ 🧚🏾
- Brown Tinkerbell

like

Hi everyone,

I have offer from S&P Global as a QA and ZS Associate as a Test Engineer.

Which one is better to join ?

Please suggest that is there any way to ask for counter offer in Capgemini..I have joining in next month..Will they revise the offer letter?Capgemini

like
like

Is there a need for freelance community managers?

like

Is it just me or are behavioral questions really stupid? I always feel like they're either way too open ended or they're asking about something that's never happened to me

like

Anyone volunteering for the Super Bowl? I’m a greeter at the airport.

like

A little late here, but any suggestions/recommendations or watch outs for an automatic standing desk preferably with charging attachments? Looking to invest in a decent one around $2-300 !

like

How long it take from senior2 to Asst. Manager?
Joined in May this year as S2.

like

If a company I got rejected from is posting an opening for the same role should I re-apply? Any chance of a better outcome?

like

Hello Friends, I have 2 questions please help to clarify.

I am joining in CTS on September last week so when i will be considered for appraisal ?

And also for variable compensation I will get in this March right? For this we don't need to wait for a year I guess.

like

Those of you who were furloughed or layed off: are you looking for work now or waiting?

like

How much is the notice period in KPMG india?

Additional Posts in Excel Genius

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

like

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

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)

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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.

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

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!

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

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)

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

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

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

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

Post Photo
likehelpful

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

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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