Excel Tips from 20 Experts
|February 21, 2023||Chart, ChatGPT, Dynamic Arrays, Format, IFS, IMAGE, LAMBDA, PivotTable, Power Query, TEXT
My friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best Excel tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year.
This year, he rounded up tips from:
- Oz Du Soleil
- Georg Lazar
- Bill Jelen
- Kat Norton
- Jeff Lenning
- Dave Bressler
- Celia Alves
- Jon Acampora
- Ken Puls
- Yolanda Cuesta
- Jordan Goldmeier
- Ivett Szabados
- Wyn Hopkins
- Cristiano Galvao
- Anne Walsh
- George Mount
- Bryan Hong
- Maria Braga
- Kasper Langmann
- Jon Peltier
You’ll definitely want to have a listen:
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.
My favorite Excel function is summing values for a particular month from the first to last day of the month, regardless of how many days are in the month. For example, if Column A contains a list of dates, and Column B contains a list of values, and you want to sum all of the values for the current month, then the formula is:
=SUMIFS($B:$B,$A:$A,”>=”&DATE(YEAR(TODAY()),MONTH(TODAY()),1),$A:$A,”<="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1)
which essentially finds all the values where the date is greater than or equal to the first day of the month and where the date is one day less than the first day of the next month.
Thanks for sharing 🙂
thanks for the information
Sir,
Thanking you very much.
Kanhaiyalal Newaskar