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

Autore	Murray Alan
Pubbl/distr/stampa	New York : , : Apress, , [2022]
Descrizione fisica	1 online resource (834 pages)
Disciplina	005.54
Soggetto topico	Electronic spreadsheets - Computer programs
ISBN	1-4842-7125-4
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Chapter 1: Excel Formulas: A Quick Primer -- Anatomy of an Excel Formula -- Breakdown of a Function -- Table of Formula Characters -- Order of Calculation -- Order of Range Operations -- Order of Mathematical Operations -- The Function Wizard -- Cell Referencing -- Absolute References -- Relative References Explained -- Making a Reference Absolute -- Mixed References -- Sheet References -- Workbook References -- Calculating Percentages -- Percentage of a Value -- Percentage of a Total -- Increase a Value by a Percentage -- Decrease a Value by a Percentage -- Calculate Percentage Change -- When Formulas Go Wrong -- Formula Errors -- Automatic Error Checking -- Excel Formula Is Not Calculating -- Formula Calculations Are Set to Manual -- Show Formulas Is Switched On -- Formula Is Stored As Text -- Cell Formatted As Text -- Summary -- Chapter 2: Logical Functions -- What Is TRUE and FALSE? -- The IF Function -- Example 1: Testing Numeric Values -- Example 2: Testing Text Values -- Example 3: Exact Text Match -- Example 4: Partial Text Match -- Example 5: Testing Date Values -- Example 6: Testing If a Cell Is Empty or Blank -- Example 7: Return a Symbol or Emoji -- Nested IF Functions -- IFS Function -- AND, OR, XOR, and NOT Functions -- AND Function -- OR Function -- XOR Function -- NOT Function -- The SWITCH Function -- Example 1: Match Against a List of Text Values -- Example 2: Evaluate to TRUE -- Example 3: Match a Formula Result to the List of Values -- Example 4: Pick Formula from a Drop-Down List -- Handling Errors -- IFERROR Function -- IFNA Function -- Logical Functions with Excel Features -- Format Values That Meet a Goal -- Conditional Formatting Rule with Multiple Conditions. Data Validation Rule Based on Another Cell Value -- Conditional Formatting with Charts -- Dynamic Chart Data with SWITCH -- Summary -- Chapter 3: Defined Names -- Named Ranges -- Why Use Named Ranges? -- Define a Named Range with the Name Box -- Using Named Ranges in Formulas -- Rules for Defining Names -- Tips for Defining Names -- Named Ranges with Multiple Cells -- Named Range for a Drop-Down List -- Define a Dynamic Named Range -- Define Names with Create from Selection -- Scope of a Defined Name -- Define a Named Constant -- Finding Named Ranges -- Relative Named Ranges -- Named Formulas -- Managing Names -- Edit a Name -- Filtering Names -- Print a List of the Names -- Apply Names to Existing Formulas -- Summary -- Chapter 4: You Need to Start Using Tables -- Why Use Tables? -- Format a Range As a Table -- Creating a Table -- Changing or Removing Table Styles -- Naming the Table -- Working with Tables -- Table References in a Formula -- The Magic of @ -- Referencing Table Elements -- Make Table Column and Cell References Absolute -- Tables with Other Excel Features -- Dynamic Lists -- Dynamic Charts -- Summary -- Chapter 5: Manipulating Text -- Extract Characters from a Text String -- LEFT and RIGHT -- Extract Characters from the Middle of a String -- FIND and SEARCH for Irregular Strings -- Example 1: Extract Characters Before a Delimiter -- Example 2: Extract Characters After a Delimiter -- Example 3: Combining LEFT and RIGHT -- Example 4: Extract Text Between Two Characters -- Example 5: Extract Number from a Text String -- Change the Case of Text -- The LEN Function -- Convert Text to a VALUE -- The NUMBERVALUE Function -- Remove Unwanted Characters -- The TRIM Function -- The CLEAN Function -- SUBSTITUTE and REPLACE Functions -- The REPLACE Function -- The SUBSTITUTE Function -- Example 1: Simple SUBSTITUTE Example. Example 2: Count the Number of Words in a Cell -- Example 3: Use the Instance Number to Extract Text -- Example 4: Return Text After the Last Delimiter -- TEXTBEFORE and TEXTAFTER Functions -- Example 1: Text Before or After the First Delimiter -- Example 2: Specify an Instance Number -- Example 3: Extract Text Between Two Characters -- Example 4: Using Match End and If Not Found -- The TEXTSPLIT Function -- Example 1: Simple TEXTSPLIT -- Example 2: Using Multiple Column Delimiters -- Example 3: Splitting Across Rows (and Columns) -- Example 4: Handling Missing Data -- Combine Text into One Cell -- The CONCATENATE Function -- The Ampersand Character -- The CONCAT Function -- The TEXTJOIN Function -- TEXTJOIN and Delimiters -- TEXTJOIN and Empty Values -- TEXTJOIN and Arrays -- The TEXT Function -- Example 1: Currency Formats -- Example 2: Positive and Negative Value Formats -- Example 3: Date Formats -- Repeating a Character - REPT Function -- Text Functions with Other Excel Features -- Conditional Formatting Rules - Last Character Equals -- Data Validation Rules - Forcing Correct Case -- Dynamic Labels for Charts -- Summary -- Chapter 6: Working with Dates and Time -- Understanding Dates and Time -- Dates and the Calendar System in Excel -- Calculate the Difference Between Two Dates -- Time in Excel -- Calculate the Difference in Two Times -- The TODAY and NOW Functions -- Convert Text to Date -- The DATEVALUE Function -- The VALUE Function -- The DATE Function -- Extract Date from a Date-Time Stamp -- The INT Function -- The TRUNC Function -- Extract Time from a Date-Time Stamp -- The MOD Function -- The YEAR, MONTH, and DAY Functions -- The NETWORKDAYS Function -- Calculate the Working Days Difference Between Two Dates -- The NETWORKDAYS.INTL Function -- Example 1: Customized NETWORKDAYS.INTL Function -- Example 2: Conditional Holiday Ranges. Example 3: Number of Fridays Between Two Dates -- The YEARFRAC Function -- The DATEDIF Function -- The WORKDAY Function -- Calculate a Due Date from a Starting Date -- The WORKDAY.INTL Function -- Calculate First Working Day of a Month -- EDATE and EOMONTH -- Calculate Contract End Dates -- Last Day of a Month -- Number of Days in a Month -- Last Working Day of a Month -- First Working Day of Next Month -- Returning Week Numbers -- The WEEKNUM Function -- What Is ISOWEEKNUM? -- Return the Week Number for Any Given Date -- Week Number in a Month -- The WEEKDAY Function -- Rate of Pay Determined by Day of Week -- Calculating Financial Years and Quarters -- Fiscal Years -- Indian Financial Year -- Australian Financial Year -- UK Financial Year -- Fiscal Quarters -- Working with Time -- Convert Text to Time -- The TIMEVALUE Function -- The TIME Function -- Rounding Time -- MROUND, CEILING.MATH, and FLOOR.MATH -- Round Time to the Nearest Hour -- Round Time to the Nearest 15 Minutes -- Time Difference Past Midnight -- Sum Hours over 24 Hours -- Handling Negative Time -- Date and Time Functions with Other Excel Features -- Highlight Approaching Due Dates -- Highlight Dates Due Within the Next Month -- Data Validation Rules - Prevent Weekend Entries -- Summary -- Chapter 7: The Infamous VLOOKUP Function -- Introduction to VLOOKUP -- VLOOKUP for an Exact Match -- VLOOKUP for a Range Lookup -- Column Index Number Tricks -- Trick 1: The COLUMN Function -- Trick 2: The COLUMNS Function -- Trick 3: Using an Index Row -- Reasons Why VLOOKUP Is Not Working -- Lookup Column Must Be the First Column -- Data Type of the Values Must Match -- Exact Match Has Not Been Specified -- Ranges Must Be in Ascending Order -- Handling Fake Errors with VLOOKUP -- The HLOOKUP Function -- Get VLOOKUP to Look to the Left -- Partial Match Lookup -- Case-Sensitive VLOOKUP. Multiple Column VLOOKUP -- Return the Nth Match -- VLOOKUP with Other Excel Features -- Conditional Formatting and VLOOKUP -- Dynamic Chart Range -- Summary -- Chapter 8: The Awesome SUMIFS, COUNTIFS, and Friends -- The SUMIFS Function -- SUMIF or SUMIFS -- Using Text Criteria -- Working with Multiple Criteria -- Using Numeric Criteria -- Sum Values Between Two Dates -- OR Logic with SUMIFS -- Using Wildcards with SUMIFS -- The Versatile COUNTIFS Function -- Comparing Two Lists -- Generating Unique Rankings -- Creating Conditional Rankings -- Creating a Frequency Distribution -- The AVERAGEIFS Function -- TRIMMEAN Function -- Conditional MEDIAN and MODE Functions -- Calculating the Median -- Calculating the Mode -- MAXIFS and MINIFS Functions -- Using the Functions with Other Excel Features -- Identifying Duplicates with Conditional Formatting -- Identifying Unmatched Values Between Two Lists -- Highlight Values Larger Than the Median -- Preventing Duplicate Entries -- Summary -- Chapter 9: Next-Level Aggregation Functions -- SUMPRODUCT Function -- Classic SUMPRODUCT -- Sum Values That Meet Multiple Criteria -- Count Values That Meet Multiple Criteria -- Aggregating Multiple Columns -- Distinct Count Formula -- Weighted Average -- Sum Every Nth Cell -- Sum Values for a Specific Weekday -- Sum the Top Five Values Only -- AGGREGATE Function -- Ignoring Hidden Rows -- Ignoring Errors in a Range -- Adding Criteria to AGGREGATE -- Function Specified by a Cell Value -- Summary -- Chapter 10: Dynamic Array Formulas -- Getting to Know Dynamic Array Formulas -- Arrays vs. Dynamic Arrays -- Dynamic Arrays with Tables -- Dynamic Array Formula Example -- Welcome the # Operator -- The #SPILL! Error -- DA Formulas Cannot Be Used Within Tables -- UNIQUE Function -- Returning Distinct and Unique Values -- UNIQUE with Multiple Columns -- UNIQUE to Compare Columns. Distinct Labels for SUMIFS.
Record Nr.	UNINA-9910590054103321

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

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

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