Ten Excel Features Every Analyst Should Know

Name: Ten Excel Features Every Analyst Should Know
Rating: 4.5 (9313 reviews)

A collections of tools that should be in every analysts toolbox

Last updated 7/2017

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.

1 section • 12 lectures • 30m total length

Introduction0:42
Follow along with the course using the provided workbook.
Text to Column2:10
Text to Columns can be used to separate or parse data from a single column into multiple columns and is a key tool to have in your toolbox for data manipulation. In this video we're going to look at an example involving parsing out a comma separated list in a single cell.
Flash Fill2:24
Flash fill is a great tool for automatically filling out data when it senses a pattern.
Record a Macro5:08
Recording macros can automate your repetitive tasks and can also be a good way to start learning VBA.
Group Sheets3:01
Learn how to group sheets together to make the changes across multiple sheets.
Delete Blanks2:15
Use the Go To command to delete blank rows in your data.
Remove Duplicates1:34
Learn how to remove duplicate rows from your data.
Auto Sum2:03
Add totals to your data quickly using auto sum.
Fill a Range2:40
Quickly fill blank data with the Go To command and the Ctrl + Enter keyboard shortcut.
3D Sum2:16
Learn how to sum across multiple sheets without individually referencing them.
Advanced Filter1:43
Get the unique items in a list using advanced filter.
Bonus: Conditional Formatting4:26
Learn how to use conditional formatting to highlight your data based on certain criteria.

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.

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.

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