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

Which companies should I join
Impetus - 14 + bonus permanent work form home
British telecom -15+ bonus
YOE - 3yrs
Position - data engineer.

like
like
like

Hello, I want to know what documents required by Kpmg for dependents? KPMG UK
I am from India.
Kindly comment or DM me. I need some suggestions.

like

When leaving as an audit manager, if you’re going to a competitor and they ask you to leave the day you give notice, do they always pay you out the 2 weeks or are you technically fired?

like

Planning to do a PRM or FRM qual. How useful is it to move from Big 4 Risk and reg consulting to industry? Finding it hard to get anything other than non-PM roles

like

Would like to organize events/speaker panels throughout the year, to highlight and empower the latinx group at my agency, are there any ideas or groups I should reach out to to help kick this off?

likehelpful

Hi everyone! I hope you are all safe and well. I am reaching out here as I am getting desperate and feel defeated . Our company had lay offs due to internal restructuring and I was part of it . I have over 13 years of sales experience ranging from B2B to B2C and I am located in Toronto, Canada. My experience ranges from India, USA and Canada. I am looking for an Account Executive or a Customer Success role. Thank you for all your help in advance.
#sales #customersuccess #lookingforwork

like

After you are stealth laid off, other than job search, what do you do? I assume they won’t give you work and even if they do, you can politely decline? How do you feel about you are not progressing anymore and seeing other people progressing in their career? I have no intention to make partner, but still feel a bit stuck not doing that much.

like

All days are work days

Post Photo
likefunny

Just saw Black Panther for the first time - curious to hear perspectives if you all think this movie was actually good or just a good step for diversity?

like

Alright, peoples. Drop them karaoke bar recommendations.

like
likeuplifting

What is the salary range for Service delivery Manager in Kyndryl for band 8?

like

I need help. Anyone have information of being an advanced medical support assistant for veterans affairs? I got offered a job in the SF valley . The pay Is a bit less but it's about 5.5 miles from my house.close. Why do people pray for government jobs? At the moment I'm with ucla health as an admin assistant float permanent& have been offered permanent placement at a site in LA about 16 miles . The pay seems pretty decent& also have the pension plan. Been here about 2 years no issues.

like

Best restaurant you’ve been to in Charlotte? Looking for an experience!

like

The stress of this job ruined my life.
The stress has lead to an eating disorder that I can’t get control of. I’ve lost 25 pounds since starting at the firm two and a half years ago. I am 20 pounds less than I was in high school... I don’t know how to get control again. Even when the stress lays off I can’t eat more due to being used to being busy for almost 9 months out of the year...

like

Does anyone have any experience or insight into any of the audit firms that focus specifically on digital assets, crypto mining, blockchain etc for e.g Cohen & Co ?

like

What should be expected compensation in MasterCard for Senior BizOps Engineer in ITIL/ITSM team.

YOE : 7 year 6 Months
Current CTC : 21 LPA + 20% variable on top of ctc

like

Additional Posts in Excel Genius

Is there a way to do a multilevel sort but keep certain rows from sorting? I’ve got a fairly involved project plan with different levels and I need to sort by the dates on certain rows but keep other rows intact

like

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

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

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

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

Post Photo
likehelpful

Hi there! I'm working on the data modeling assignment and looking for some tips for data mapping (how power query or vba can help). Thanks!

like

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?

Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

Post Photo
like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Hi all,
I bought access to Wall Street Prep’s modeling courses to enhance my modeling skills. I find that the material is a few years old and the guy in the video explaining everything is super monotone and boring. I just don’t feel like I’m learning much.

Would anyone have any good recommendations for other modeling course providers? Should I stick with WSP? Any and all advice/responses would be helpful - Thank you in advance !

like

If you have never created a macro, any tips on where to start? Any good Udemy courses or YouTube videos?

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

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

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

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

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