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

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

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 والبرامج المكتبية - مكتبة كتب تقنية المعلومات.