Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox

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.

Course Information

Tags: ,

Course Instructor

Courseis.is
Courseis.is Author

Find what your next course is. We will help you find course, get skilled, and get hired.

This course does not have any sections.

Course Information

Tags: ,