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
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
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.
- Text to Column
- Flash Fill
- Recording a Macro
- Grouping Sheet
- Deleting Blank Rows
- Remove Duplicate Data
- Auto Sum
- Filling a Range with Ctrl + Enter
- 3D Sums
- 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.
Instructor Details
- 4.3 Rating
9,378 Reviews
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.
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
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
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 86 / 100






