# Excel Tips from 20 Experts

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
• Wyn Hopkins
• Cristiano Galvao
• Anne Walsh
• George Mount
• Bryan Hong
• Maria Braga
• Kasper Langmann
• Jon Peltier

You’ll definitely want to have a listen:

### Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

### 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.

1. J. Renton on February 22, 2023 at 7:26 am

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.

2. Amit on February 26, 2023 at 11:18 am

thanks for the information

3. Kanhaiyalal Newaskar. on June 20, 2023 at 1:21 am

Sir,
Thanking you very much.