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 |
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 | ||
|
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 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Access 2013 bible [[electronic resource] ] : [the comprehensive tutorial resource] / / Michael Alexander and Dick Kusleika |
Autore | Alexander Michael |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, 2013 |
Descrizione fisica | 1 online resource (1299 p.) |
Disciplina | 005.7565 |
Altri autori (Persone) | KusleikaDick |
Soggetto topico |
Database management
Databases |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-49034-7
1-299-46489-0 1-118-49154-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. I. Access building blocks -- pt. II. Understanding Access tables -- pt. III. Working with Access queries -- pt. IV. Analyzing data in Access -- pt. V. Working with Access forms and reports -- pt. VI. Access programming fundamentals -- pt. VII. Advanced Access programming techniques -- VIII. Access and Windows SharePoint services -- pt. XI. Appendixes. |
Record Nr. | UNINA-9910452386003321 |
Alexander Michael
![]() |
||
Indianapolis, Ind., : John Wiley & Sons, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Access 2013 bible [[electronic resource] ] : [the comprehensive tutorial resource] / / Michael Alexander and Dick Kusleika |
Autore | Alexander Michael |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, 2013 |
Descrizione fisica | 1 online resource (1299 p.) |
Disciplina | 005.7565 |
Altri autori (Persone) | KusleikaDick |
Soggetto topico |
Database management
Databases |
ISBN |
1-118-49034-7
1-299-46489-0 1-118-49154-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. I. Access building blocks -- pt. II. Understanding Access tables -- pt. III. Working with Access queries -- pt. IV. Analyzing data in Access -- pt. V. Working with Access forms and reports -- pt. VI. Access programming fundamentals -- pt. VII. Advanced Access programming techniques -- VIII. Access and Windows SharePoint services -- pt. XI. Appendixes. |
Record Nr. | UNINA-9910779568603321 |
Alexander Michael
![]() |
||
Indianapolis, Ind., : John Wiley & Sons, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Access 2013 bible : [the comprehensive tutorial resource] / / Michael Alexander and Dick Kusleika |
Autore | Alexander Michael |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, 2013 |
Descrizione fisica | 1 online resource (1299 p.) |
Disciplina | 005.7565 |
Altri autori (Persone) | KusleikaDick |
Soggetto topico |
Database management
Databases |
ISBN |
1-118-49034-7
1-299-46489-0 1-118-49154-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. I. Access building blocks -- pt. II. Understanding Access tables -- pt. III. Working with Access queries -- pt. IV. Analyzing data in Access -- pt. V. Working with Access forms and reports -- pt. VI. Access programming fundamentals -- pt. VII. Advanced Access programming techniques -- VIII. Access and Windows SharePoint services -- pt. XI. Appendixes. |
Record Nr. | UNINA-9910822707903321 |
Alexander Michael
![]() |
||
Indianapolis, Ind., : John Wiley & Sons, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Access 2019 Bible / / Michael Alexander, Dick Kusleika |
Autore | Alexander Michael |
Pubbl/distr/stampa | Indianapolis, IN : , : Wiley, , [2019] |
Descrizione fisica | 1 online resource (1,136 pages) |
Disciplina | 005.7565 |
Soggetto genere / forma | Electronic books. |
ISBN |
1-119-54943-4
1-119-51473-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910466834203321 |
Alexander Michael
![]() |
||
Indianapolis, IN : , : Wiley, , [2019] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Access 2019 Bible / / Michael Alexander, Dick Kusleika |
Autore | Alexander Michael |
Pubbl/distr/stampa | Indianapolis, IN : , : Wiley, , [2019] |
Descrizione fisica | 1 online resource (1,136 pages) |
Disciplina | 005.7565 |
Soggetto genere / forma | Handbooks and manuals. |
ISBN |
1-119-54943-4
1-119-51473-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Access building blocks. An introduction to database development ; Getting started with Access -- Understanding Access tables. Creating Access tables ; Understanding table relationships ; Working with Access tables ; Importing and exporting data ; Linking to external data -- Working with Access queries. Selecting data with queries ; Using operators and expressions in Access ; Going beyond select queries -- Analyzing data in Microsoft Access. Transforming data in Access ; Working with calculations and dates ; Performing conditional analyses ; The fundamentals of using SQL ; Subqueries and domain aggregate functions ; Running descriptive statistics in Access -- Working with Access forms and reports. Creating basic Access forms ; Working with data on Access forms ; Working with form controls ; Presenting data with Access reports ; Advanced Access report techniques -- Microsoft Access programming fundamentals. Using Access macros ; Using Access data macros ; Getting started with Access VBA ; Mastering VBA data types and procedures ; Understanding the Access event model ; Debugging your Access applications -- Advanced Access programming techniques. Accessing data with VBA ; Advanced data Access with VBA ; Customizing the ribbon ; Preparing your Access application for distribution ; Integrating Access with SharePoint. |
Record Nr. | UNINA-9910528403703321 |
Alexander Michael
![]() |
||
Indianapolis, IN : , : Wiley, , [2019] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Confessions of a Male Nurse (The Confessions Series) |
Autore | Alexander Michael |
Pubbl/distr/stampa | HarperCollins UK |
Disciplina | 610.73092 |
Soggetto non controllato |
Biography & autobiography
Biography |
ISBN | 0-00-749008-9 |
Formato | Musica ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Altri titoli varianti | Confessions of a Male Nurse |
Record Nr. | UNINA-9910148768603321 |
Alexander Michael
![]() |
||
HarperCollins UK | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2016 Power Programming with VBA / / Michael Alexander, Dick Kusleika |
Autore | Alexander Michael |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2016 |
Descrizione fisica | 1 online resource (767 p.) |
Disciplina | 005.369 |
Collana | Mr. Spreadsheet's Bookshelf |
Soggetto topico |
Business - Computer programs
Visual Basic for Applications (Computer program language) Visual programming (Computer science) |
Soggetto genere / forma | Electronic books. |
ISBN |
1-5231-1481-9
1-119-41550-0 1-119-06756-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910270940703321 |
Alexander Michael
![]() |
||
Indianapolis, Indiana : , : Wiley, , 2016 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|