Excel for Business Life, From Beginning to Advanced
4.4 (21 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.
200 students enrolled

Excel for Business Life, From Beginning to Advanced

Learn Excel, develop strategy, solve business life affairs
4.4 (21 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.
200 students enrolled
Created by Kenan Çılman
Last updated 8/2019
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 13 hours on-demand video
  • 68 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
  • Excel Fundamentals
  • Formats, Fonts and Design
  • Worksheet Properties
  • Data Management in Excel
  • Data Sort
  • Data Sort From Left to Right
  • Data Filter
  • Table
  • Remove Dublicates
  • Custom List
  • Subtotal and Data Groups
  • Pivot Table
  • Pivot Table Properties and Options
  • User Defined Formulas in Pivot Table
  • Merge Pivot Tables
  • Excel Formulas
  • Structure of Excel Formulas
  • Text Formulas
  • Flash Fill
  • Statistical Formulas
  • Date and Time Formulas
  • SUBTOTAL Function For Filter
  • Lookup Functions
  • VLOOKUP For 2 Tables
  • Advanced Filter Functions
  • FORMULAS Menu
  • Advanced Excel
  • Data Validation
  • Conditional Formatting
  • Special Cells (GOTO SPECIAL)
  • External Data From Other Sources
  • Name Manager
  • Consolidation
  • Watch Window and Trace Cells
  • Excel Protection
  • Printer Settings
  • Relation of PDF and Printer
  • Graphics and Charts in Excel
  • Simple Graphs
  • Column Graphs
  • Pie Chart Graphs
  • Picture Graphs
  • Graphics into the Cells
  • Linear Modelling in Excel
  • Goal Seek
  • What-if Analysis / Data Table
  • Excel Solver
  • Senario Analysis
  • Useful Tips
  • Copy - Paste Options
  • F4 Key
  • Fix Headers
  • VIEW Menu
  • ComboBox
  • Trendline
  • Spin Button
  • Animated Charts
  • Scroll Bar
  • Draw Shapes
  • Fix Formulas (Details of F4 Key)
  • Creating Custom Menu
  • Watch Movie and Listen Music in Excel
Requirements
  • You just need to know that you need Excel to take this course.
Description

This course is ideal for anyone who wants to learn Excel. The course is designed with an understandable and easy in English. The main goal of the course is to teach all the requirements you need in business life and to use Excel in the most efficient manner.

All videos here have examples and Excel files, and all of them are examples of real business life.

Who this course is for:
  • Every employee that uses Excel
Course content
Expand all 61 lectures 12:58:38
+ Data Management in Excel
12 lectures 02:39:44
Data Filter
15:56
Data Filter According to Dates
04:13
Table
09:55
Remove Dublicates
03:39
Custom List
08:23
Subtotal and Data Groups
10:44
Pivot Table
48:14
Pivot Table Properties and Options
18:14
User Defined Formulas in Pivot Table
04:22
Merge Pivot Tables
13:12
+ Excel Formulas
10 lectures 03:04:31
Structure of Excel Formulas
08:49
Text Formulas
30:38
Statistical Formulas
43:33
Date and Time Formulas
27:26
SUBTOTAL Function For Filter
07:42
Lookup Functions
20:37
VLOOKUP For 2 Tables
04:53
Advanced Filter Functions
22:26
FORMULAS Menu
04:43
+ Advanced Excel
11 lectures 02:37:10
Special Cells (GOTO SPECIAL)
16:21
External Data From Other Sources
18:46
Name Manager
23:13
Consolidation
13:03
Watch Window and Trace Cells
11:27
Excel Protection 1
06:15
Excel Protection 2
05:06
Printer Settings
20:18
Relation of PDF and Printer
01:20
+ Graphics in Excel
5 lectures 01:06:11
Column Graphs
12:23
Pie Chart Graphs
04:42
Picture Graphs
08:46
Graphics into the Cells
08:22
+ Linear Modelling in Excel
6 lectures 55:25
What-if Analysis / Data Table
05:51
Excel Solver 1
15:06
Excel Solver 2
08:08
Excel Solver 3
08:10
Senario Analysis
10:33