I’m having an issue where my excel workbooks are almost doubling in size. I have a master workbook that produces consolidated company reports (12 tabs) and 12 more tabs that populate based off a selected Department. There are about 10 data tabs at the end. Today I deleted all the consolidated tabs and the report went from 70k to 98k in size. Similar thing happened last week where it went from 38 to 70. I add data each week but that usually only adds up to .3k in file size. Any ideas to help?

What is the salary range for Sr. BA/Product Owner with secret clearance and 10+yr experience in Ottawa, ON.
Contract or full-time

Inflation report out today. Question- Does this report comes out every month?
is there some fed announcement or meeting schedule for the year?

Upcoming interview with large tech company for biz ops go-to-market role. Any book recommendations to learn about go-to-market / sales op strategies for tech?

How much is your firm giving for wfh accomodations?

Can anyone share microservices questions

What’s everyone using to create estimates for clients and manage resource planning so if the estimates are awarded you have the team in place to deliver. We use Actualize it which is built on FileMaker. I’ve heard of Farmers Wife, F-track and Ceta.

How do we think COVID-19 is going to end?
A. Vaccine is found
B. Testing, social distancing stamps it out
C. We develop herd immunity to it
D. We learn that it’s not as lethal as previously thought

✅

"Busy season hours are long but it's only for a few months in the winter," he remembered the recruiters saying as he sat there working on a Saturday

Any advice to find a job in Vancouver Area? I've been working in IT recruitment for over 2 years and I enjoy doing creative sourcing.

I’ve 90 min for ELA & 6 kids. I need to teach phonics, curriculum (has 0 phonics), & goals & they need freq. breaks. Admin’s making me use said curric. Any ideas?? Small groups and rotate? TIA!

Any Ertugrul fans out there? If so, where can one watch seasons 3 & 4? Just finished season 2 on Netflix and looking to watch the rest of the series from a non sketchy site. JAK in advance

Looking to get involved in Federal work and/or Public Sector. Can anyone give me pointers? How did you get started? What level and firm?

What is real freedom, you ask? Real freedom is being able to take the loudest shit in the stall next to your shitting MD, then coming out and cracking a joke about something completely different.

Not sure if this goes here but my brother is looking for an acquisition role at a real estate investment firm in NYC. Right now, he has 3 years experience in commercial real estate as a broker. Any one have any opportunities or ideas where he should look? Thanks for all the help!

I need 11 likes?

If we missed to submit timesheet for first fortnight still we will get salary or not? In Accenture

Elon moving here? 🥲

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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)

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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.

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.

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?

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?

What are your top Excel ninja tricks? Ones that few people know...

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 🙏

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..