Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

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

Everything that you can do in the 2013 version you can do in the 365 version, relax.

There are a couple of useful formulas and features in the 365 version tho

like

Maxifs, ministro, unique, Xlookup, Ifs (finally nested IF)

These are the ones in top of my head

like

Apparently xlookup is better than Index Match, but I still haven’t had a chance to use it because I’m worried about compatibility for clients.

like

Maxifs, ministro, unique, Xlookup, Ifs (finally nested IF)

These are the ones in top of my head

like

You have dynamic arrays formula that are really convenient in office 365 have a look at them they do in one step what would normally take extra ones. There is a good course from Leila Gharani on this surely you have access with some of your firm knowledge.

Filter, unique ...
If you were already used to index match match or these kind of combinations the new x lookup will not change much for you

Related Posts

Still haven’t been able to get ahold of the Larceny barrel proof, so settling for the Maker’s Cask Strength tonight 🥃

Post Photo
like

Chatter about a recession have anyone considering obtaining an additional job?

like

Hi all,

How many days will it take to allocate Bosch laptop for new lateral joinees?

like

If anyone (non EY) wants some referral money, I am looking for a job. Have 1yo in EYs Technology Risk Advisory practice and Gold Standard reviews. Also speak 3 languages but I don't think it matters.

like

Has an tested roles for SAP through productive test simulation within production? Is there any risk doing this as the test is in production?

like

I am a new joinee in JPMC. Can anyone please let me know what are the ratings system
Like
1 - Exceed Expectation
2 - Above Expectation
3 - Meeting Expectation

And also I have joined in Mid April. Am I eligible for Salary increment, Bonus and CEO Bonus? What is the minimum% hike we can expect.

like

Does anyone have suggestions for what a salary should be for a Digital Marketing Analyst | Paid Social & Performance Media? I have 1 year of experience, the job asks for 0-1 year of experience. I feel I over meet the qualifications in some areas and just meet them in others. The recruiter said 50k is the salary the company is offer. I know I can negotiate. What are your thoughts on what the salary should be?

like

Can you give like so that I can DM someone

likesmart
like

Has anyone quit without backup offer? Did you regret doing so?

like

How long did you guys study for The new cissp exam , and how are the questions like on the exam

like

Hello Everyone,

I have been working with Kantar (a market research company) for 10 months now. The company has given me permanent work from home. Work is quite good and I am able to learn many things here. Also, my manager is very supportive and patient.
The only thing is about compensation, I have a package of 14 lpa with 6 YOE.
I'm thinking of switching to some company based in Pune.
What should I do?

like

Talked to an M1 in Deal Advisory (FDD/AAS) that makes $110K in HCOL. Does that seem low/high/in-line with what you would expect?

like

Newly promoted M1. Transaction advisory services (FDD). Seattle.


Am I off base to expect $115-120k? Given how crazy M&A market is and demand for staff

like

How is John St these days for accounts?

like

It’s only Wednesday. 🤬

Post Photo
likefunny

Anyone here from IQVIA that have had their green card sponsorship done here? What was your timeline like?

like

What are ways I can spend my $200 airline credit for the Amex platinum ? I saw upgrades don’t count and I have status so already get free baggage, lounge etc.

like

Going to London in 2 weeks! Unfortunately the news was heartbreaking about the Queen and it’s still being talked about of course.

Should I still go on with this trip or should I exchange for a different date because I don’t know what else could happen during this trip? Maybe I’m overreacting :/

likefunny

Additional Posts in Excel Genius

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

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

like

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

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

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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

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.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

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

like

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

How do I compare two sheets to make sure they are identical?

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

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

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

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

Post Photo
likehelpful

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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