Excel — Productivity · Course on Udemy
Short, practical lessons you can use the same day: faster navigation, cleaner formatting, quicker data entry and formulas that do more.
★ 4.6 from 1,157 ratings on Udemy · 138 lessons · 8.5 hours
Enroll on Udemy →Watch a free lesson first30-day refund through Udemy · Lifetime access · Certificate of completion
A hundred small techniques that add up to hours saved every week.
Ready for the next step? The Excel Dashboard Masterclass builds on these skills.
Pick the area that slows you down most and start there.
Every lesson is short and stands on its own, so you can dip in where you need it.
Customising the Quick Access Toolbar and the ribbon, using the keyboard to reach the ribbon, protecting workbooks and sheets, custom views, and the very hidden sheet property.
Format Painter tricks, number formats from the keyboard, copying visible cells only, conditional formats for formula cells and alternate rows, and getting rid of duplicates.
Six ways to save time with Flash Fill, drop-down lists with conditions, Paste Special, the fill handle, freezing titles and the data entry form.
Combining LEFT and FIND, the FILTER function, COUNTIF with data validation to block duplicates, then hacks for tables, pivot tables, charts and analysis.
Reviews from students of this course on Udemy.
“I use Excel daily. So I'm an advanced user. I was surprised how many tips I didn't know. Everything was very well presented and very easy to learn. Great job from the Instructor. I'll take his other courses too!”Tom T.
“I have gained a completely different perspective on what can be done with Excel.”Jean-Pierre V.
“Supremely brilliant and comprehensive overview of MS Excel. Amazing course!”Darren O C.
Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.
More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.
Anything else? Write to info@mellontraining.com.
Yes. It is made for people who know the basics and want to work faster. Each lesson is short and self-contained.
Most tips work in any recent version of Excel. A few lessons use newer features, such as the FILTER function, which needs Microsoft 365 or Excel 2021.
On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.
Udemy offers a refund within 30 days of purchase, under its refund policy.
Yes. Watch the free lesson on changing text case on this site, or the preview lessons on the Udemy course page.
138 short lessons. Use the first tip today.
Enroll on Udemy →FREE · TWO COMPLETE PACKS
Ready-to-run macros with a practice workbook, plus the AI prompts I actually use for formulas, cleaning and analysis. Yours to keep.
No spam, ever. Unsubscribe with one click.