Ten Excel Features Every Analyst Should Know
4.3 (98 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,504 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox
4.3 (98 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent 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
  • Full lifetime access
  • 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
  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.

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
+
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

Add totals to your data quickly using auto sum.

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.

Advanced Filter
01:43

Learn how to use conditional formatting to highlight your data based on certain criteria.

Bonus: Conditional Formatting
04:26
About the Instructor
John MacDougall
4.3 Average rating
88 Reviews
1,504 Students
1 Course
Former Actuary

I've worked in Canada, Ireland, Luxembourg and the UK as an actuary for 10 years where I discovered my passion for using Excel to find the easiest solutions to my work problems. In 2016 I started an Excel websites which has since grown a 38k following on Facebook. My interest has shifted to online technology and marketing so in 2017 I started a new career at an online advertising start up.