I want to try and create a dashboard at work that can be used to track demographics of areas quickly and create comparator charts etc. Does anyone have an idea of how I could learn how to make something like this?

( I am also not super efficent with excel so its going to somewhat of a training project for myself)

Does anybody work for Evolent / New Century Health? How is the culture? Any known layoffs?

Anyone sent email regarding salary revision to manager/HR & got expected salary ? Yes, Plz share email template :)

How does everyone track their daily and long term work to-dos (lists)? I am not the best at organising and feel overwhelmed with tracking and prioritising. Any tips?

Hi folks,

I have 8.9 years of tech writing experience. How much CTC should I be expecting when I join a new company. My current CTC is 20L pa (18.75 (fixed) + 1.75 (variable)).

I have a few questions for people in consulting roles (both external/internal).

My partner is in corporate banking, but he wants to switch to a consulting/strategy-based role. I noticed people with those jobs typically have an MBA, and also majority of the job ads in similar roles has MBA as either a requirement or preferred qualification. So:

1) does MBA actually improve someone's chance in getting those roles?
2) are there any good Canadian MBA programs you'd recommend?

Thank you all!

Welcome WD folks, lets integrate :P

Folks - what brands (other than Ball - I already own some pieces) do you recommend if I want long lasting value and tritium gas tubes that glow so brightly thought the night?

Anyone here have any insight on lateraling to Rawle & Henderson? 10 years exp.

Hi anyone working in Japan(Onsite for Indian) for Flexcube? How Oracle pays for that ?

How is MBA (Executive) with Specialisation in Business Analytics from NMIMS (Upgrad)?

Have anyone done that.. please share your feedbacks

I just completed the interview process at CGI, the HR called thereafter saying that I've cleared all the rounds and they'd like to give me an offer. They also sent a couple of mails for required documents. But I am yet to receive the offer letter, is this usual?

Hi how is Oracle hike yearly .Do we have job security in Oracle ?What's your opinion in joining Oracle

Is there anyone from pega profile un IBM? Want to know about work env, work pressure as well as work life balance. Please need some suggestion. Good to join or not

Is it me or the wifi in hotels is too bad to play online games? How do you people manage gaming while traveling?

Any body got retention offer from LTI?

Guys
Any idea like how much time is normal for project to be assigned for new hire in deloitte. Is it something to worry if not within the 15 days of joining. Views pls.

Has anyone given interview in Daimler for data engineer? Can you please help what kind of questions they ask in the first round?

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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.

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

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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

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.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

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?

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 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.

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.