struggling with analytics / excel at work! anyone who has gone through a similar path that can share how they up-skilled? I’ve started by investing in an excel course + shadowing a senior analyst w more experience but am super stressed and worried about my progress

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

Well what’s your issue specifically? Is it the devil in the details? Functions? Macros? Taking a good look here can be fixed over practices.

As for courses perhaps udemy and I started following a page on ig, called excel dictionary. Nice lil page lol

like

There’s YouTube videos that can also help with leveling up excel skills but ultimately it’s a skill that requires practice to get good at the analytics portion of it (as that will require an overlap of analysis and excel skills)

like

Think you should look into learning PowerQuery. But in terms of learning, Start with looking up a simple excel project. Practice makes perfect

like

Actually, once you’ve mastered the material in Excel for dummies and the Excel Bible then things will get easier and easier.

like

Just finished FreeCodeCamps: Excel for Data Analytics YT. ~3hrs long, first 1.5hrs was all I needed. Having exposure to projects helps to know what to focus on specifically. So, you may want to ask for excel-related tasks - that aren’t time crucial - to do in your free time (a few hrs over the weekend). PowerQuery is super helpful so include this in your learning/workflow. Ask your company if they provide resources (LinkedIn Learnings, etc). Be patient w/ yourself, it’s just a matter of time

like

Take advantage of LinkedIn learning courses if your company offers, they probably do.

like

I teach Excel courses, one-on-one or group settings, at a low cost. I customize the course to your specific needs. It takes 6 courses to take you from novice to proficient. Let me know if you need help.

like

Make friends with an entry level person that knows how to do it

Work late if you have to. Use ms forums to ask your question. It’ll take a few months but you’ll get there :).

Start learning some basic functions which you can find online, and the best advice honestly can be to start building your own sheets for some different uses (for instance, a complex sheet for fantasy football or a private file for your chargeability), in this way you can learn how to use the functions in different scenarios, to adapt the skill that you find online instead of just taking notes and similar :)

Related Posts

Pros and cons of being a specialist vs generalist?

like

A colleague told me today that Google separates Product Manager and Product Owner as two separate roles. I believe that one PM role is preferred in the industry and most modern software companies, especially FAANG companies, only have PMs. Just curious what others have experienced and if I'm correct in my assumption.

like

I'm in sales/trading and want to switch to IB, but know embarrassingly little about the industry. Where to start?

like

Looking at starting the CFA journey. Schweser was recommended, but is it worth the added cost? If I'm subscribed to the idea that I am going to be spending 20hrs a week studying, is that sufficient?

like

Have any of you witnessed colleagues hopping over to health tech? Which positions should I be searching for?

like

Best resources for platform dev 1? I failed in 3 times and have to wait until spring. I’ve got 9 other certs(5 yoe) but this one is kicking my butt

like

Has anyone gone from a federal gov’t employee to private industry? I’m considering making the swap for better pay, I make decent money where I’m at and I know I have job security. Just trying to see if there is anyone else that was bold enough to make the leap.

like

Hi Fishies, I have got offer from Salesforce for Success engineer role. But I am working as a Salesforce developer. I do have a offer of Salesforce developer role from Deloitte. Can anyone please help me about the role and responsibilities of support role? Will it be good idea to switch from developer to support role? My YOE is 2.6.

like

How long does it take to go from Associate Manager to Manager at Accenture Federal Services?

like

I work as a marketing consultant and I love my job. It’s the career for me and I want to advance my career and climb the ladder. What are some of the typical positions that are pursued after a marketing consultant role? What are some pointers that you can give to someone who wants to advance their career? What are some things that I can do now to prepare me for that next role?

like

Hi I just received an offer as Technical support engineer at Salesforce. But I'm working as a developer in my current organization in a non-Salesforce domain. Is it worth joining this role after sacrificing a Dev role in my current organization?

like

Hi all, I have the Sales Cloud Consultant exam coming up , Any tips on online study (besides trailhead) from those who already got the cert? Or any Deloitte resources?

How did you decide your speciality in Cybersecurity? Did you naturally gravitate towards one area?

like

What would you recommend someone starting tas (campus hire) early next month do to prepare. I am CPA eligible, but not sure if I should spend my time on that or study finance or just relax. Any recommendations?

like

What title for this job description?
I want to switch roles from a creative director who oversees all aspects of the company’s creative (marketing campaigns and brand building mostly; also production, performance marketing ads, product design, managing design team) to focusing 100% on building our brand, educating both customers and employees about our value prop. I hate managing people or logistics and scheduling. What would this role be called? Do you see it as demotion from CD?

like

Any advice for someone looking to transition into a full HR Generalist role from Recruiting. I’m currently a Campus Recruiter with about 5 years of HR experience (Coordinator- Higher Ed). I received my PHR certification in September 2020 and sitting for my SHRM-CP in two weeks. I’m having a hard time transitioning into a full Generalist position.

like

Anyone have any suggestions how to break into in house counsel from Big Law?

like

Looking to specialize in privacy and was considering getting the CIPP/CIPM/CIPT. I already have my CISSP and CISA. Is it worth it?

like

Hello! I was wondering if someone can explain the difference between PM vs. PMM, and tips for non-PM/PMMs in making a transition to the industry. Are there preliminary skills I should acquire before applying? Any info on day to day and salary will be helpful! Thank you :)

like
like

More Posts

Fishes, would you be willing to move to a new company for $20K increase in your base pay? No sign-on bonus and not a target company.

like

How much time is acceptable to bill to admin per day?

like

Rising 2L here…Just found out yesterday that one of my top target law firms is not participating in OCIs (they don’t have offices in my state). Any advice on the best way to move forward with them? Still planning to apply, just want to know what I should be doing. Thanks!

like

Looking for case partners for McKinsey R1. Beginner with some experience. Let me know!

like

Any 🐠 looking for a place to stay in Boston this winter? I am taking advantage of 100% remote work and going to Utah. Looking to rent out my furnished 2 BR 2Bath apartment, downtown- water view of the harbor next to the aquarium.
$4k a month (renting at cost)

Post Photo
like

What is the typical annual bonus for an MBA associate @ McKinsey in London.
I’ve heard it ranges from 5-20% but it seems too vague.

like

Hey guys! Currently in WM ops at Morgan Stanley for the past 1 year dealing with alternative lending, I’m super underpaid with 3 years of experience which is very frustrating. (73k). Have been at Morgan for 1 year and looking to come over to JPM for an ideal pay bump, but would like to get into IB type roll. Any insight on what I should expect or how to go about applying? Maybe even getting referred? I have a deep knowledge of investments and always felt inclined to go down this route.

like

Friends are ignoring me after they got promoted and I didn't. Really didn't think I would see this day :( How should I handle this?

like

PwC US ADVISORY
Line of Service: Advisory
Industry: Management Consulting
Designation: Senior Associate
I have second round of interview tmrw and have few queries as below-
1) I have current offer of 12 CTC from other company so now how much can I ask in pwc? My current experience is 5yrs.
I am on notice period and in present company I got recent hike and my salary is now 9.5ctc.
2) generally how many rounds of interview will be there?

like

PM fishies. Is it true for you guys too to keep your resumes down to 1 page? Gave that advice to my pm friend I’m referring and she’s having a tough time culling it down. She’s jr but just afraid to

like

Been selling covered calls or puts on F. Seems almost too easy. What can go wrong, outside of it actually hitting ITM?

like

* Non-political * * Human rights issue *

What is Free speech?

Who decides what is free?

Why is free speech projected as a political tool?

Why there is no free speech (by Western standards) in China, Russia, North Korea, Cuba, Pakistan etc?

like

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?

like

I have Cognizant offer 25 LPA & EY 29 LPA
YOE 9
Does cognizant match the counter offer?

Also while negotiate counter offer it requires share complete offer latter? Instead of screen sort of CTC break up

like

Hi Folks,

Do
CGI having data science openings and projects or if anyone know about anything related to data science and ML project in CGI .
Are they really having some clients or projects in pipeline related to above said domain?

what are the learning platforms provided by cgi??

like

Looking to book one night at a Marriott property in chicago to celebrate anniversary with my wife - mostly deciding between the Gwen and the Ritz. Which would you choose? (Assume price doesn’t matter)

like

What are some really fun government jobs?
(Assume no barrier of entry)

like

Does HCL give any joining bonus to immediate joiners?

Hi fishes,

Got offer in Barclays 10.5 currently in Tcs as unix system administrator application support. Please suggest is Barclays good to move. 3.3 yoe

like

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