Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

How would you feel going on vacation with friends who want to bring their kid along too?

Please enter your access code, followed by the pound sign

How is pega practice in LTI ?

Random question, my boss wants me to become a notary so I can handle notarizing all of the official documents myself. Has anyone else been asked to do this for their employer? Is it ethical?

Is 14.7(15%variable) +2 lacs JB is good for 2 years exp @ Optum?

Have any of you done think tank work? How does it differ from academia?

Hi fishes,

I will be moving to Bangalore in June for the first time and wanted to know how much monthly expenses(approx) one can expect for a 1bhk and other expenses like food, utilities, maid etc.

If you could work at an agency for the rest of your career, would you do it? Or do you see being a professional creative as a means to another career altogether?

A MFE is better suited for stuff like trading, risk management, structuring, quantitative research, etc

New idea - airlines give us the ability to deduct miles from passengers that do shitty things, I.e. take your shoes off and put your dirty feet near me.

Cannot wait for my next vacation!

Trump: 'I've done more for the Black community than any other president' with the 'possible exception of Abraham Lincoln' 🤬

Hi Folks,
How is CCB lob in terms of yearly hikes and bonus.

Is 32 lpa good for 9 year experienced BI developer ?

What’s an idea that changed your life?

Has anyone ever heard of Kaufman Hall healthcare consulting? My girlfriend is thinking of moving from academic medicine to KH

Is there a text to rows (instead of text to columns) trick?

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

If I have NAME, REF etc errors in different spots of a very large worksheet, is there a quick way to delete all formulas that are bringing errors?

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.

Is there an easy way to see a +/- 10% on all of my variables in a model? Is the easiest way just using a formula and creating separate columns to visualize it

Is there a way to wrap your header text within access database?

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

I have pivot table with a sum column but it won’t let me filter. Any advice on how to fix this

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, where xyz is the word I’m looking for, but isn’t working in this formula I have down:

=IFERROR(MEDIAN(IF(Data!$AR:$AR>0,IF(Data!$Y:$Y>0,IF(Data!$M:$AM="*"&D$345&"*",Data!$BR:$BR)))),"")

Has anyone had any success here with recording a macro to set up a pivot table? For context, I am just looking to run a pivot and then run the macro and have it show the pivot table completed with the right fields in columns, rows, and values and then also formatted how I want. I tried to just record doing the setup of the macro, but I got an error message when trying to rerun.

I have zip-zip routes for a trucking company. Most of them have price info but some are blank. Is it possible to do a count of those with price and without price in two columns of a pivot? I want to show that prices are missing across the board and that we can use the majority to replicate the missing few.

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.