Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox
Rating: 4.4 out of 5 (6,700 ratings)
58,468 students
Ten Excel Features Every Analyst Should Know
Rating: 4.4 out of 5 (6,700 ratings)
58,468 students
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.

Requirements

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

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.

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.

Course content

1 section • 12 lectures • 30m total length
  • Introduction
    00:42
  • Text to Column
    02:10
  • Flash Fill
    02:24
  • Record a Macro
    05:08
  • Group Sheets
    03:01
  • Delete Blanks
    02:15
  • Remove Duplicates
    01:34
  • Auto Sum
    02:03
  • Fill a Range
    02:40
  • 3D Sum
    02:16
  • Advanced Filter
    01:43
  • Bonus: Conditional Formatting
    04:26

Instructor

Microsoft Excel MVP
John MacDougall
  • 4.4 Instructor Rating
  • 6,700 Reviews
  • 59,202 Students
  • 1 Course

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.