I have a file that I exported from Microsoft Teams that contains a task tracker and several columns of dates. However, I believe these dates must be formatted as text because when I create a pivot table it will not group them by month. I have tried to change the format of the cells to a date with no luck. I have also tried to use ‘text to columns’ to convert them, which causes Excel to crash. This is a small data set, less than 100 lines. Any suggestions? Can share the file if needed.

Read this on Bored Panda: Just Had A Zoom Job Interview, And The Recruiter Asked Me To ‘Show Her Around The Room

IBM started to drop the mail for join Slack etc. and the mail for laptop request for new hire .

What if I don't join on the last day or deny to join on last day ? Because still need to decide between two offers .

Anyone interested in a zoom networking event since that seems to be the norm nowadays. Thought?

Heads up. The Bar just emailed out invitations for two free online CLEs in the first week of may. I've been doing these Zoom courses as they are offered and it's going to significantly reduce my end of the year stress.

Happy Wednesday! I am trying to plan with our AP and climate lead on what we can do in distance learning as a school wide event. I suggested we still host our multicultural club assemblies on zoom for the school. Anyone have experience with zoom assemblies to promote a positive climate in DL? Thanks!

Mac or HP or Dell: I prefer Mac notebooks. However it seems there might be limitations with the use of Skype or other applications based on materials I have seen. What do you all recommend is the best laptop for working at Deloitte?

Is joining cisco with 26 base 3 lk bonus and 3.5 joining bonus with 6yoe in Cisco webex good?

Hi music teachers! How are you surviving? I’ve been teaching band and choir for a long time, but distance learning and Zoom has me stumped. I’m lucky to have a job, I realize. What are some things you’re doing in your virtual classrooms that your music students enjoy?

Tips for helping kids stay on task during zoom? Our little class (9 kids) has been doing zoom circle times twice a week but I noticed they are really distracted. Also every meeting a kid leave...

I’m interviewing for BCG and had a principal reach out to me for a zoom chat. Is this normal for principals to reach out or is this a positive sign?

I am trying to write a stock letter to send to parents everyday that their child does not come to virtual learning sessions. I have been told by administration that even though I have spoken to parents and know why students are not coming to zoom classes, that we still need to contact them everytime they dont come. For some of my students this is everyday due to parent work schedules and disability issues.
Is anyone else having this trouble? What are you saying to parents to cover yourself?

Hi! Can someone recommend a source for learning how do simple, fun music lessons on Zoom? I teach first grade and use music for my transitions. I would also like to play songs for them with my guitar, but am concerned it won’t sound good on zoom (the guitar, not my voice, which is bad, we established that long ago)

Hi! Anyone successfully use Zoom or Teams to record interviews that will get spliced with other footage? Any best practices or pitfalls to avoid?

How can I change the project in Accenture?

Hi Fishes
I have got offers from PwC AC Bangalore (EA) in Management Consulting vs Accenture Capability Network as Management Consulting Analyst.
CTC almost Same

Which would be better considering WLB and growth?

Workex :Pre MBA 3 and Post MBA 1 (in consulting)
Tier 1 Bschool

Hello Team,

Please let me know how to remove CID from Accenture portal. I appiled in Accenture through a referral but now status is showing as " we don't have suitable position". Thanks

What kind of work does Analyst data science folks in Accenture get to work??

Hi Fishes, anyone attended Mainframe developer interview in NATWEST group? Are they scheduled Techno-Functional or CPC assessment? Does anyone know about Techno-Functional assessment? What kind of questions will be asked? TIA Natwest group Cognizant Tata Consultancy Accenture Bank of America Infosys Tech Mahindra Amazon India HCL Technologies Capgemini

Want to join new company after h1b transfer completed. Need to give 2 weeks notice to current employer. Can I work for current employer for those 2 weeks notice period after h1b transferred to new employer?when does the current employer get notified of h1b transfer, in case that happens?

Deloitte senior manager salary in Singapore?
Base and bonus breakup will be great. Thank you.

What is the difference between pepsico PIH and GBS in India? Which is better for growth?

A friend of mine is looking to join DDB Anderson Toronto as a PM. Any advice regarding the company or role?

I’m interested in learning about people’s paths to working in the industry - have most people done law adjacent jobs to get to where they are today? Thanks in advance!

Anyone here make it out of IT audit to a more interesting role?@

What are the various employee benefits that lilly offers?

Capegemini
LTI
Persistent
Synechron

Which one to join for better stability, job security.

money doesn't matter.

Only job security and WLB.

Frustrated my fiancé keeps talking about raising our future kids in the way he was raised. We’re from different cultures. He wants to name them based on his culture, send them to schools with dual immersion in his language so “they don’t get too American,” and has even mentioned moving so they’re exposed to his homeland and culture. Religiously he is fine raising with both our relig but def wants them to participate in some of the orthodoxy of his more so (cont)

Looking to book two Iberia tickets using avios NYC to MAD business class in March but can't seem to find availability - can anyone help?

For all you in IT audit what has your salary progression been YOY?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Anyone have a good source to learn sql

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

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

Most used or favorite Shortcut? Ctrl + Z doesn’t count

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

New project, new massive excel file that I keep making mistakes on. Tips on error validation and performing QA?

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

Would anyone be willing to teach me vlookup?

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

I work on a Mac and excel/sheets can’t handle the size of my data. MS access isn’t available on mac. What do I do 😭