What are the best resources for learning excel? I'm not great at it, but my promotion definitely requires me to be better.

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

YouTube excel tutorials and look for ones with a downloadable excel file and do the work with it. You won’t learn unless you actually do it yourself.

like

What kind of excel modeling are you doing? Do you need to be better at financial modeling or just the mechanics of excel?

like

Wallstreetprep.com

like

Kubicle is also good and a subscription that some Big4 strategy houses pay for, but yes nothing better than hands on practice

like

Does Kubicle provide downloadable files to practice with?

The Excel Bible from Amazon

like

My go-to was just ask google when doing something that seems hard or time consuming. The YouTube videos and tutorials out there are great for getting started and common things. My more advanced skills came from googling with the mindset of ‘there has to be a better way’ or following some Tik Tok creators that do short clips to expose you to new or near functions.

like

Leila Gharani on youtube teaches some really useful excel skills

I’m really bad at using excel my skill level is barely a 2% knowledge, I want to get to 100% knowledge! What are some good resources that will help beginners step by step! And not to mention I’m taking an accounting class! HELP ME PLEASE!

Ryan

Related Posts

Long drive tomorrow. Does anyone know of any on demand CFP continue education courses out there? I’d love to knock out 15 hrs of CE on this drive, if able. 🤦‍♂️🔫🤢

like

Hello sharks,

Currently I have 4 years of experience in SAP CPI and Success Factors system.

I'm confused on what to learn next to progress my career. I'm fairly good at coding and so would like to work in modules which involves technical aspects.

Please advice what can i do to improve my knowledge and also compensation

like

Planning to exit tech firms as a mid to senior level roles. What are some possible sources I can reach out at to make this happen?

like

Soon transferring from an advisory role (financing, FDD, consultancy, modeling etc) at a small boutique firm to a TAS role at BDO. Main clients are lower MM and MM PE as well as listed corporates.
Anyone with insight who could advice how to play my cards to end up in either PE or CorpDev?

like

How long does your firm wait to tell you your compensation after a promotion?

Promotions went out Jan 3 and compensation will be revealed late Feb. Is this typical?

like

HI All,

I have 3yrs of experience as a Customer Service Associate. I want to change my line of work as it is very monotonous. Can anybody suggests me what are the different roles I can apply for with my current skillset?

like

Fishes, Help me to choose a workplace for me. Nagarro - 8lpa (7.25 fixed )
Quantiphi - 10.5lpa ( 9.5 fixed )
Awaiting offer from Deloitte. ( How much can I ask ? )
Yoe : 3
Skills : Automation Testing.
Please comment on Job Security, Growth,wlb, benefits and other things .
Tata Consultancy
Deloitte
Nagarro
Quantiphi

like

Can someone offer some advice on how to potentially join finance transformation at the Big 4?

like

Hi folks, I have been offered a position on Senior Consultant/ Deputy Manager at Deloitte India for 4.5 years of exp.

Is this position/role normal for years of experience I hold?

Deloitte EY KPMG India

like

Could someone help me break down the differences between a Data Analyst vs Data Scientist vs Product Manager? And add any pros/cons from personal experience? In my mind they’re all related, but I don’t have experience working with any of these roles.

Will getting a low tier rating also affect your career when you are switching companies?

funny

Any chance I'd get my ass into an IB with relatively low grade, but genuinly good work experience. FYI, tier 1 undergrad finance student from India!

like

How many Partners here made it at their first company?

Did you have to leave to move up? Is it easier to make Partner at your 2nd or 3rd firm than your 1st?

like

Anyone have information on being an assistant attorney general? Is it prestigious? Better to be an ASA/PD?

like

Is it worth going for AM?

Hi all! Has anyone worked at BAC in risk before? Any feedback / advice? Looking to transition from big 4 consulting to BAC risk in Charlotte. Thanks!

like

Hi, I'm working with the EY UK in finance transformation consulting. Wanted to ask, how feasible is it to get a gig with the US firm? Since consulting has many opportunities across the pond, wanted to gain US experience as well.

like

Hi friends I have offers from HSBC as well as Visa Inc. what would you recommend to join from better career perspective and brand ?
Software engineer with 3+ YOE

uplifting

Anyone studying toward the CIPM have any tips or study resources? Particularly those with a legal background working in privacy and regulatory compliance (non-IT cybersec). Would be delighted to connect. TIA ⭐

like

Hi. I have just joined PwC India as a Sr. Analyst, from Campus. How many months/years of experience do I need before I can become an Associate?
Now I understand, it pretty much depends on my project and manager(s). Still, any good practices or suggestions to expedite the process?
Thanks a lot.

like

More Posts

Hi, I want to learn how to build ETL pipelines with Pyspark and Azure. As right now i have experience in feature engineering only with SQL and Pyspark.

Can anyone suggest anything online from where i can learn and do hands on?@

Who is looking for ADs? New York, Chicago or LA

I made the switch to in house and omg it’s so slow. I knew it’d be a bit slower than agency but I accomplish less in a month than I used to in a day. Is this how all in house jobs are or has anyone found a faster pace in house gig?

like

Hi sharks, can anyone refer me for .Net full stack profile in Optum gurgaon/noida location
Yoe 7.5 years

The button that everyone wants in MS outlook

Post Photo
likefunnyupliftingsmart

What to expect for external s1 EY FAAS interview?

like

My favorite song of the week is “The Seasons” by Freedom Fry

Can anyone explain how to calculate where you fall on the GS scale? I.e. is GS 11 for people who just graduated law school, GS-12 for those with 1/2 years experience, etc.

like

Title company just gave me a commitment with 72 B2 exceptions and the first one (after standard) is an unrecorded lease from 1862. Send help.

likefunny

Anyone looking for qa sdet/ lead roles with infy, dm me for referrals. Looking for canditates with strong handson experience in java selenium, api frameworks.

like

If you were to launch a new product campaign for a beverage in Feb/March, would you focus on spring/summer imagery or more oils that feel too premature? What cultural/timing things would you take into consideration?

like
like

Any idea about our yemlur office? When can we go ?

like

2 weeks unassigned in may. Can I use PTO for those 2 weeks even if I haven’t accrued it yet? 1st year, and what are the cons of two weeks off? Like utilization. Etc

like

The adventures of RECTANGLE MAN

Post Photo
likefunny

How much would an analyst can get in jp morgan?

YOE- 3.5
Tech- Python, SQL, Bigdata, Spark, AWS.

Offer in hand - 14ctc

like

How much UBS offers for 8+ years of exp. With counter offer of 23lpa. Kindly help.

Anyone in Montreal?

like

Additional Posts in Excel Genius

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)

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Anyone know what these badges are?

Post Photo
likefunny

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

like

How long did it take you to become good at excel? Like fast?

like

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?

like

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

like

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 😭

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

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

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

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

like

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?

likesmart

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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

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

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

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