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 | ||
| ||
Advanced Excel reporting for management accountants / / Neale Blackwood
| Advanced Excel reporting for management accountants / / Neale Blackwood |
| Autore | Blackwood Neale |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
| Descrizione fisica | 1 online resource (753 p.) |
| Disciplina | 005.54024/6581511 |
| Collana | Wiley corporate F&A |
| Soggetto topico |
Managerial accounting - Computer programs
Electronic spreadsheets - Computer programs |
| ISBN |
1-118-65818-3
1-118-77716-6 1-118-65819-1 |
| Classificazione | BUS001040 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Series; Titlepage; Copyright; Dedication; Preface; Acknowledgments; Introduction; CHAPTER 1 Management Accounting and Excel; Assumptions; The Goal of Reporting; Why Use Excel?; The Goal of This Book; Monthly Management Reports; Macro Policy; CHAPTER 2 Building Reporting Models; Needs Analysis; Scope Definition; Design; Construction; Testing; Operation; Maintenance; Time, Effort, and Cost; Practical Considerations; CHAPTER 3 Building Tips; Display Tips; Keyboard Shortcuts; Mouse Shortcuts; Keyboard and Mouse Shortcuts; General Tips; CHAPTER 4 Design and Structure
Structure = FlexibilityModular Sheet Design; Standardised Report Layout; Table-Based Systems; Spreadsheet Best Practices; CHAPTER 5 Setting the Foundation; Terminology; Data Rules; Data Structures; Format as Table; Data Cleansing Techniques; External Data; CHAPTER 6 Pivot Tables (Do-It-Yourself Reporting); The Pros and Cons of a Pivot Table; Creating a Pivot Table; PowerPivot; CHAPTER 7 Tools of the Trade: Summing Functions; Range Names; Using Cells and Ranges in Formulas; The Humble SUM Function; Advanced SUM and 3D Formulas; Subtotaling; The SUBTOTAL Function; The AGGREGATE Function Function WizardConditional Summing; The SUMIF Function; Sumif Uses; Helper Cells; The SUMIFS Function; The SUMPRODUCT Function; CHAPTER 8 Accessories: Other Reporting Functions and Features; Helper Cells; Logic Functions; The IF Function; The AND and OR Functions; Lookup Functions; The VLOOKUP Function; The HLOOKUP Function; An Alternative to VLOOKUP; The INDEX and MATCH Functions; The MATCH Function; The INDEX Function; The INDEX-MATCH Combination; Error Handling Functions; The IFERROR Function; Handling Specific Errors; Text-Based Functions; The TEXT Function; LEFT and RIGHT Functions The MID FunctionFlexible Text Manipulations; The SEARCH Function; The LEN Function; Flexible Splitting; The SUBSTITUTE Function; Converting Text to Numbers; Date Functions; The DATE Function; Other Useful Functions; Array Formulas; CHAPTER 9 Range Names; Advantages; Disadvantages; Creating a Range Name; Using Range Names; Name Manager; Naming a Range; Creating Names Automatically; Name Intersections; Dynamic Range Names; Using Structure in Range Names; INDIRECT and Range Names; Listing Range Names; CHAPTER 10 Maintenance Issues; Maintenance Instructions; The Advantages of Using Tables Common IssuesRolling the Year; Working with Days; Simplifying the Interface by Using Controls; CHAPTER 11 Choosing the Right Format; Colour Blindness; Format Painter; Less Is More; Fonts; Clear and Start Again; The Format Cells Dialog Box; Styles; Conditional Formatting; Printing Issues; CHAPTER 12 Picture Perfect: Charting Techniques; Chart versus Graph; Chart Basics; Charts for Reports; Automating Charts; Mixing Chart Types; Dual-Axis Charts; Handling Missing Data; Labeling Highs and Lows; Trendlines and Moving Averages; Plotting the Variance; Dashboard Techniques; Text in a Chart The Data Series Formula |
| Record Nr. | UNINA-9910132199703321 |
|
Blackwood Neale
|
||
| Hoboken, New Jersey : , : Wiley, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced Excel reporting for management accountants / / Neale Blackwood
| Advanced Excel reporting for management accountants / / Neale Blackwood |
| Autore | Blackwood Neale |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
| Descrizione fisica | 1 online resource (753 p.) |
| Disciplina | 005.54024/6581511 |
| Collana | Wiley corporate F&A |
| Soggetto topico |
Managerial accounting - Computer programs
Electronic spreadsheets - Computer programs |
| ISBN |
1-118-65818-3
1-118-77716-6 1-118-65819-1 |
| Classificazione | BUS001040 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Series; Titlepage; Copyright; Dedication; Preface; Acknowledgments; Introduction; CHAPTER 1 Management Accounting and Excel; Assumptions; The Goal of Reporting; Why Use Excel?; The Goal of This Book; Monthly Management Reports; Macro Policy; CHAPTER 2 Building Reporting Models; Needs Analysis; Scope Definition; Design; Construction; Testing; Operation; Maintenance; Time, Effort, and Cost; Practical Considerations; CHAPTER 3 Building Tips; Display Tips; Keyboard Shortcuts; Mouse Shortcuts; Keyboard and Mouse Shortcuts; General Tips; CHAPTER 4 Design and Structure
Structure = FlexibilityModular Sheet Design; Standardised Report Layout; Table-Based Systems; Spreadsheet Best Practices; CHAPTER 5 Setting the Foundation; Terminology; Data Rules; Data Structures; Format as Table; Data Cleansing Techniques; External Data; CHAPTER 6 Pivot Tables (Do-It-Yourself Reporting); The Pros and Cons of a Pivot Table; Creating a Pivot Table; PowerPivot; CHAPTER 7 Tools of the Trade: Summing Functions; Range Names; Using Cells and Ranges in Formulas; The Humble SUM Function; Advanced SUM and 3D Formulas; Subtotaling; The SUBTOTAL Function; The AGGREGATE Function Function WizardConditional Summing; The SUMIF Function; Sumif Uses; Helper Cells; The SUMIFS Function; The SUMPRODUCT Function; CHAPTER 8 Accessories: Other Reporting Functions and Features; Helper Cells; Logic Functions; The IF Function; The AND and OR Functions; Lookup Functions; The VLOOKUP Function; The HLOOKUP Function; An Alternative to VLOOKUP; The INDEX and MATCH Functions; The MATCH Function; The INDEX Function; The INDEX-MATCH Combination; Error Handling Functions; The IFERROR Function; Handling Specific Errors; Text-Based Functions; The TEXT Function; LEFT and RIGHT Functions The MID FunctionFlexible Text Manipulations; The SEARCH Function; The LEN Function; Flexible Splitting; The SUBSTITUTE Function; Converting Text to Numbers; Date Functions; The DATE Function; Other Useful Functions; Array Formulas; CHAPTER 9 Range Names; Advantages; Disadvantages; Creating a Range Name; Using Range Names; Name Manager; Naming a Range; Creating Names Automatically; Name Intersections; Dynamic Range Names; Using Structure in Range Names; INDIRECT and Range Names; Listing Range Names; CHAPTER 10 Maintenance Issues; Maintenance Instructions; The Advantages of Using Tables Common IssuesRolling the Year; Working with Days; Simplifying the Interface by Using Controls; CHAPTER 11 Choosing the Right Format; Colour Blindness; Format Painter; Less Is More; Fonts; Clear and Start Again; The Format Cells Dialog Box; Styles; Conditional Formatting; Printing Issues; CHAPTER 12 Picture Perfect: Charting Techniques; Chart versus Graph; Chart Basics; Charts for Reports; Automating Charts; Mixing Chart Types; Dual-Axis Charts; Handling Missing Data; Labeling Highs and Lows; Trendlines and Moving Averages; Plotting the Variance; Dashboard Techniques; Text in a Chart The Data Series Formula |
| Record Nr. | UNINA-9910814716203321 |
|
Blackwood Neale
|
||
| Hoboken, New Jersey : , : Wiley, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Comment tirer parti d'Excel ? : Comprendre et maîtriser le tableur de Microsoft en 10 fonctions / / Priscillia Mommens-Valenduc
| Comment tirer parti d'Excel ? : Comprendre et maîtriser le tableur de Microsoft en 10 fonctions / / Priscillia Mommens-Valenduc |
| Autore | Mommens-Valenduc Priscillia |
| Pubbl/distr/stampa | Bruxelles : , : 50Minutes.fr, , [2015] |
| Descrizione fisica | 1 online resource (27 pages) |
| Disciplina | 005.369 |
| Collana | Coaching Pro |
| Soggetto topico | Electronic spreadsheets - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN | 2-8062-6470-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | fre |
| Record Nr. | UNINA-9910465529803321 |
|
Mommens-Valenduc Priscillia
|
||
| Bruxelles : , : 50Minutes.fr, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Comment tirer parti d'Excel ? : Comprendre et maîtriser le tableur de Microsoft en 10 fonctions / / Priscillia Mommens-Valenduc
| Comment tirer parti d'Excel ? : Comprendre et maîtriser le tableur de Microsoft en 10 fonctions / / Priscillia Mommens-Valenduc |
| Autore | Mommens-Valenduc Priscillia |
| Pubbl/distr/stampa | Bruxelles : , : 50Minutes.fr, , [2015] |
| Descrizione fisica | 1 online resource (27 pages) |
| Disciplina | 005.369 |
| Collana | Coaching Pro |
| Soggetto topico | Electronic spreadsheets - Computer programs |
| ISBN | 2-8062-6470-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | fre |
| Record Nr. | UNINA-9910798373603321 |
|
Mommens-Valenduc Priscillia
|
||
| Bruxelles : , : 50Minutes.fr, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Comment tirer parti d'Excel ? : Comprendre et maîtriser le tableur de Microsoft en 10 fonctions / / Priscillia Mommens-Valenduc
| Comment tirer parti d'Excel ? : Comprendre et maîtriser le tableur de Microsoft en 10 fonctions / / Priscillia Mommens-Valenduc |
| Autore | Mommens-Valenduc Priscillia |
| Pubbl/distr/stampa | Bruxelles : , : 50Minutes.fr, , [2015] |
| Descrizione fisica | 1 online resource (27 pages) |
| Disciplina | 005.369 |
| Collana | Coaching Pro |
| Soggetto topico | Electronic spreadsheets - Computer programs |
| ISBN | 2-8062-6470-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | fre |
| Record Nr. | UNINA-9910821923103321 |
|
Mommens-Valenduc Priscillia
|
||
| Bruxelles : , : 50Minutes.fr, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Ctrl+shift+enter [[electronic resource] ] : mastering Excel array formulas / / Mike Girvin
| Ctrl+shift+enter [[electronic resource] ] : mastering Excel array formulas / / Mike Girvin |
| Autore | Girvin Mike |
| Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, 2013 |
| Descrizione fisica | 1 online resource (353 p.) |
| Disciplina | 005.54 |
| Soggetto topico | Electronic spreadsheets - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-61547-209-6
1-61547-109-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910453799003321 |
|
Girvin Mike
|
||
| Uniontown, OH, : Holy Macro! Books, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Ctrl+shift+enter [[electronic resource] ] : mastering Excel array formulas / / Mike Girvin
| Ctrl+shift+enter [[electronic resource] ] : mastering Excel array formulas / / Mike Girvin |
| Autore | Girvin Mike |
| Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, 2013 |
| Descrizione fisica | 1 online resource (353 p.) |
| Disciplina | 005.54 |
| Soggetto topico | Electronic spreadsheets - Computer programs |
| ISBN |
1-61547-209-6
1-61547-109-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910790510603321 |
|
Girvin Mike
|
||
| Uniontown, OH, : Holy Macro! Books, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data visualization with Excel dashboards and reports / / Dick Kusleika
| Data visualization with Excel dashboards and reports / / Dick Kusleika |
| Autore | Kusleika Dick |
| Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , [2021] |
| Descrizione fisica | 1 online resource (xxiii, 326 pages) |
| Disciplina | 005.369 |
| Soggetto topico |
Dashboards (Management information systems)
Information visualization Electronic spreadsheets - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-5231-4329-0
1-119-69881-2 1-119-69873-1 1-119-69880-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910555098203321 |
|
Kusleika Dick
|
||
| Indianapolis, Indiana : , : Wiley, , [2021] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
