LEADER 05338nam 22006733u 450 001 9910464533203321 005 20210107205920.0 010 $a1-118-90289-0 035 $a(CKB)3710000000198554 035 $a(EBL)1742830 035 $a(SSID)ssj0001397197 035 $a(PQKBManifestationID)11933417 035 $a(PQKBTitleCode)TC0001397197 035 $a(PQKBWorkID)11434736 035 $a(PQKB)10536735 035 $a(MiAaPQ)EBC1742830 035 $a(EXLCZ)993710000000198554 100 $a20140721d2014 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$a101 ready-to-use Excel formulas /$fby Michael Alexander and Dick Kusleika 210 1$aHoboken, New Jersey :$cWiley,$d2014. 215 $a1 online resource (243 pages) $cillustrations 300 $aDescription based upon print version of record. 300 $aIncludes index. 311 $a1-118-90268-8 327 $aContents 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 327 $aFormula 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 327 $aFormula 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 327 $aFormula 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 327 $aFormula 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 327 $aFormula 48: Sum All Values That Meet a Certain Condition 330 $a101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem-along with detailed explanation of how the formulas work. 606 $aElectronic spreadsheets 606 $aElectronic spreadsheets$xComputer programs 606 $aMacro instructions (Electronic computers) 606 $aChemistry$2HILCC 606 $aPhysical Sciences & Mathematics$2HILCC 606 $aChemistry - General$2HILCC 608 $aElectronic books. 615 0$aElectronic spreadsheets. 615 0$aElectronic spreadsheets$xComputer programs. 615 0$aMacro instructions (Electronic computers) 615 7$aChemistry 615 7$aPhysical Sciences & Mathematics 615 7$aChemistry - General 676 $a005.369 700 $aAlexander$b Michael$0676367 701 $aKusleika$b Dick$0894640 801 0$bAU-PeEL 801 1$bAU-PeEL 801 2$bAU-PeEL 906 $aBOOK 912 $a9910464533203321 996 $a101 ready-to-use Excel formulas$91998582 997 $aUNINA