Excel Advanced



دورات الكمبيوتر التصنيف
المستوى
السعر قبل الخصم
LE. 600 السعر بعد الخصم
Tarek Bondok المحاضر
الشهادة رابط الشهادة

 

 

 

03 39 25 333

+2 0128 16 2 16 12

tarek.bondok@coveris.com

COURSE INFORMATION

  • The duration of this course is 32 hours distributed over 16 days
  • A computer for each trainee.

LEARNING OUTCOMES

At the end of the course, you will be able to work with:

 Pivot Tables and Pivot Charts.

  • Analyzing data dynamically by using Pivot Tables.
  • Filtering, showing, and hiding Pivot Table data.
  • Editing Pivot Tables.
  • Formatting Pivot Tables.
  • Creating Pivot Tables from external data.
  • Creating dynamic charts by using Pivot Charts.

Count.

  • Count cells between dates.
  • Count cells between two numbers.
  • Count cells equal to.
  • Count cells equal to case sensitive.
  • Count cells equal to either x or y.
  • Count cells equal to one of many things.
  • Count cells greater than.
  • Count cells less than.
  • Count cells not equal to.

Sum.

  • SUMIF.
  • SUMIFCOUNTIF.
  • SUMPRODUCT.
  • Sum by month.
  • Sum by week.
  • Sum by week number.
  • Sum by weekday.
  • Sum if between.
  • Sum if by year.
  • SUMIFSDATE.
  • Sum if cell contains text in another cell.
  • Sum if cells are equal to.
  • Sum if cells are not equal to.
  • Sum if cells contain an asterisk.
  • Sum if cells contain specific text.
  • Sum if date is between.
  • Sum if date is greater than.
  • Sum if greater than.
  • Sum if less than.
  • Sum if not blank.
  • SUBTOTAL.

 Average.

Min And Max.

Vlookup.

Hlookup.

Date.

Time.

 



طلب الدورة التدريبية