TypeOnline Course
Student Enrolled18
Certificate60% of quiz marks
Price$100$10
Buy NowBook Now

Facebook Page

Excel Intermediate Level

Total Videos Duration: 6 Hours 37 Minutes 6 Seconds

Study: 2 weeks

Requirements before you study this program:
  1. Good Knowledge for the basic Excel features.
  2. Be sure to install Excel 2013 or higher.
By the end of the program, the participants will be able to:
  1. Know how to work with Charts & Sparklines.
  2. Using Conditional Formatting
  3. Creating PivotTables.
  4. Know how to use most popular functions.
  5. 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

Leave a Reply