Quickest way to learn excel when you haven’t used it in years, looking to start at beginner level and learn from there. Is there a YouTube? Or a website that people recommend? Thanks!

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

Have to learn by doing for Excel so would find a resource that has exercise workbooks you can play along with. Coursera and edX both have

like

I second BCG1 on learning by doing. The quickest way to learn excel is certainly by being given a problem (or problems) to solve with a deadline and being forced to make it happen. Initially, your solutions may be messy, but as you take on harder problems, you will learn new techniques and formulas.

like

YouTube probably

Related Posts

Do you think sticking it out in BL for 8 years pays off as far as in house prospects/salary go? Or is it all kind of the same after a certain time period. I’m in privacy if that helps (all aspects-trans, regulatory, lit).

like

I am a graduating student who just got offered 65k for a solution analyst role at Deloitte USDC (Data Engineering Focus). From reading previous posts it seems to be a lot of negative thoughts surrounding the USDC, but straight out of college is this a good opportunity?

I'm looking to gain as much experience as possible out of college in an IT role and wondering what exit opportunities may be in place a year or two down the road if there is little/slow progression.

Any Advice?

likehelpful

For those of you who are SHRM CP certified. Can you please advise if the SHRM learning system is worth it? Are there other effective learning tools that are less expensive ?

like

Hi folks,
My exp is around 9 years and working in the telecomm domain for the entire time.
I want to switch to data science or data analyst domain now.
Is it possible?

If possible then what certification would help me?

like

Yoe: 3.5 Tech stack: .NET+Angular I hold 2 offers: Hitachi Energy (Chennai) - 12.5F+2.5V Siemens Healthineers (Bengaluru) - 16.5F+1JB+1.5RB Which is best in terms of wlb, hikes and growth?

like

How would you rank in order of prestige/ease of getting in: UCLA, Cornell, and NYU ??

Looking to transition to MBB if that matters.

Has anyone passed the 2021 Oracle Receivables certification exam?

like

I'm currently looking for admin assist jobs that are remote. I was thinking a career in another country. Any advice, any ideas about companies I can apply to?

like

How many days do we need to get trained in Pega...Looking for changing tech stack to pega from other middleware.Please help

like

Hi Guys,

How are the opportunities in data analytics domain for a Msc Physics as a fresher. And can you suggest some good online platforms.

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

What is the exit formalities at PwC AC Bangalore?

As my new company wants me to join immediately

Will there be any issue they raise, if we waive the notice period (60 days)?

If so what should I do, to get smoothly exit with waiving notice period?

like

I am an experienced CNA/MA (17yrs) trying to break into ER tech role. Previous company wouldn’t pay for phlebotomy class, and when I took a position with a company that would train me, there was so much drama and b.s.
I was out of there so fast because of the toxic environment. Should I just forget it and do my best to finish my RN?

like

Do you think consulting is not the right path for core technical people ?

like

Hi Fishes,

Does taking up a delivery manager role mean that there will be no more growth in terms of technical knowledge?

Any thoughts/opinions would be helpful

Anyone work for FDA and leave for a firm? Any thoughts or advice (pros/cons)?

Does MBB give you a good variety of projects (both in function and industry), and did that help you discover what you want to specialize in (either in consulting or in an industry job)?

like

I accepted an offer last month. Put In my two weeks on Friday and PwC countered / beat my new offer. I still plan to take the new role, but would like the new company to match. However, I don’t want to risk anything with the new company. Or come off as a difficult new team member before I start. Thoughts?

like

Does anyone feel that the Oil and Gas industry is the most discriminatory industry of all? They won’t even look at resume without O&G experience! It does not make sense to me as I would rather teach someone the specifics of an industry if they were a good fit. And for an industry that has so many obstacles from Government, Environmental Organizations and so on, why they are adding more bad publicity to themselves is not a great approach.

like

How similar is recruiting to traditional sales work? For example I worked in property management/leasing and in retail for years and didn't care for it too much. I'm currently a recruiting coordinator and want to know how it compares to an average sales job. Thanks!

like

More Posts

Any altcoins in sight for meteoric rises? 🚀 🚀

Looking to pivot from the retail sales universe to Customer Success manager/associate….
Are there Companies you recommend that hire entry level or offer training for these type of roles?
I’ve done some courses and certificates to begin my transition and familiarize myself with the role, any advice will help…

like

Hi fishes may you please confirm the below:

In the offer letter the "Provident Fund" And "gratuity" Is mentioned. In the salary calculation in hand, we will not consider these amounts right? As these components are received when someone retires..right? .. Please confirm.

Thanks in advance

like

PwC is seeking individuals at all levels (especially experienced associates through senior managers) within the following consulting practices: Risk & Controls (general, HI, FS); and Enterprise Technology Solutions (Salesforce, SAP, Workday, cloud). Feel free to DM me if you are qualified and I’d be happy to facilitate a referral.

like

Is it possible to find a good exit in a less populated area? I don’t want to be near a big city — I want a house and a big yard. But every single job that would be a good career move is in a big city. Do good jobs in small markets exist? How do you find them?

I’ve considered 100% remote roles, but it seems hard to progress in a career if I’m not physically present.

like

Epam systems - 25 Lpa fixed
Or
Pwc ac - 25.9 lpa fixed + 10% variable.
Which to prefer ?
Yoe: 8, skill: data engineer

like

Hello People,

Just wanted some suggestions i have been working as a python developer for the last 3 years
Now I am thinking of switching to a data engineer position I need your suggestions is it good to switch or a python developer It is good to continue or what's your suggestions thanks in advance

like

Salaries for NYC Art Directors? Mid level (2-3 years exp). I know there’s an excel sheet but I just need some quick refs, having a comp review tomorrow.

like

Out of these 3 which one will be good for long term and offer job security.
1.
Northern Trust Corporation
2. Capgemini
3. Epam anywhere not EPAM Systems
I am tired of changing companies.
Now, I want to stay in one company for long term till retirement

like

I'm a conceptual ACD. Anyone make the transition from being a conceptual ACD that's worked mostly I'm tv/olv, and integrated campaigns? How did you make the transition? Where did you start?

like

Hello Fishes, I am on my notice period with 20 days remaining. Having Total YOE as 6 years in Insurance Broking and claims. Looking for opportunities in operations (Back office, Middle office and front office). Please let me know if any openings available for me. Willis Towers Watson Tata Consultancy Aon Aon plc JPMorgan Chase HDFC ERGO General Insurance Company HDFC Life Kotak Life ICICI Prudential Life Insurance ICICI Lombard Allianz services

I graduated in 2016, did a state court clerkship, and then was hired as a hearing officer. I’m looking to apply for an attorney advisor position but wonder if my lack of ‘traditional’ legal work will harm my chances. Thoughts?

Why is this bowl so quiet?

like
like

Which companies & roles pay very well, hybrid work approach, and allowed unlimited pto?

like

Looking for an accounting job in industry (remote). Any recommendations for someone with a tax background?

like

Currently a senior with 2.5 YOE(not including 7 months of internships). I want to apply to Pwc Senior Cyber Risk position, but the minimum YOE is 3. Is it worth my time applying for the role? Will I get eliminated off the bat due to YOE?

like
like

Heard frm a friend at pwc that in consulting they have per diems. Is it for all practitioners and practice? Seems tight on budget.

like

Additional Posts in Excel Genius

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

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?

like

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?

like

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

like

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.

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

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

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

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?

likehelpful

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)

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.

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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

like

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

like

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

like

Anyone know what these badges are?

Post Photo
likefunny

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?

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.

likesmart

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

Scan your QR code to download
Fishbowl app on your mobile

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