I am pretty good at excel but have not learned any new functions in last 8 years. What is the best way to keep up with new excel tools? Any app recommendations that give you a short 5 min tutorial daily? I don't want to spend more than 5 minutes a day.

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

Follow Miss.excel on Instagram for some quick hitter lessons

like

Attending a free session this Friday that I learned about from tiktok!

like

YouTube is great for the larger capabilities (PowerPivot, Data Models, VBA etc). As far as functions, I mainly use exceljet, really any blog that you can read the latest article each day (trumpexcel is another one). I try to incorporate the new formulas into my projects for a few days or so, see if they make sense to keep using. E.g. now I much prefer AGGREGATE over SUBTOTAL, but others I’ve abandoned (indexmatch > xlookup for my work)

likesmart

Agree same . Also utilize udemy courses to keep up with changes .

like

LinkedIn Learning’s Excel Weekly Challenge course.

like

Leila Gharani makes excellent content on YouTube. She does have paid options but they seem pricey, plus why bother when there is such good free / really cheap content.

like

Tiktok :)

like

https://vm.tiktok.com/TTPd4sSQ7r/

YouTube subscriptions for me. =Unique is a newer one I've been loving lately. Mr Excel, Leila Gharani, and a few other great channels. Watch a few videos and the Algo will suggest them from time to time.

like

Yes counta(unique(filter instead of countifs but tbh only easier to use if using named ranges

like

I like LinkedIn’s “In learning” platform

like

Learn PowerQuery and PowerPivot next.

like

I’ve learnt a lot from linked in recently.
I was in the same boat, but the covered a few new functions / formulas that are new that I didn’t know.

like

LinkedIn learning!

Watch YouTube

Related Posts

I'm curious, do straight Asian men feel any kind of way about the increase in Asian men representation being overwhelmingly queer.

like

Anyone exit or pursuing exits at a family office and willing to chat about career trajectory within that space and pivot from consulting?

like

I have a modeling test interview for A&M securities coming up. It is for the RX analyst role within their corp fin practice. I know I will have 12 hours to complete the case and it will likely be a 3 statement model. Anyone know of any specific resources I could use to prep? How tough are A&M in their modeling tests?

like

Watched Thugs of Hindustan on Amazon Prime and I am confused why this film failed.
It was not bad at all. Good one time watch.

funny

Does your hospital have swing or rotating shifts? How are the fashioned? Mine just got rid of them- thankfully!

like

Hey all - going to be taking CAMS in December. Any study tips or online resources to focus on?

like

How many days it takes to send offer letter from cognizant after pancard,previous org offer letter submission etc...??

likeuplifting

Anyone have experience with the Stuart and Lau carry briefcase? I like the look, but I'm unfamiliar with the brand. Link in first comment:

I’m stuck in the most toxic work environment which has been making me rethink everything. I want to relocate to be closer to family but has anyone just quit and moved without a job?

likehelpful

I have my first micromanager in a long, long time. How do you deal with one and also maintain your sanity?

like

Does PwC provide a work phone? Or pay for phone bill?

like

Any companies besides EY pay for Gympass??

like

US traveling through UK covid restrictions

I am traveling to Greece next week and have a 17hr layover in London. My partner is not vaccinated for a genetic health reasons. Can we leave the airport during our layover if we have negative covid tests? The info online is mixed. Thank you!

Spent a long time working for a reputable insurance defense firm before switching to plaintiff PI. Recently let go from plaintiff PI firm due to pandemic financial cutbacks. Consider myself to be a good lawyer with a small network of good connections. Not interested in going back to insurance defense. Thoughts on going solo? Live in greater LA area.

like

At my previous company, rampant f-bombs in a professional setting was tolerated and fully acceptable. What is your company's culture for language?

like

Synechron technologies Synechron Inc. Did synechron call to office ?

Hi! I was wondering if someone could help me with some advice on how I can offer my freelance services. I’m currently working as a generator of leads and booking demos and I know I can bring value to other start-up companies as I do in my job. Thanks!

like

Will Hexaware revise my offer based on hike I receive in current organization ?
Any experience ? Is there any harm in asking ?

like

Just got a promotion to go to 105k + 10% bonus unlimited PTO (trust me when I say I really use my PTO.. 😂) for embedded software engineer in Melbourne Fl. Should I start looking for a new job?

funnylike

I hate talking about people, but I like listening to others do it

likefunny

Additional Posts in Excel Genius

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

like

Do you guys use specific color scheme to make you spreadsheet looks pretty?

like

I have a spreadsheet that includes these columns: total AUM of firm X, % of AUM allocated by X to sector Y, % to sector Z, and so on (one column for each sector). Goal is to present in tabular form...

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

I have a spreadsheet downloaded from a SaaS product. Every where there is drop-down multi-select or drop-down there HTML code I need to remove and simply leave my lists. Any ideas? I thought kutools would work but apparently not?

like

How can I make these dates sortable with a filter?

Post Photo
like

Has anyone gone through Elevate Excel by Excel Campus? Looking for reviews as I'm having trouble finding any that aren't on their website....

like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

Anyone have recommendations for good hands on courses to increase proficiency in excel? I want to learn how to do vlookups better and use if/then statements and manipulate large sets of data to create dashboards. I know YouTube but I’m asking for courses that I could put down for development as part of my performance review.

like

I wonder if there is a quick guide for excel ??

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

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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