Sharing Is Caring:

Ten Excel Features Every Analyst Should Know

  • A collections of tools that should be in every analysts toolbox
  • Free tutorial
  • Rating: 4.7 out of 54.7 (8,312 ratings)
  • 84,840 students
  • 30min of on-demand video
  • Created by John MacDougall
  • English

What you’ll 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.


  • You should be familiar with the basics of Excel such as editing and entering data or formula.


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.

Who this course is for:

  • For beginners who want to learn about some key features in Excel how to apply them to common data issues.

Show less

Course content

1 section • 12 lectures • 30m total length

Introduction12 lectures • 30min

  • Introduction00:42
  • Text to Column02:10
  • Flash Fill02:24
  • Record a Macro05:08
  • Group Sheets03:01
  • Delete Blanks02:15
  • Remove Duplicates01:34
  • Auto Sum02:03
  • Fill a Range02:40
  • 3D Sum02:16
  • Advanced Filter01:43
  • Bonus: Conditional Formatting04:26
Read Also -->   Business Analytics: Analysing Third-Party Logistics Business

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

Go to Course

👇👇 See Also 👇👇

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock