At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

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

You can probably create a macros for those and set the shortcut to ctr+shift

like

I think training the street macro should help you out.

Related Posts

Generalist in supply chain. Have a year in industry, and just under 3 years in consulting. Disappointed that I haven't really found what I enjoy and that I am not known as an SME in any specific area.

I'm ready to leave consulting, but every company I interview with either notifies me that I lack technical experience or not enough expertise. (Tried applying for SC and business analyst roles.)

Would love to pivot into product management work. Any advice on how to prepare myself?

like

What is the Median Senior Change Manager salary in London at PWC?

like

Hi All
I have interview with walmart for IN4.
how to prepare for LLD round and
I have cleared first technical discussion.
Any help or suggestions are welcome.

like

Why platinum and no longer platinum elite?

I want to move to a bigger city. Would you say Chicago is a good place for 24 F for both career and dating aspect?

like

Is there any sort of GIT-like version control in alteryx that allows you to automatically update macros/nodes in other people's alteryx Designer.

Poorly phrased but I'm looking for some sort centralized release/version control.

like

Does anyone know the criteria used to determine who is selected to be laid off due to COVID?

like

Who is GT’s 401k with?

like

Looking to reserve a room/space at a bar in NYC for about 30-40 people after the marathon. Looking for a pay as you go bar and relative cheap pricing for booking. Thanks!

like

Pls contact sananda for more info..I just fwd posts

Post Photo
like

PwC folks, is our inszoom not functioning anymore? The new website doesn’t have any info on my perm...

like
like

What will be the salary in hand every month keeping in mind normal tax deductions for 16.5 fixed salary?

like

After seeing the post about the differences between TX and NYC day to day I'm interested, if you moved to TX from somewhere out of state to practice how have you found the transition? Physically/Socially/Politically/Financially? Not looking for pros and cons, I'm from here, just wondering what it's like for people who moved here.

like

If you don’t spend a ton of money, high fee cards like CSR aren’t worth it, right? Just wanted to make sure.

like

Is NPS/PPF a good investment?

Thoughts on DeBlasio ending remote work for all municipal employees on May 3rd?

like

I am interviewing with CIBC for a Sr. Analytics Consultant, Fraud Analytics position and I would like help in understanding the salary range to expect, or what I could ask for. I’ve tried looking for data in talent.ca, indeed, glassdoor etc, but all in vain. I’d appreciate any help that comes my way. Thank you!CIBC

like

What do you think is a realistic salary for a HR Manager with 12 years experience in small companies (80-200 employees), MBA, SHRM-SCP in Hampton Roads VA area?

like

Additional Posts in Excel Genius

What are your favorite excel macros to make you more efficient at work?

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

Does anyone know how to keep in leading zeros when converting to a number, so I can do a vlookup across data sets?

like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

I did this manually but would there be a way to pivot the dates (day/month) in the rows years in columns with raw data being (date/month/year) needed a visual of same day different year

Post Photo

Really wish my clients didn’t use Google Sheets. This sucks.

like

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

Has anyone used VBA to create multiple what-if data tables before?

Do you guys use specific color scheme to make you spreadsheet looks pretty?

like

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

Does anybody have a good resource that would let me link data from QuickBooks Desktop to Excel?

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

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

I'm stumped!
Coworker creates "Sheet A" with invoice numbers
I use Monarch to extract invoice #'s and amounts from another report.
I do a pivot table to compile amounts by invoice. I copy those results to "Sheet Z".
I then do an @vlookup on Sheet A referencing Sheet Z (just the invoice # and amount).
It isn't working unless I go to Sheet Z and type over the invoice # (same number)! All invoice #'s are absolute and in the same font & alignment. Workbook has 10 yrs data. Has worked in past!

like

need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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