TypeOnline Course
DateJun 11, 2020 - Jun 13, 2020
Certificate60% of quiz marks
Price$300$150
Buy NowBook Now

Facebook Page

excel intermediate online
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:

Discussions: Arabic

Materials: English

Dates:

11th, 12th and 13th of June 2020

Time

10 AM : 2 PM Egypt

11 AM : 3 PM KSA

12 PM : 4 PM UAE

Certificate:

Soft Copy by Email

For the hard copy please check the price after the course.

Section 1Introduction
Lecture 1Data TypesFree Preview

Data Types

Refreshment from the beginners level.

Please download the practice file before you start this session.

Please send your questions to [email protected]

برجاء تحميل ملف التدريب من أخر الصفحة قبل بدء المحاضرة

للإستفسارت يرجي الإرسال إلي [email protected]

Lecture 2TablesFree Preview

Tables

Refreshment session from the beginners level.

Please download the practice file before you start this session.

Please send your questions to [email protected]

برجاء تحميل ملف التدريب من أخر الصفحة قبل بدء المحاضرة

للإستفسارت يرجي الإرسال إلي [email protected]

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