Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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

As in excel keyboard shortcuts?

Yes, but the ones PwC created.

Related Posts

Why are there roles out there specifically for change management? Isn’t this something program managers always owned? Where does one draw the boundaries? It makes me question whether hiring change management analysts are really necessary but I see so many “change management” roles in consulting

like

When do you think we’ll have to come in to the office or start traveling again? Prefer to wfh for as long as possible lol

like

Time to party, bring in the booze, because we already got the peanuts.

funnyupliftinglike

Hey guys
What's a good birthday present for my 30 year old wife ? I got her something sentimental but I want to couple it with a few other things.

like

All my white shirts get yellow with the time, what’s the bulletproof white shirt for looking sharp and impecable?

What's a good Software Engineering salary in Stockholm, Sweden?
I am currently making a bit more than 40k/year, and I have gotten extremely mixed information about whether it's a good salary or not

More info:
-I am under 20 years old and self taught, but I work on-par with the rest of the team (all of them except me have degrees ranging from master's to PhD), I don't know how much the other team components make
-I work with embedded software development with mostly C and C++

like

Allen Edmonds anyone?

like

I work as a Solution Specialist (sales rep) at an Authorizer Verizon retailer. Phone/wireless sales is not something I want to do forever. I have 4 years mobile sales experience and 3 additional years of niche sales/ customer service experience. I’m feeling stuck and every career/job move fells it is a step backwards. Does anybody have any advice on how to power through this or what other routs I could go?

like
like

What does an Enablement Lead Analyst make at BCG?

like

SAP program management background, certified in MM module but it’s been years. Is it worth to stay in SAP or I should just pursue PGM position in industry, SAP or not?

like

I get asked for legal advice often from family / friends. When it’s something legitimate I often offer to help ( I have my own firm / practice) however when it’s BS I’m pulling the oh it’s not my practice area line…. How do you manage the line here?

like

MBA1s: Tell the recruiting market is bad without telling the recruiting market is bad.

Now go!

like

Do any of you use Jo Malone ?

Hey Fishes,
Been working at D India as a Manager (Not USI) for past few months.
Ask me anything as there are very few reviews available online.
To clear few misconceptions
1. Global projects are available here
2. They've started mentioning Bonus, Gratuity amount etc in offer letter
3. Work life balance depends on Project and managers you work with
4. Inside opportunities if you're the creamy layer
5. PF amount in offer letter is the total deduction and not just company's contri

Other can add

like

Hi 🐠 fishes,
Actively looking for opportunity in manual functional testing QA, 2.4yrs of experience...

Serving notice period
LWD:- 23rd Feb
Immediate joiner

Open to all locations

Current CTC:- 4lpa
Exp CTC:- 5lpa to 7lpa(negotiable)

Any referrals/openings/opportunities, plz let me know Contact:- 9356728605, 9403298511(whatsapp)

like

Hi 🐟,
I have 2-offers which one is better to join
1)Bosh (18+4jb)
2)epam systems (25+1jb)
yoe-4
Qualification: m.tech
Tech stack: C,Linux,C++, Embedded system

like

Need some advice. Would you take a contract role for a big tech company? Went through a full cycle of interviews but another candidate was selected for the role. The senior manager then emailed me directly asking if I was interested in a contract position. Not sure what to do….

like

What is the hiring market looking like these days? I am seriously burnt out and ready to exit MBB consulting, but feel this economic downturn may not be the best time to make big career moves. Thoughts?

like

I have no talent for awards work. What should I do?

Additional Posts in Excel Genius

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

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

likehelpful

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

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

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

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

What’s the best way to compare lots of data with time stamps? I.e. you’re trying to evaluate the time different steps in a process take for multiple line items (10000 rows)

Current approach I’m doing is to subtract the times (in hh.mm.ss) from each other to get the duration of each step. Not sure if there’s an excel time stamp function that would make this easier. It’s not working well for times that were late PM and bleed into early next day AM.

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

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)

Would anyone be willing to teach me vlookup?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

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

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

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

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

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

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

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