Skip to content
UdemyExcelPaid courseIntermediate level

Ten Excel Features Every Analyst Should Know (Udemy.com)

A collections of tools that should be in every analysts toolbox

Created by: John MacDougall

Last updated July 2017

icon
What you will learn

  • At the end of the course you will be familiar with and be able to use various useful Excel features that will help you save time and effort in your work.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.3 out of 5higher than 13% of them
  • Reviews9,378#44 of 356 by number of reviews
  • Length0.5 hoursshorter than 99% of them
  • Last updatedJuly 2017earlier than 87% of them

icon
Course Description

In this course we will learn about some awesome Excel features and how to use them with some examples commonly encountered by every analyst. 

  1. Text to Column
  2. Flash Fill
  3. Recording a Macro
  4. Grouping Sheet
  5. Deleting Blank Rows
  6. Remove Duplicate Data
  7. Auto Sum
  8. Filling a Range with Ctrl + Enter
  9. 3D Sums
  10. Advanced Filters

Bonus: Conditional Formatting

These tools should be in every analysts toolbox and will save you a lot of time and effort if you know how to use them should the need arise.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

John MacDougall

I've worked in Canada, Ireland, Luxembourg and the UK as an actuary for 10 years where I discovered my passion for using Excel to find the easiest solutions to my work problems. In 2016 I started an Excel websites which has since grown over a 50k following on Facebook. My interest has shifted to online technology and marketing so in 2017 I started a new career at an ad operations start up.

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.3

9,378 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By RENUKA H on 6/26/2026

I really like the concept and found it interesting. However, I think the teaching style could be improved a little. The audio quality is quite poor, which makes it difficult to follow at times.It would also be helpful if the instructor explained where each concept is used in real-life or practical situations and provided a bit more detail on the concepts themselves. Finally, a proper summary or wrap-up at the end of each lesson would make the learning experience much more complete and easier to remember. Overall, the course has great potential, and with these improvements, it could become even more effective.

By Kiley LaRue on 2/23/2026

It certainly gave me an introduction to what I am going to be doing in excel along with some handy shortcuts. Pretty good videos for an educating start for sure. Thank you to all who were a part of this and made this free course!

By Alvina Brijmohan on 11/6/2025

For me personally I find it rather easy to understand and it is being explained very beautifully with more than one example of how to do a certain task. Thank you so much for your time and assistance in helping us learn, much appreciated.

By Vickie Mccune on 4/29/2020

Loved this course. Simplicity at it's best - 'simply' provided information in easy to understand tutorial which provides immediate real life application. The resources were up to date and easy to use - loved this course.

By Tyler Ward on 8/2/2018

Very clear and helpful in describing all of the concepts. What can be improved on this course is that you should do a course where you teach graphing for data analysis where we learn to build graphs with the data and learn data modeling in order to use it to help make insightful decisions, also financial modeling on excel would be helpful, other than that, the course was very helpful.

By Heather on 4/13/2018

Good information with solid explanations. I'm not sure this qualifies as Excel "Analyst" level (which I feel is an advanced level). These tips were more Excel "Intermediate". But I will certainly be directing a few of my colleagues to this instruction. Good job

By Lean Liam on 3/2/2018

It's true, every beginner analyst should know these Excel features. I think he could have expanded a bit more on some to include variety of rows and columns for the grouping topics or at least state that it may not be possible if there are different rows. Otherwise, it was easy to follow. Thanks.

By Ekundayo Mariam Modupeola on 2/27/2018

I LEARNT HOW TO SEPERATE TEXT IN THE SAME COLUMN (TEXT TO COLUMN),HOW TO OPERATE FLASH FILL,RECORD THE MACRO, GROUPING SHEETS, DELETING BLANKS, REMOVING DUPLICATES,AUTO SUM, FILL A RANGE, 3D SUM, ADVANCED FILTER AND CONDITIONAL FORMATTING.

By Rekha on 12/4/2017

this course is useful for beginners and intermediates, I learnt only some points from this course. Please explain in-depth macro and VBA like how to prepare macros.

By Angela Alfonso on 10/23/2017

I thought this was too basic for me but then even I learnt a few new things so thank you. If I can Just say the sound was not great but audible at speakers set at 100%. Also the speed I set it to 2 and felt it was still a bit slow. But nonetheless the content as great. thank you

Showing all 10 reviews on CourseDuck

Read all 9,378 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100