Learn Excel, develop strategy, solve business life affairs
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
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.
English
language
Content
Introduction
Introduction
For Beginners
Excel Fundamentals
Formats, Fonts and Design
Worksheet Properties
Data Management in Excel
Data Sort
Data Sort From Left to Right
Data Filter
Data Filter According to Dates
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 1
Excel Protection 2
Printer Settings
Relation of PDF and Printer
Graphics 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 1
Excel Solver 2
Excel Solver 3
Senario Analysis
Useful Tips
Cut -Copy – Paste Options
F4 Key
Fix Headers
VIEW Menu
ComboBox and Trendline
Spin Button and Animated Charts
Scroll Bar
Draw Shapes
Fix Formulas (Details of F4 Key)
Creating Custom Menu
Watch Film and Listen Music in Excel
Get Data From Other Sheets (INDIRECT Function)
Sort Data Randomly