Excel for Business
0.0 (0 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.
0 students enrolled

Excel for Business

Become an expert in the most used software in the world!
0.0 (0 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.
0 students enrolled
Created by Grupo Voitto
Last updated 7/2018
English
English [Auto-generated]
Price: $39.99
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 36 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
  • The MS Excel for Business course provides complete immersion in this software so valued by the job market. This course provides a 100% practical approach. If you have never had contact with the software, will learn to use basic functions right in the first classes and be capable of creating management dashboards at the end of the course. And if you already know something about this tool, you will certainly develop new skills and discover new functions that will make you even more productive and confident when using MS Excel. At the end of the course, you’ll be able to analyze large volumes of data! You’ll know how to create tools to make accurate decisions, dynamic charts and even record macros to make your work more productive!
Requirements
  • You’ll need to have a version of Microsoft Excel on your computer. If your version is old, some items taught in this course may not work properly.
Description

MS Excel is a spreadsheet software widely used by companies and activities around the world for stock control, database creation, simple and complex analysis, among thousands of other functions.

The knowledge of MS Excel is essential for any professional and can be a differential in the job market. While it is a powerful tool, it does not work alone, it takes a professional who is qualified to use their resources to the fullest.

During this course, you will see:

  • Activities from basic to advanced levels by solving problems of different levels of difficulty;

  • 80 Features and Functions and more than 30 chart variations;

  • More than 100 exercises and examples contextualized with the corporate world;

  • The dynamic methodology with 100% of the time applied in Microsoft Excel software;

  • Solving examples together with the instructor sharing all your practical experience;

  • Drills at the end of each module to consolidate knowledge;


Who this course is for:
  • This course is intended for both those who don´t have any knowledge of Excel and those who already use the software but want to develop the advanced skills to become able to solve from simple to complex problems in a fast and effective way.
Course content
Expand all 107 lectures 08:13:08
+ 1st Module: Introduction to Elements
7 lectures 29:45
Lesson 3 - Paste link
04:48
Lesson 4 - Introduction to basic formulas
05:05
Lesson 5 - Introduction to basic functions
02:38
Lesson 6 - Exercise 1
01:07
Lesson 7 - Answer Exercise 1
02:53
+ 2nd Module: Manipulating Sheets
6 lectures 34:22
Lesson 1: Introduction to Sheets
07:01
Lesson 2: Hyperlinks
07:03
Lesson 3: Autofill
07:40
Lesson 4: Fixing Cells
04:43
Lesson 5: Exercise
01:57
Answer Excercise
05:58
+ 3rd Module: Organizing Information
7 lectures 33:10
Lesson 1: Freezing Panes
06:00
Lesson 2: Data Validation
07:35
Lesson 3: Protect Sheet
08:11
Lesson 4: Data consolidation
02:46
Lesson 5: Subtotal
03:33
Lesson 6: Exercise
01:36
Answer Exercise
03:29
+ 4th Module: Basic Functions
11 lectures 58:17
Lesson 1: Function “if”
06:09
Lesson 2: Functions “and” & “or”
07:42
Lesson 3: Compounded Function “if”
04:24
Lesson 4: Functions “sumif” & “countif”
04:14
Lesson 5: Function “countifs”
05:16
Lesson 6: Function “sumifs”
04:00
Lesson 7: Function “iferror”
04:33
Lesson 8 - Part 1: Conditional Formatting
07:16
Lesson 8 - Part 2: Conditional Formatting
03:36
Lesson 9: Exercise
02:20
Answer Exercise
08:47
+ 5th Module: Advanced Functions
13 lectures 58:25
Lesson 1: Function “vlookup”
08:54
Lesson 2: Function “hlookup”
06:32
Lesson 3: Time Functions
07:36
Lesson 4: Functions “left” & “right”
03:20
Lesson 5 - Part 1: Function “search”
05:09
Lesson 5 - Part 2: Function “search”
05:25
Lesson 6: Audit Cells
02:30
Lesson 7: Exercise 1
01:41
Answer Exercise 1
03:12
Lesson 8: Exercise 2
01:59
Answer Exercise 2
04:33
Lesson 9: Exercise 3
02:04
Answer Exercise 3
05:30
+ 6th Module: Basic Charts
4 lectures 16:30
Lesson 1: Introduction to Charts
07:09
Lesson 2: Creating Charts
05:13
Lesson 3: Exercise
00:43
Answer Exercise
03:25
+ 7th Module: Pivot Tables
6 lectures 22:49
Lesson 1 - Part 1: Pivot Table
07:32
Lesson 1 - Part 2: Pivot Table
06:47
Lesson 2: Exercise 1
00:52
Answer Exercise 1
02:28
Lesson 3: Exercise 2
01:03
Answer Exercise 2
04:07
+ 8th Module: External Data
4 lectures 15:03
Lesson 1: Converting Excel File in Web Page
04:20
Lesson 2: Importing Data
05:24
Lesson 3: Exercise
00:58
Answer Exercise
04:21
+ 9th Module: Advanced Charts
17 lectures 01:14:52
Lesson 1: Seasonal Sales Chart
10:06
Lesson 2: Revenue x Target Chart
04:13
Lesson 3 - Part 1: Pareto Chart
07:47
Lesson 3 - Part 2: Pareto Chart
03:48
Lesson 4: Build up Chart
05:58
Lesson 5: Build down Chart
02:50
Lesson 6: Radar Chart
03:01
Lesson 7: Schedule
06:30
Lesson 8: Seasonality in Sales Chart
06:26
Lesson 9 - Part 1: Control Charts
08:04
Lesson 9 - Part 2: Control Charts
02:20
Lesson 10: Exercise 1
01:11
Answer Exercise 1
03:27
Lesson 11: Exercise 2
00:38
Answer Exercise 2
06:03
Lesson 12: Exercise 3
00:41
Answer Exercise 3
01:49
+ 10th Module: Finantial and Statistic Formulas
14 lectures 01:13:36
Lesson 1 - Part 1: PMT Function
06:02
Lesson 1 - Part 2: PMT Function
05:32
Lesson 1 - Part 3: PMT Function
04:11
Lesson 2 - Part 1: PV, IRR, NPV, NPER Functions
06:02
Lesson 2 - Part 2: PV, IRR, NPV, NPER Functions
08:02
Lesson 3: Count.Value Function
06:19
Lesson 4: Trend Measurements Function
06:40
Lesson 5 - Part 1: Quartile and Percentile
06:49
Lesson 5 - Part 2: Quartile and Percentile
03:37
Lesson 6: Nominating Cells and Ranges of Cells
06:47
Lesson 7: Exercise 1
01:22
Answer Exercise 1
03:19
Lesson 8: Exercise 2
00:50
Answer Exercise 2
08:04