Forum Discussion
Professor said HAS to be done with SUMIF function. Combine Salary of those named Steve. NO IDEA here
Excel sheet looks like this: A B 1 Name Salary 2 Steve M. $1,000 3 Mary J. $2,800 4 Joe R. ...
This will help you arrive at the solution without giving the answer.
https://exceljet.net/formulas/sum-if-cells-contain-specific-text
https://exceljet.net/formulas/sum-if-cells-contain-specific-text
- Thank you as well.
There is so much to this and I enjoy finding out, learning, and hunting down answers doing my own thing.
Even though it frustrates in greatly, haha.
Is there any way to learn ALL of Excel, such as becoming a master at it in a year or two on your own besides the only route I can think of: Buying books, MANY hours of practice and exercises, tutors, etc.
There any useful/helpful tools, sites, or anything/anyone that anyone can recommend to help someone like me learn all about this to master it?
Probably take me a few years or decades, but I'm persistent.
Thanks to you both, greatly.
Very much appreciated.- Andy, as long as you have a way to APPLY and USE excel constantly, you will pick it up and build your foundation and grow. You cant take a class and never use the skills or practice and expect to be proficient, so being able to apply what you are learning on an ongoing basis is KEY, just my opinion.
With that being said, sure Microsoft has available documentation and there are forums like this but I have found the most valuable resource to be You Tube University. Theres a gajillion videos on use case specific needs that take you through and show you step by step how to accomplish your need.
Additionally you can pick up a lot of quick tips, tricks and shortcuts from Tik Tok! Somehow the algorithm showed me a couple Power BI and Excel posts and I followed them and soon after I started seeing all sorts of 1-2 minute videos on daily time/life saving hacks/tips/tricks!
Just keep at it and you will get there 🙂- I agree with you and I have been using youtube videos to help me understand.
The changing language/terms (or unspecific and confusing language from teachers) for assignments messes me up half the time.
I don't use tiktok but good to know.
Thanks for the info, always helpful and appreciated.
- Learning all of Excel in a year or two is asking a lot. I'd estimate it may take several thousand hours of study and with Excel there's always something more to learn.
It helps if you have access to instructors and resources that really know the application. Did your professor happen to mention 'wildcard' at any point during class?- I figured, haha. People probably spend 5-10 years to maser Excel.
He did not mention Wildcard. What is that?
- Thanks again to you both.
You steered me in the right direction and that was all I needed.
I got it.
You guys helped me learn something new with Excel, this is the information I was looking for to help me the last few hours, I just didn't know the name of it or where to find it.
Thanks again, so much.
You're awesome.
