Udemy - Ten Excel Features Every Analyst Should Know

Udemy - Ten Excel Features Every Analyst Should Know

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

Description

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.

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.

Introduction
- Introduction
- Text to Column
- Flash Fill
- Record a Macro
- Group Sheets
- Delete Blanks
- Remove Duplicates
- Auto Sum
- Fill a Range
- 3D Sum
- Advanced Filter
- Bonus: Conditional Formatting