Ten Excel Features Every Analyst Should Know
4.3 (98 ratings)
1,504 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ten Excel Features Every Analyst Should Know to your Wishlist.

Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox
4.3 (98 ratings)
1,504 students enrolled
Created by John MacDougall
Last updated 7/2017
English
Price: Free
Includes:
• 30 mins on-demand video
• 12 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
What Will I 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.
View Curriculum
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

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 is the target audience?
• For beginners who want to learn about some key features in Excel how to apply them to common data issues.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
30:22
+
Introduction
12 Lectures 30:22

Follow along with the course using the provided workbook.

Introduction
00:42

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.

Text to Column
02:10

Flash fill is a great tool for automatically filling out data when it senses a pattern.

Flash Fill
02:24

Recording macros can automate your repetitive tasks and can also be a good way to start learning VBA.

Record a Macro
05:08

Learn how to group sheets together to make the changes across multiple sheets.

Group Sheets
03:01

Use the Go To command to delete blank rows in your data.

Delete Blanks
02:15

Learn how to remove duplicate rows from your data.

Remove Duplicates
01:34

Auto Sum
02:03

Quickly fill blank data with the Go To command and the Ctrl + Enter keyboard shortcut.

Fill a Range
02:40

Learn how to sum across multiple sheets without individually referencing them.

3D Sum
02:16

Get the unique items in a list using advanced filter.