Ten Excel Features Every Analyst Should Know
A collection of tools that should be in every analyst’s toolbox
What you’ll learn
Ten Excel Features Every Analyst Should Know
- 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 formulas.
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 analyst’s 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 and how to apply them to common data issues.
Add Comment