Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
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 | ||
| Materiale a stampa | ||
| 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 | ||
| Materiale a stampa | ||
| 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-9910809952403321 |
|
Alexander Michael
|
||
| Hoboken, New Jersey : , : Wiley, , 2014 | ||
| Materiale a stampa | ||
| 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 | ||
| Materiale a stampa | ||
| 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 | ||
| Materiale a stampa | ||
| 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 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. di Salerno | ||
| ||
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 | 0-8031-5273-6 |
| 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 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Essays in contemporary chemistry : from molecular structure towards biology
| Essays in contemporary chemistry : from molecular structure towards biology |
| Pubbl/distr/stampa | [Place of publication not identified], : Wiley VCH, 2001 |
| Disciplina | 540 |
| Soggetto topico |
Chemistry
Natural Science Disciplines Disciplines and Occupations Chemistry - General Physical Sciences & Mathematics |
| ISBN | 3-906390-45-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910143992403321 |
| [Place of publication not identified], : Wiley VCH, 2001 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Essays in contemporary chemistry : from molecular structure towards biology
| Essays in contemporary chemistry : from molecular structure towards biology |
| Pubbl/distr/stampa | [Place of publication not identified], : Wiley VCH, 2001 |
| Disciplina | 540 |
| Soggetto topico |
Chemistry
Natural Science Disciplines Disciplines and Occupations Chemistry - General Physical Sciences & Mathematics |
| ISBN | 3-906390-45-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910830802803321 |
| [Place of publication not identified], : Wiley VCH, 2001 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Handbook of chemoinformatics : from data to knowledge
| Handbook of chemoinformatics : from data to knowledge |
| Pubbl/distr/stampa | [Place of publication not identified], : Wiley VCH c2003, 2003 |
| Disciplina | 542/.85 |
| Soggetto topico |
Cheminformatics
Chemistry - General Chemistry Physical Sciences & Mathematics |
| ISBN | 3-527-61827-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910146020603321 |
| [Place of publication not identified], : Wiley VCH c2003, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Soggetto topico
- Chemistry (22)
-
Chemistry - General
(22)
- Physical Sciences & Mathematics (22)
- Natural Science Disciplines (5)
- Alchemy (3)