Top 10 Excel functions for Business/Finance/Accounting Users
4.2 (500 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
28,077 students enrolled

Top 10 Excel functions for Business/Finance/Accounting Users

Most Used Quality functions of Excel in 30 minutes
4.2 (500 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
28,077 students enrolled
Created by Irfan Sharif
Last updated 7/2020
English
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 30 mins on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Microsoft Excel
Requirements
  • Basic knowledge of excel will be helpful.
Description

Microsoft Excel has hundreds of functions and formulas to store, analyze, and alter data efficiently. However, no one really needs to know all of them to be able to work effectively on Excel.

In this course, you will learn key functions that are required most used by business users when they are working with their business data. These functions include finding, replacing, sorting, filtering, summarizing, and analyzing data. Additionally, you will also learn how to bring in a particular data against a specific row parameter from other excel sheets.

Who this course is for:
  • Business users who have basic knowledge of Excel, but need to handle data effeciently
Course content
Expand 10 lectures 30:12
+ Introduction
10 lectures 30:12

Excel has hundreds of functions and features, but as a business user, you do not have to master every single of them. Let's discuss what to expect in this course.

Preview 01:08

You can replace any particular word with another in excel just in two quick steps! In this lecture, you will learn this quick 'find and replace' trick.

Preview 05:11

You can sort your data in excel in almost any order you like. Each column can be sorted and there are some advanced sorting options like sorting levels. Let's explore further in this lecture.

Preview 02:50

Filters are a powerful way to analyze a particular type of data at a time. Excel offers some advanced filters like filtering range. Let's take a look at filters in more detail.

Preview 02:41

You can fix a cell in a formula, or you can keep it open for excel to dynamically calculate values. It is one of the most used features with excel formulas!

Relative and Absolute Reference
04:06

It is never easier to compile data from different files to one excel sheet. Vlookup is a powerful excel function that allows you to bring together data from different files to one sheet in a very efficient manner.

Vlookup
04:59

You can quickly add formats and icons on data by adding some smart conditions. Make your data more meaningful and easier to read by just adding some smart conditional formatting.

Conditional Formatting
02:46

You can analyze data on multiple conditions just by dragging them! Pivot table are one of the most powerful features of Excel.

Preview 03:00

Do you need to add subtotals to some criteria? Well, you can do it in just two clicks!

Subtotals
01:31

Tables make it easier to manage data and keep the totals intact even when the data in table changes. Let's take a look.

Adding tables
02:00