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 | ||
| ||
101 ready-to-use Excel macros / / by Michael Alexander and John Walkenbach
| 101 ready-to-use Excel macros / / by Michael Alexander and John Walkenbach |
| Autore | Alexander Michael T |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, 2012 |
| Descrizione fisica | 1 online resource (338 p.) |
| Disciplina |
005.369
005.54 |
| Altri autori (Persone) | WalkenbachJohn |
| Collana | Mr. Spreadsheet's bookshelf |
| Soggetto topico |
Domain-specific programming languages
Macro instructions (Electronic computers) Electronic spreadsheets |
| ISBN |
1-118-98392-0
1-62198-445-1 1-118-33353-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. 1. Getting started with Excel macros -- pt. 2. Working with workbooks -- pt. 3. Automating worksheet tasks with macros -- pt. 4. Selecting and modifying ranges -- pt. 5. Working with data -- pt. 6. Working with PivotTables -- pt. 7. Manipulating charts with macros -- pt. 8. E-mailing from Excel -- pt. 9. Integrating Excel and other office applications. |
| Altri titoli varianti |
One hundred and one ready-to-use Excel macros
Hundred and one ready-to-use Excel macros |
| Record Nr. | UNINA-9910141418103321 |
|
Alexander Michael T
|
||
| Hoboken, N.J., : John Wiley & Sons, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2000 : manuale di programmazione / Ken Getz, Paul Litwin, Mike Gilbert
| Access 2000 : manuale di programmazione / Ken Getz, Paul Litwin, Mike Gilbert |
| Autore | Getz, Ken |
| Pubbl/distr/stampa | Bresso : Jackson libri, 2000 |
| Descrizione fisica | XXVIII, 1248 p. ; 26 cm |
| Disciplina | 005.369 |
| Altri autori (Persone) |
Gilbert, Mike
Litwin, Paul |
| Collana | Manuali |
| Soggetto non controllato | Elaboratori elettroniciProgramma Access 2000 |
| ISBN | 88-256-1712-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | ita |
| Titolo uniforme | |
| Record Nr. | UNIPARTHENOPE-000017909 |
|
Getz, Ken
|
||
| Bresso : Jackson libri, 2000 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Parthenope | ||
| ||
Advanced Excel Essentials [[electronic resource] /] / by Jordan Goldmeier
| Advanced Excel Essentials [[electronic resource] /] / by Jordan Goldmeier |
| Autore | Goldmeier Jordan |
| Edizione | [1st ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (203 p.) |
| Disciplina | 005.369 |
| Collana | The expert's voice in Excel |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Computers Application software Microsoft and .NET Information Systems and Communication Service Computer Applications |
| ISBN | 1-4842-0734-3 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910300476503321 |
|
Goldmeier Jordan
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced Excel success : a practical guide to mastering Excel / / Alan Murray
| Advanced Excel success : a practical guide to mastering Excel / / Alan Murray |
| Autore | Murray Alan |
| Edizione | [1st ed. 2021.] |
| Pubbl/distr/stampa | [New York] : , : Apress, , [2021] |
| Descrizione fisica | 1 online resource (XVIII, 349 p.) : 358 illus |
| Disciplina | 005.369 |
| ISBN |
1-5231-5069-6
1-4842-6467-3 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Chapter 1: Excel Tricks and Data Tools -- Chapter 2: The 10 Power Functions of Excel -- Chapter 3: Advanced Formatting Techniques -- Chapter 4: Advanced Chart Tricks -- Chapter 5: Power Query – You Will Never Work the Same Way Again -- Chapter 6: Power Pivot – The Internal Data Model of Excel. |
| Record Nr. | UNINA-9910482987203321 |
|
Murray Alan
|
||
| [New York] : , : Apress, , [2021] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Analisi dei dati con Excel : funzionalità avanzate e utilizzo professionale di Excel / Francesco Borazzo
| Analisi dei dati con Excel : funzionalità avanzate e utilizzo professionale di Excel / Francesco Borazzo |
| Autore | Borazzo, Francesco |
| Pubbl/distr/stampa | Milano : Apogeo, ©2006 |
| Descrizione fisica | viii, 232 p. : fig. ; 20 cm |
| Disciplina | 005.369 |
| Collana | |
| Soggetto non controllato |
Analisi dei dati
Elaboratori elettronici - Programmi Excel |
| ISBN | 88-503-2437-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | ita |
| Record Nr. | UNINA-990008416310403321 |
|
Borazzo, Francesco
|
||
| Milano : Apogeo, ©2006 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Analisi dei dati con Excel 2007 : funzionalità avanzate e utilizzo professionale di Excel / Francesco Bonazzo
| Analisi dei dati con Excel 2007 : funzionalità avanzate e utilizzo professionale di Excel / Francesco Bonazzo |
| Autore | BORAZZO, Francesco |
| Pubbl/distr/stampa | Milano : Apogeo, copyr. 2008 |
| Descrizione fisica | VIII, 208 p. : ill. ; 19 cm |
| Disciplina | 005.369 |
| Collana | |
| Soggetto topico | Microelaboratori elettronici - Programmi Microsoft Excel per Windows |
| ISBN | 978-88-503-2767-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | ita |
| Record Nr. | UNISA-990003476470203316 |
|
BORAZZO, Francesco
|
||
| Milano : Apogeo, copyr. 2008 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. di Salerno | ||
| ||
Analisi delle vendite con excel 2007 / Gianclaudio Floria
| Analisi delle vendite con excel 2007 / Gianclaudio Floria |
| Autore | Floria, Gianclaudio |
| Edizione | [2. ed.] |
| Pubbl/distr/stampa | Milano : Fag, c2007 |
| Descrizione fisica | X, 274 p. ; 24 cm |
| Disciplina | 005.369 |
| Soggetto non controllato |
VenditeProgrammazioneProgrammi per microelaboratori
Microelaboratori elettroniciProgramma Excel 2007 Fogli elettroniciExcelApplicazioni gestionali |
| ISBN | 978-88-8233-641-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | ita |
| Titolo uniforme | |
| Record Nr. | UNIPARTHENOPE-000026529 |
|
Floria, Gianclaudio
|
||
| Milano : Fag, c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Parthenope | ||
| ||
