Price$100$10
Total Videos Duration: 6 Hours 37 Minutes 6 Seconds
Study: 2 weeks
Requirements before you study this program:
- Good Knowledge for the basic Excel features.
- Be sure to install Excel 2013 or higher.
By the end of the program, the participants will be able to:
- Know how to work with Charts & Sparklines.
- Using Conditional Formatting
- Creating PivotTables.
- Know how to use most popular functions.
- Using Data Validation.
Language:
Arabic
Section 1Introduction
Lecture 1Data TypesFree Preview
Data Types
Duration 22:16
Refreshment from the beginners level.
Please download the practice file before you start this session.
Please send your questions to peter@egyptiancouncil.online
برجاء تحميل ملف التدريب من أخر الصفحة قبل بدء المحاضرة
للإستفسارت يرجي الإرسال إلي peter@egyptiancouncil.online
Lecture 2TablesFree Preview
Tables
Duration 8:53
Refreshment session from the beginners level.
Please download the practice file before you start this session.
Please send your questions to peter@egyptiancouncil.online
برجاء تحميل ملف التدريب من أخر الصفحة قبل بدء المحاضرة
للإستفسارت يرجي الإرسال إلي peter@egyptiancouncil.online
Section 2Charts
Lecture 3Charts Types
Lecture 4Charts Elements
Lecture 5Charts Tools
Lecture 6Charts Exam
Lecture 7Exam Solution
Section 3Sparkline
Section 4References
Lecture 9References Basics
Lecture 10Semi-absolute Reference
Lecture 11Exam Solution
Section 5Conditional Formatting
Lecture 12Ready Made Rules
Lecture 13New Rule
Lecture 14Exam
Lecture 15Exam Solution
Section 6PivotTable
Lecture 16PivotTable Basics
Lecture 17PivotTable Filters
Lecture 18PivotTable Calculations and Charts
Lecture 19Exam
Lecture 20Exam Solution
Section 7WhatIf Analysis
Lecture 21Goal Seek
Lecture 22Scenario Manager
Lecture 23Data Table
Section 8Formulas
Lecture 24Most Popular Formulas
Lecture 25Exam Solution
Lecture 26Vlookup
Lecture 27If Statement
Lecture 28SumIf, AverageIf, CountIf
Section 9Data Validation
Section 10Project