Excel for Business Life, From Beginning to Advanced
200 students enrolled
Excel for Business Life, From Beginning to Advanced
Learn Excel, develop strategy, solve business life affairs
200 students enrolled
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
+
–
For Beginners
3 lectures
47:21
+
–
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
Preview
13:44
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
Preview
15: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
Preview
31:58
Column Graphs
12:23
Pie Chart Graphs
04:42
Picture Graphs
08:46
Graphics into the Cells
08:22