101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika
| 101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika |
| Autore | Alexander Michael |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
| Descrizione fisica | 1 online resource (243 pages) : illustrations |
| Disciplina | 005.369 |
| Altri autori (Persone) | KusleikaDick |
| Soggetto topico |
Electronic spreadsheets
Electronic spreadsheets - Computer programs Macro instructions (Electronic computers) Chemistry Physical Sciences & Mathematics Chemistry - General |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-118-90289-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Table of Contents; Introduction; Chapter 1: Introducing Excel Formulas; Creating and Editing Excel Formulas; Using Formula Operators; Relative versus Absolute Cell References; Using External Cell References; Formula Calculation Modes; Leveraging Excel Functions; Understanding Formula Errors; Using Named Ranges in Formulas; Chapter 2: Common Mathematical Operations; Formula 1: Calculating Percent of Goal; Formula 2: Calculating Percent Variance; Formula 3: Calculating Percent Variance with Negative Values; Formula 4: Calculating a Percent Distribution
Formula 5: Calculating a Running TotalFormula 6: Applying a Percent Increase or Decrease to Values; Formula 7: Dealing with Divide-by-Zero Errors; Formula 8: Basic Rounding of Numbers; Formula 9: Rounding to the Nearest Penny; Formula 10: Rounding to Significant Digits; Formula 11: Counting Values in a Range; Formula 12: Creating a Conversion Table; Chapter 3: Manipulating Text with Formulas; Formula 13: Joining Text Strings; Formula 14: Setting Text to Sentence Case; Formula 15: Removing Spaces from a Text String; Formula 16: Extract Parts of a Text String Formula 17: Finding a Particular Character in a Text StringFormula 18: Substituting Text Strings; Formula 19: Counting Specific Characters in a Cell; Formula 20: Adding a Line Break within a Formula; Formula 21: Cleaning Strange Characters from Text Fields; Formula 22: Padding Numbers with Zeros; Formula 23: Formatting the Numbers in a Text String; Chapter 4: Working with Dates and Times; Formula 24: Getting the Current Date and Time; Formula 25: Calculating Age; Formula 26: Calculating the Number of Days between Two Dates; Formula 27: Calculating the Number of Workdays between Two Dates Formula 28: Generate a List of Business Days Excluding HolidaysFormula 29: Extracting Parts of a Date; Formula 30: Calculating the Number of Years and Months between Dates; Formula 31: Converting Dates to Julian Date Formats; Formula 32: Calculating the Percent of Year Completed and Remaining; Formula 33: Returning the Last Date of a Given Month; Formula 34: Calculating the Calendar Quarter for a Date; Formula 35: Calculating the Fiscal Quarter for a Date; Formula 36: Returning a Fiscal Month from a Date; Formula 37: Calculate the Date of the Nth Weekday of the Month Formula 38: Calculate the Date of the Last Weekday of the MonthFormula 39: Extracting Parts of a Time; Formula 40: Calculating Elapsed Time; Formula 41: Rounding Time Values; Formula 42: Converting Decimal Hours, Minutes, or Seconds to a Time; Formula 43: Adding Hours, Minutes, or Seconds to a Time; Chapter 5: Performing Conditional Analysis; Formula 44: Check to See Whether a Simple Condition Is Met; Formula 45: Checking for Multiple Conditions; Formula 46: Check Whether Condition1 AND Condition2 Are Met; Formula 47: Check Whether Condition1 OR Condition2 Is Met Formula 48: Sum All Values That Meet a Certain Condition |
| Record Nr. | UNINA-9910464533203321 |
Alexander Michael
|
||
| Hoboken, New Jersey : , : Wiley, , 2014 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika
| 101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika |
| Autore | Alexander Michael |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
| Descrizione fisica | 1 online resource (243 pages) : illustrations |
| Disciplina | 005.369 |
| Altri autori (Persone) | KusleikaDick |
| Soggetto topico |
Electronic spreadsheets
Electronic spreadsheets - Computer programs Macro instructions (Electronic computers) Chemistry Physical Sciences & Mathematics Chemistry - General |
| ISBN | 1-118-90289-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Table of Contents; Introduction; Chapter 1: Introducing Excel Formulas; Creating and Editing Excel Formulas; Using Formula Operators; Relative versus Absolute Cell References; Using External Cell References; Formula Calculation Modes; Leveraging Excel Functions; Understanding Formula Errors; Using Named Ranges in Formulas; Chapter 2: Common Mathematical Operations; Formula 1: Calculating Percent of Goal; Formula 2: Calculating Percent Variance; Formula 3: Calculating Percent Variance with Negative Values; Formula 4: Calculating a Percent Distribution
Formula 5: Calculating a Running TotalFormula 6: Applying a Percent Increase or Decrease to Values; Formula 7: Dealing with Divide-by-Zero Errors; Formula 8: Basic Rounding of Numbers; Formula 9: Rounding to the Nearest Penny; Formula 10: Rounding to Significant Digits; Formula 11: Counting Values in a Range; Formula 12: Creating a Conversion Table; Chapter 3: Manipulating Text with Formulas; Formula 13: Joining Text Strings; Formula 14: Setting Text to Sentence Case; Formula 15: Removing Spaces from a Text String; Formula 16: Extract Parts of a Text String Formula 17: Finding a Particular Character in a Text StringFormula 18: Substituting Text Strings; Formula 19: Counting Specific Characters in a Cell; Formula 20: Adding a Line Break within a Formula; Formula 21: Cleaning Strange Characters from Text Fields; Formula 22: Padding Numbers with Zeros; Formula 23: Formatting the Numbers in a Text String; Chapter 4: Working with Dates and Times; Formula 24: Getting the Current Date and Time; Formula 25: Calculating Age; Formula 26: Calculating the Number of Days between Two Dates; Formula 27: Calculating the Number of Workdays between Two Dates Formula 28: Generate a List of Business Days Excluding HolidaysFormula 29: Extracting Parts of a Date; Formula 30: Calculating the Number of Years and Months between Dates; Formula 31: Converting Dates to Julian Date Formats; Formula 32: Calculating the Percent of Year Completed and Remaining; Formula 33: Returning the Last Date of a Given Month; Formula 34: Calculating the Calendar Quarter for a Date; Formula 35: Calculating the Fiscal Quarter for a Date; Formula 36: Returning a Fiscal Month from a Date; Formula 37: Calculate the Date of the Nth Weekday of the Month Formula 38: Calculate the Date of the Last Weekday of the MonthFormula 39: Extracting Parts of a Time; Formula 40: Calculating Elapsed Time; Formula 41: Rounding Time Values; Formula 42: Converting Decimal Hours, Minutes, or Seconds to a Time; Formula 43: Adding Hours, Minutes, or Seconds to a Time; Chapter 5: Performing Conditional Analysis; Formula 44: Check to See Whether a Simple Condition Is Met; Formula 45: Checking for Multiple Conditions; Formula 46: Check Whether Condition1 AND Condition2 Are Met; Formula 47: Check Whether Condition1 OR Condition2 Is Met Formula 48: Sum All Values That Meet a Certain Condition |
| Record Nr. | UNINA-9910786631003321 |
Alexander Michael
|
||
| Hoboken, New Jersey : , : Wiley, , 2014 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Better looking, better living, better loving : how chemistry can help you achieve life's goals
| Better looking, better living, better loving : how chemistry can help you achieve life's goals |
| Autore | Emsley John |
| Pubbl/distr/stampa | [Place of publication not identified], : Wiley VCH, 2007 |
| Disciplina | 540 |
| Soggetto topico |
Chemistry - Social aspects
Chemistry, Technical - Social aspects Chemistry - Physiological effect Chemicals Chemistry - General Chemistry Physical Sciences & Mathematics |
| ISBN | 3-527-61144-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910144284103321 |
Emsley John
|
||
| [Place of publication not identified], : Wiley VCH, 2007 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Better looking, better living, better loving : how chemistry can help you achieve life's goals
| Better looking, better living, better loving : how chemistry can help you achieve life's goals |
| Autore | Emsley John |
| Pubbl/distr/stampa | [Place of publication not identified], : Wiley VCH, 2007 |
| Disciplina | 540 |
| Soggetto topico |
Chemistry - Social aspects
Chemistry, Technical - Social aspects Chemistry - Physiological effect Chemicals Chemistry - General Chemistry Physical Sciences & Mathematics |
| ISBN | 3-527-61144-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910830071203321 |
Emsley John
|
||
| [Place of publication not identified], : Wiley VCH, 2007 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Better looking, better living, better loving : how chemistry can help you achieve life's goals
| Better looking, better living, better loving : how chemistry can help you achieve life's goals |
| Autore | Emsley John |
| Pubbl/distr/stampa | [Place of publication not identified], : Wiley VCH, 2007 |
| Disciplina | 540 |
| Soggetto topico |
Chemistry - Social aspects
Chemistry, Technical - Social aspects Chemistry - Physiological effect Chemicals Chemistry - General Chemistry Physical Sciences & Mathematics |
| ISBN | 3-527-61144-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911019091703321 |
Emsley John
|
||
| [Place of publication not identified], : Wiley VCH, 2007 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Chemisches Grundpraktikum
| Chemisches Grundpraktikum |
| Autore | Berthold Hans J |
| Pubbl/distr/stampa | [Place of publication not identified], : VCH, 2005 |
| Descrizione fisica | 1 online resource (xiii, 199 p.) |
| Disciplina | 624.1 |
| Soggetto topico |
Chemistry
Physical Sciences & Mathematics Chemistry - General |
| ISBN |
1-280-55941-1
9786610559411 3-527-60295-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | ger |
| Record Nr. | UNISA-996211423903316 |
Berthold Hans J
|
||
| [Place of publication not identified], : VCH, 2005 | ||
| Lo trovi qui: Univ. di Salerno | ||
| ||
The chemist's companion: a handbook of practical data, techniques, and references / [by] Arnold J. Gordon and Richard A. Ford [[electronic resource]]
| The chemist's companion: a handbook of practical data, techniques, and references / [by] Arnold J. Gordon and Richard A. Ford [[electronic resource]] |
| Autore | Gordon Arnold J |
| Pubbl/distr/stampa | New York, : Wiley, [1972] |
| Descrizione fisica | 1 online resource (xii, 537 p. ) : tables. ; |
| Disciplina | 542 |
| Altri autori (Persone) | FordRichard A <1940-> (Richard Alan) |
| Soggetto topico |
Chemistry
Chimie - Tables Chemical Industry Industry Natural Science Disciplines Technology, Industry, and Agriculture Physical Sciences & Mathematics Chemistry - General |
| Soggetto genere / forma | Handbooks and manuals. |
| ISBN | 1-61344-238-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Properties of molecular systems -- Properties of atoms and bonds -- Kinetics and energetics -- Spectroscopy -- Photochemistry -- Chromatography -- Experimental techniques -- Mathematical and numerical information -- Miscellaneous -- Suppliers index -- Subject index. |
| Record Nr. | UNINA-9911006579003321 |
Gordon Arnold J
|
||
| New York, : Wiley, [1972] | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Computerized chemical data standards : databases, data interchange, and information systems
| Computerized chemical data standards : databases, data interchange, and information systems |
| Pubbl/distr/stampa | [Place of publication not identified], : ASTM, 1994 |
| Disciplina | 025.06/54 |
| Collana | STP Computerized chemical data standards |
| Soggetto topico |
Chemistry - Data processing - Standards
Chemistry - Databases Data transmission systems - Standards Chemistry Physical Sciences & Mathematics Chemistry - General |
| ISBN |
9780803152731
0803152736 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Altri titoli varianti | Computerized Chemical Data Standards |
| Record Nr. | UNINA-9910164337003321 |
| [Place of publication not identified], : ASTM, 1994 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Concise encyclopedia chemistry
| Concise encyclopedia chemistry |
| Pubbl/distr/stampa | [Place of publication not identified], : de Gruyter, 1988 |
| Disciplina | 540/.3 |
| Soggetto topico |
Chemistry - Encyclopedias
Chemistry - General Chemistry Physical Sciences & Mathematics Biochemistry Biological Science Disciplines Natural Science Disciplines Occupations |
| ISBN | 1-62870-836-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911007039103321 |
| [Place of publication not identified], : de Gruyter, 1988 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Electron transfer in chemistry
| Electron transfer in chemistry |
| Pubbl/distr/stampa | [Place of publication not identified], : Wiley VCH, 2001 |
| Disciplina | 541.3/93 |
| Soggetto topico |
Oxidation-reduction reaction
Chemistry - General Chemistry Physical Sciences & Mathematics |
| ISBN |
9783527618248
3527618244 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Principles and theories, methods and techniques -- 2. Organic molecules, organometallic and inorganic molecules -- 3. Biological systems, artificial supramolecular systems -- 4. Catalysis of electron transfer, heterogenous systems, gas-phase systems -- 5. Molecules-level electronics, imaging and information, energy and the environment. |
| Record Nr. | UNINA-9911020197703321 |
| [Place of publication not identified], : Wiley VCH, 2001 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||