NEWExcel AI Agents: use Copilot and Claude in Excel, and prove every number is right. Excel AI Agents course. See the course →

Excel — Productivity · Course on Udemy

100+ Excel tips and shortcuts that save you hours every week

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 first

30-day refund through Udemy · Lifetime access · Certificate of completion

Is this course for you?

A hundred small techniques that add up to hours saved every week.

You will get the most from it if you…

  • use Excel every day but feel slow in it
  • learned Excel on the job, without a course
  • want quick wins before moving on to dashboards or VBA
  • prefer short lessons you can watch between meetings

By the end you will be able to…

  • move around workbooks and sheets without the mouse
  • format and clean data in seconds
  • enter data faster with Flash Fill, drop-down lists and AutoCorrect
  • use formulas such as FILTER and COUNTIF to catch errors
  • summarise data with tables and pivot tables

Ready for the next step? The Excel Dashboard Masterclass builds on these skills.

Nine groups of hacks

Pick the area that slows you down most and start there.

01Interface
02Workbooks
03Worksheets
04Formatting
05Data entry
06Formulas
07Tables and pivot tables
08Visualization
09Analysis

What is inside

Every lesson is short and stands on its own, so you can dip in where you need it.

1. Interface, workbooks and worksheets

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.

2. Formatting

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.

3. Data entry

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.

4. Formulas, tables and analysis

Combining LEFT and FIND, the FILTER function, COUNTIF with data validation to block duplicates, then hacks for tables, pivot tables, charts and analysis.

What students say

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.

What is included

  • 138 video lessons, 8.5 hours
  • Project files to follow along
  • Lifetime access on any device, including the Udemy app for offline viewing
  • Certificate of completion
  • A Q&A section on every lesson
  • 30-day refund through Udemy

Your instructor

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.

Questions before you start

Anything else? Write to info@mellontraining.com.

Is it suitable for beginners?

Yes. It is made for people who know the basics and want to work faster. Each lesson is short and self-contained.

Which version of Excel do I need?

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.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free lesson on changing text case on this site, or the preview lessons on the Udemy course page.

Ready to get faster in Excel?

138 short lessons. Use the first tip today.

Enroll on Udemy →

FREE · TWO COMPLETE PACKS

Before you go: 28 Excel macros and 50 AI prompts, free

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.