Excel for Business Life, From Beginning to Advanced
Learn Excel, develop strategy, solve business life affairs
4.75 (50 reviews)
1,979
students
13 hours
content
Aug 2019
last update
$64.99
regular price
What you will 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
Why take this course?
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.
Screenshots
Reviews
Chris
April 15, 2020
I have been using Excel since it first came out. I am reasonably proficient with it. I did not expect to get much out of the first section of this course (the beginner section) but I have already discovered 6-7 tips/shortcuts that I wasn't aware existed. Good course so far.
Johnson
October 11, 2019
Great Job here. I am not done with the course, but I must say I have been searching for a course as detailed as this, I am more than satisfied.
Charts
Price
Rating
Enrollment distribution
Related Topics
2478708
udemy ID
7/26/2019
course created date
8/22/2019
course indexed date
Bot
course submited by