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

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