❞ كتاب شيق جدا يشرح كل معادلات الاكسيل ❝

❞ كتاب شيق جدا يشرح كل معادلات الاكسيل ❝

كتاب يشرح كل معادلات الاكسيل بالامثلة .

Microsoft Excel
Functions & Formulas
Bernd Held
Wordware Publishing, Inc

Contents
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Chapter 1
Formulas in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Production per hour. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Calculate the age of a person in days . . . . . . . . . . . . . . . . . . . . . . 3
Calculate a price reduction . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Convert currency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Convert from hours to minutes. . . . . . . . . . . . . . . . . . . . . . . . . 6
Determine fuel consumption . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Calculate your ideal and recommended weight. . . . . . . . . . . . . . . . . 8
The quick calendar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Design your own to-do list. . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Incrementing row numbers . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Convert negative values to positive . . . . . . . . . . . . . . . . . . . . . . 12
Calculate taxes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Combine text and numbers . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Combine text and date. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Combine text and time. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
A special ranking list. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Determine the average output. . . . . . . . . . . . . . . . . . . . . . . . . 18
Stocks—gains and losses. . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Evaluate profitability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Determine percentage of completion . . . . . . . . . . . . . . . . . . . . . 21
Convert miles per hour to km per hour . . . . . . . . . . . . . . . . . . . . 22
Convert feet per minute to meters per second . . . . . . . . . . . . . . . . 23
Convert liters to barrels, gallons, quarts, and pints . . . . . . . . . . . . . . 24
Convert from Fahrenheit to Celsius. . . . . . . . . . . . . . . . . . . . . . 25
Convert from Celsius to Fahrenheit. . . . . . . . . . . . . . . . . . . . . . 26
Calculation with percentage . . . . . . . . . . . . . . . . . . . . . . . . . . 27
Monitor the daily production plan . . . . . . . . . . . . . . . . . . . . . . . 28
Calculate number of hours between two dates . . . . . . . . . . . . . . . . 29
Determine the price per pound . . . . . . . . . . . . . . . . . . . . . . . . 30
Determine how many pieces to put in a box . . . . . . . . . . . . . . . . . 31
Calculate manpower required for a project . . . . . . . . . . . . . . . . . . 32
Distribute sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Calculate your net income. . . . . . . . . . . . . . . . . . . . . . . . . . . 34
iii
Calculate percentage of price reduction . . . . . . . . . . . . . . . . . . . . 35
Doubling every three hours . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Calculate the average speed. . . . . . . . . . . . . . . . . . . . . . . . . . 37
Chapter 2
Logical Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Use the AND function to compare two columns . . . . . . . . . . . . . . . 40
Use the AND function to show sales for a specific period of time . . . . . . 41
Use the OR function to check cells for text . . . . . . . . . . . . . . . . . . 42
Use the OR function to check cells for numbers . . . . . . . . . . . . . . . 43
Use the IF function to compare columns and return a specific result . . . . 44
Use the IF function to check for larger, equivalent, or smaller values . . . . 45
Combine IF with AND to check several conditions. . . . . . . . . . . . . . 46
Use the IF function to determine the quarter of a year . . . . . . . . . . . . 47
Use the IF function to check cells in worksheets and workbooks . . . . . . 48
Use the IF function to calculate with different tax rates . . . . . . . . . . . 49
Use the IF function to calculate the commissions for individual sales . . . . 50
Use the IF function to compare two cells . . . . . . . . . . . . . . . . . . . 51
Use the INT function with the IF function . . . . . . . . . . . . . . . . . . 52
Use the TYPE function to check for invalid values . . . . . . . . . . . . . . 53
Use the IF function combined in one cell more than seven times . . . . . . 54
Use the IF function to check whether a date is in the past or future . . . . . 55
Use the IF function to create your own timesheet . . . . . . . . . -
من كتب مايكروسوفت إكسل كتب ICDL والبرامج المكتبية - مكتبة كتب تقنية المعلومات.

نبذة عن الكتاب:
شيق جدا يشرح كل معادلات الاكسيل

2006م - 1445هـ
كتاب يشرح كل معادلات الاكسيل بالامثلة .

Microsoft Excel
Functions & Formulas
Bernd Held
Wordware Publishing, Inc

Contents
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Chapter 1
Formulas in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Production per hour. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Calculate the age of a person in days . . . . . . . . . . . . . . . . . . . . . . 3
Calculate a price reduction . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Convert currency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Convert from hours to minutes. . . . . . . . . . . . . . . . . . . . . . . . . 6
Determine fuel consumption . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Calculate your ideal and recommended weight. . . . . . . . . . . . . . . . . 8
The quick calendar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Design your own to-do list. . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Incrementing row numbers . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Convert negative values to positive . . . . . . . . . . . . . . . . . . . . . . 12
Calculate taxes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Combine text and numbers . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Combine text and date. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Combine text and time. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
A special ranking list. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Determine the average output. . . . . . . . . . . . . . . . . . . . . . . . . 18
Stocks—gains and losses. . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Evaluate profitability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Determine percentage of completion . . . . . . . . . . . . . . . . . . . . . 21
Convert miles per hour to km per hour . . . . . . . . . . . . . . . . . . . . 22
Convert feet per minute to meters per second . . . . . . . . . . . . . . . . 23
Convert liters to barrels, gallons, quarts, and pints . . . . . . . . . . . . . . 24
Convert from Fahrenheit to Celsius. . . . . . . . . . . . . . . . . . . . . . 25
Convert from Celsius to Fahrenheit. . . . . . . . . . . . . . . . . . . . . . 26
Calculation with percentage . . . . . . . . . . . . . . . . . . . . . . . . . . 27
Monitor the daily production plan . . . . . . . . . . . . . . . . . . . . . . . 28
Calculate number of hours between two dates . . . . . . . . . . . . . . . . 29
Determine the price per pound . . . . . . . . . . . . . . . . . . . . . . . . 30
Determine how many pieces to put in a box . . . . . . . . . . . . . . . . . 31
Calculate manpower required for a project . . . . . . . . . . . . . . . . . . 32
Distribute sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Calculate your net income. . . . . . . . . . . . . . . . . . . . . . . . . . . 34
iii
Calculate percentage of price reduction . . . . . . . . . . . . . . . . . . . . 35
Doubling every three hours . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Calculate the average speed. . . . . . . . . . . . . . . . . . . . . . . . . . 37
Chapter 2
Logical Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Use the AND function to compare two columns . . . . . . . . . . . . . . . 40
Use the AND function to show sales for a specific period of time . . . . . . 41
Use the OR function to check cells for text . . . . . . . . . . . . . . . . . . 42
Use the OR function to check cells for numbers . . . . . . . . . . . . . . . 43
Use the IF function to compare columns and return a specific result . . . . 44
Use the IF function to check for larger, equivalent, or smaller values . . . . 45
Combine IF with AND to check several conditions. . . . . . . . . . . . . . 46
Use the IF function to determine the quarter of a year . . . . . . . . . . . . 47
Use the IF function to check cells in worksheets and workbooks . . . . . . 48
Use the IF function to calculate with different tax rates . . . . . . . . . . . 49
Use the IF function to calculate the commissions for individual sales . . . . 50
Use the IF function to compare two cells . . . . . . . . . . . . . . . . . . . 51
Use the INT function with the IF function . . . . . . . . . . . . . . . . . . 52
Use the TYPE function to check for invalid values . . . . . . . . . . . . . . 53
Use the IF function combined in one cell more than seven times . . . . . . 54
Use the IF function to check whether a date is in the past or future . . . . . 55
Use the IF function to create your own timesheet . . . . . . . . .
.
المزيد..

تعليقات القرّاء:


     

يشرح كل معادلات الاكسيل بالامثلة

كتاب يشرح كل معادلات الاكسيل بالامثلة .

Microsoft Excel
Functions & Formulas
Bernd Held
Wordware Publishing, Inc

Contents
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Chapter 1
Formulas in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Production per hour. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Calculate the age of a person in days . . . . . . . . . . . . . . . . . . . . . . 3
Calculate a price reduction . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Convert currency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Convert from hours to minutes. . . . . . . . . . . . . . . . . . . . . . . . . 6
Determine fuel consumption . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Calculate your ideal and recommended weight. . . . . . . . . . . . . . . . . 8
The quick calendar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Design your own to-do list. . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Incrementing row numbers . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Convert negative values to positive . . . . . . . . . . . . . . . . . . . . . . 12
Calculate taxes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Combine text and numbers . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Combine text and date. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Combine text and time. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
A special ranking list. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Determine the average output. . . . . . . . . . . . . . . . . . . . . . . . . 18
Stocks—gains and losses. . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Evaluate profitability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Determine percentage of completion . . . . . . . . . . . . . . . . . . . . . 21
Convert miles per hour to km per hour . . . . . . . . . . . . . . . . . . . . 22
Convert feet per minute to meters per second . . . . . . . . . . . . . . . . 23
Convert liters to barrels, gallons, quarts, and pints . . . . . . . . . . . . . . 24
Convert from Fahrenheit to Celsius. . . . . . . . . . . . . . . . . . . . . . 25
Convert from Celsius to Fahrenheit. . . . . . . . . . . . . . . . . . . . . . 26
Calculation with percentage . . . . . . . . . . . . . . . . . . . . . . . . . . 27
Monitor the daily production plan . . . . . . . . . . . . . . . . . . . . . . . 28
Calculate number of hours between two dates . . . . . . . . . . . . . . . . 29
Determine the price per pound . . . . . . . . . . . . . . . . . . . . . . . . 30
Determine how many pieces to put in a box . . . . . . . . . . . . . . . . . 31
Calculate manpower required for a project . . . . . . . . . . . . . . . . . . 32
Distribute sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Calculate your net income. . . . . . . . . . . . . . . . . . . . . . . . . . . 34
iii
Calculate percentage of price reduction . . . . . . . . . . . . . . . . . . . . 35
Doubling every three hours . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Calculate the average speed. . . . . . . . . . . . . . . . . . . . . . . . . . 37
Chapter 2
Logical Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Use the AND function to compare two columns . . . . . . . . . . . . . . . 40
Use the AND function to show sales for a specific period of time . . . . . . 41
Use the OR function to check cells for text . . . . . . . . . . . . . . . . . . 42
Use the OR function to check cells for numbers . . . . . . . . . . . . . . . 43
Use the IF function to compare columns and return a specific result . . . . 44
Use the IF function to check for larger, equivalent, or smaller values . . . . 45
Combine IF with AND to check several conditions. . . . . . . . . . . . . . 46
Use the IF function to determine the quarter of a year . . . . . . . . . . . . 47
Use the IF function to check cells in worksheets and workbooks . . . . . . 48
Use the IF function to calculate with different tax rates . . . . . . . . . . . 49
Use the IF function to calculate the commissions for individual sales . . . . 50
Use the IF function to compare two cells . . . . . . . . . . . . . . . . . . . 51
Use the INT function with the IF function . . . . . . . . . . . . . . . . . . 52
Use the TYPE function to check for invalid values . . . . . . . . . . . . . . 53
Use the IF function combined in one cell more than seven times . . . . . . 54
Use the IF function to check whether a date is in the past or future . . . . . 55
Use the IF function to create your own timesheet . . . . . . . . .
 



سنة النشر : 2006م / 1427هـ .
حجم الكتاب عند التحميل : 12 كيلوبايت .
نوع الكتاب : ppt.
عداد القراءة: عدد قراءة شيق جدا يشرح كل معادلات الاكسيل

اذا اعجبك الكتاب فضلاً اضغط على أعجبني
و يمكنك تحميله من هنا:

تحميل شيق جدا يشرح كل معادلات الاكسيل
شكرًا لمساهمتكم

شكراً لمساهمتكم معنا في الإرتقاء بمستوى المكتبة ، يمكنكم االتبليغ عن اخطاء او سوء اختيار للكتب وتصنيفها ومحتواها ، أو كتاب يُمنع نشره ، او محمي بحقوق طبع ونشر ، فضلاً قم بالتبليغ عن الكتاب المُخالف:

برنامج تشغيل ملفات pptقبل تحميل الكتاب ..
يجب ان يتوفر لديكم برنامج تشغيل وقراءة ملفات ppt
يمكن تحميلة من هنا 'http://www.microsoftstore.com/store/msmea/ar_EG/pdp/Office-365-Personal/productID.299498600'