Excel 2016 formulas
(eBook)
Author
Contributors
Kusleika, Dick, author.
Published
Indianapolis, IN : Wiley, [2016].
Format
eBook
ISBN
1119067928, 1119067987, 9781119067924, 9781119067986
Physical Desc
1 online resource
Status
Description
Loading Description...
Also in this Series
Checking series information...
Subjects
OCLC Fast Subjects
More Details
Language
English
UPC
99975757149
Notes
General Note
Includes index.
Description
Annotation,'Excel 2016 Formulas' is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Alexander, M., & Kusleika, D. (2016). Excel 2016 formulas . Wiley.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Alexander, Michael, 1972- and Dick, Kusleika. 2016. Excel 2016 Formulas. Wiley.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Alexander, Michael, 1972- and Dick, Kusleika. Excel 2016 Formulas Wiley, 2016.
MLA Citation, 9th Edition (style guide)Alexander, Michael, and Dick Kusleika. Excel 2016 Formulas Wiley, 2016.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
dc49940a-4043-19b0-4283-86059bec37fa-eng
Grouping Information
| Grouped Work ID | dc49940a-4043-19b0-4283-86059bec37fa-eng |
|---|---|
| Full title | excel 2016 formulas |
| Author | alexander michael |
| Grouping Category | book |
| Last Update | 2024-09-06 16:31:08PM |
| Last Indexed | 2024-09-28 04:27:43AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Sep 29, 2024 |
| Last Used | Sep 29, 2024 |
Marc Record
| First Detected | Jul 29, 2024 04:02:07 PM |
|---|---|
| Last File Modification Time | Sep 06, 2024 04:36:39 PM |
MARC Record
| LEADER | 12288cam a2200577 i 4500 | ||
|---|---|---|---|
| 001 | ocn933508014 | ||
| 003 | OCoLC | ||
| 005 | 20240830103855.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 151228s2016 inu o 001 0 eng d | ||
| 019 | |a 933537764|a 935251582|a 946054949|a 1100225848 | ||
| 020 | |a 1119067928|q (electronic bk.) | ||
| 020 | |a 1119067987|q (electronic bk.) | ||
| 020 | |a 9781119067924|q (electronic bk.) | ||
| 020 | |a 9781119067986|q (electronic bk.) | ||
| 020 | |z 1119067863 | ||
| 020 | |z 9781119067863 | ||
| 024 | 8 | |a 99975757149 | |
| 035 | |a (OCoLC)933508014|z (OCoLC)933537764|z (OCoLC)935251582|z (OCoLC)946054949|z (OCoLC)1100225848 | ||
| 037 | |a CL0500000730|b Safari Books Online | ||
| 040 | |a N$T|b eng|e rda|e pn|c N$T|d IDEBK|d TEFOD|d N$T|d OCLCF|d YDXCP|d RECBK|d DEBSZ|d EBLCP|d UMI|d COO|d REB|d KSU|d DEBBG|d K6U|d IDB|d MERUC|d LIV|d OCLCQ|d VT2|d OCLCQ|d OCLCO|d CCO|d LOA|d COCUF|d ZCU|d ICG|d CNNOR|d D6H|d OCLCQ|d OCLCO|d HCO|d VVB|d WRM|d GILDS|d STF|d CEF|d VTS|d OCLCQ|d OCLCO|d MOQ|d OCLCQ|d OCLCO|d G3B|d LVT|d S8J|d S9I|d TKN|d UAB|d DKC|d AU@|d OCLCQ|d CNMTR|d UKAHL|d OCLCQ|d BRF|d OCLCO|d OCLCQ|d OCLCO|d OCLCL|d UEJ|d OCLCO|d OCLCQ | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a HF5548.4.M523 | |
| 082 | 0 | 4 | |a 005.369|2 23 |
| 100 | 1 | |a Alexander, Michael,|d 1972-|e author.|1 https://id.oclc.org/worldcat/entity/E39PCjvFBYmTVbcjhrfXYFGQHK|0 http://id.loc.gov/authorities/names/n2005074553 | |
| 245 | 1 | 0 | |a Excel 2016 formulas /|c Michael Alexander, Dick Kusleika. |
| 264 | 1 | |a Indianapolis, IN :|b Wiley,|c [2016] | |
| 264 | 4 | |c ©2015 | |
| 264 | 4 | |c ©2016 | |
| 300 | |a 1 online resource | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 490 | 1 | |a Mr. Spreadsheet's Bookshelf | |
| 500 | |a Includes index. | ||
| 505 | 0 | |a Excel® 2016 Formulas -- About the Authors -- About the Technical Editor -- Credits -- Contents at a Glance -- Table of Contents -- Introduction -- Part I: Understanding Formula Basics -- Chapter 1: The Excel User Interface in a Nutshell -- The Workings of Workbooks -- Worksheets -- Chart sheets -- Macro sheets and dialog sheets -- The Excel User Interface -- The Ribbon -- Backstage View -- Shortcut menus and the mini toolbar -- Dialog boxes -- Customizing the UI -- Task panes -- Customizing onscreen display -- Numeric formatting -- Stylistic formatting -- Protection Options -- Securing access to the entire workbook -- Limiting access to specific worksheet ranges -- Protecting the workbook structure -- Chapter 2: Basic Facts About Formulas -- Entering and Editing Formulas -- Formula elements -- Entering a formula -- Pasting names -- Spaces and line breaks -- Formula limits -- Sample formulas -- Editing formulas -- Using Operators in Formulas -- Reference operators -- Sample formulas that use operators -- Operator precedence -- Nested parentheses -- Calculating Formulas -- Cell and Range References -- Creating an absolute or a mixed reference -- Referencing other sheets or workbooks -- Copying or Moving Formulas -- Making an Exact Copy of a Formula -- Converting Formulas to Values -- Hiding Formulas -- Errors in Formulas -- Dealing with Circular References -- Goal Seeking -- A goal seeking example -- More about goal seeking -- Chapter 3: Working with Names -- What's in a Name? -- A Name's Scope -- Referencing names -- Referencing names from another workbook -- Conflicting names -- The Name Manager -- Creating names -- Editing names -- Deleting names -- Shortcuts for Creating Cell and Range Names -- The New Name dialog box -- Creating names using the Name box -- Creating names from text in cells -- Naming entire rows and columns. | |
| 505 | 8 | |a Names created by Excel -- Creating Multisheet Names -- Working with Range and Cell Names -- Creating a list of names -- Using names in formulas -- Using the intersection operators with names -- Using the range operator with names -- Referencing a single cell in a multicell named range -- Applying names to existing formulas -- Applying names automatically when creating a formula -- Unapplying names -- Names with errors -- Viewing named ranges -- Using names in charts -- How Excel Maintains Cell and Range Names -- Inserting a row or column -- Deleting a row or a column -- Cutting and pasting -- Potential Problems with Names -- Name problems when copying sheets -- Name problems when deleting sheets -- The Secret to Understanding Names -- Naming constants -- Naming text constants -- Using worksheet functions in named formulas -- Using cell and range references in named formulas -- Using named formulas with relative references -- Advanced Techniques That Use Names -- Using the INDIRECT function with a named range -- Using arrays in named formulas -- Creating a dynamic named formula -- Using an XLM macro in a named formula -- Part II: Leveraging Excel Functions -- Chapter 4: Introducing Worksheet Functions -- What Is a Function? -- Simplify your formulas -- Perform otherwise impossible calculations -- Speed up editing tasks -- Provide decision-making capability -- More about functions -- Function Argument Types -- Names as arguments -- Full-column or full-row as arguments -- Literal values as arguments -- Expressions as arguments -- Other functions as arguments -- Arrays as arguments -- Ways to Enter a Function into a Formula -- Entering a function manually -- Using the Function Library commands -- Using the Insert Function dialog box -- More tips for entering functions -- Chapter 5: Manipulating Text -- A Few Words About Text. | |
| 505 | 8 | |a How many characters in a cell? -- Numbers as text -- Text Functions -- Determining whether a cell contains text -- Working with character codes -- Determining whether two strings are identical -- Joining two or more cells -- Displaying formatted values as text -- Displaying formatted currency values as text -- Removing excess spaces and nonprinting characters -- Counting characters in a string -- Repeating a character or string -- Creating a text histogram -- Padding a number -- Changing the case of text -- Extracting characters from a string -- Replacing text with other text -- Finding and searching within a string -- Searching and replacing within a string -- Advanced Text Formulas -- Counting specific characters in a cell -- Counting the occurrences of a substring in a cell -- Removing trailing minus signs -- Expressing a number as an ordinal -- Determining a column letter for a column number -- Extracting a filename from a path specification -- Extracting the first word of a string -- Extracting the last word of a string -- Extracting all but the first word of a string -- Extracting first names, middle names, and last names -- Removing titles from names -- Counting the number of words in a cell -- Chapter 6: Working with Dates and Times -- How Excel Handles Dates and Times -- Understanding date serial numbers -- Entering dates -- Understanding time serial numbers -- Entering times -- Formatting dates and times -- Problems with dates -- Date-Related Functions -- Displaying the current date -- Displaying any date with a function -- Generating a series of dates -- Converting a nondate string to a date -- Calculating the number of days between two dates -- Calculating the number of work days between two dates -- Offsetting a date using only work days -- Calculating the number of years between two dates -- Calculating a person's age. | |
| 505 | 8 | |a Determining the day of the year -- Determining the day of the week -- Determining the week of the year -- Determining the date of the most recent Sunday -- Determining the first day of the week after a date -- Determining the nth occurrence of a day of the week in a month -- Counting the occurrences of a day of the week -- Expressing a date as an ordinal number -- Calculating dates of holidays -- Determining the last day of a month -- Determining whether a year is a leap year -- Determining a date's quarter -- Converting a year to roman numerals -- Time-Related Functions -- Displaying the current time -- Displaying any time using a function -- Calculating the difference between two times -- Summing times that exceed 24 hours -- Converting from military time -- Converting decimal hours, minutes, or seconds to a time -- Adding hours, minutes, or seconds to a time -- Converting between time zones -- Rounding time values -- Calculating Durations -- Chapter 7: Counting and Summing Techniques -- Counting and Summing Worksheet Cells -- Other Counting Methods -- Basic Counting Formulas -- Counting the total number of cells -- Counting blank cells -- Counting nonblank cells -- Counting numeric cells -- Counting text cells -- Counting nontext cells -- Counting logical values -- Counting error values in a range -- Advanced Counting Formulas -- Counting cells with the COUNTIF function -- Counting cells that meet multiple criteria -- Counting the most frequently occurring entry -- Counting the occurrences of specific text -- Counting the number of unique values -- Creating a frequency distribution -- Summing Formulas -- Summing all cells in a range -- Summing a range that contains errors -- Computing a cumulative sum -- Summing the "top n" values -- Conditional Sums Using a Single Criterion -- Summing only negative values. | |
| 505 | 8 | |a Summing values based on a different range -- Summing values based on a text comparison -- Summing values based on a date comparison -- Conditional Sums Using Multiple Criteria -- Using And criteria -- Using Or criteria -- Using And and Or criteria -- Chapter 8: Using Lookup Functions -- What Is a Lookup Formula? -- Functions Relevant to Lookups -- Basic Lookup Formulas -- The VLOOKUP function -- The HLOOKUP function -- The LOOKUP function -- Combining the MATCH and INDEX functions -- Specialized Lookup Formulas -- Looking up an exact value -- Looking up a value to the left -- Performing a case-sensitive lookup -- Choosing among multiple lookup tables -- Determining letter grades for test scores -- Calculating a grade point average -- Performing a two-way lookup -- Performing a two-column lookup -- Determining the address of a value within a range -- Looking up a value by using the closest match -- Looking up a value using linear interpolation -- Chapter 9: Working with Tables and Lists -- Tables and Terminology -- A list example -- A table example -- Working with Tables -- Creating a table -- Changing the look of a table -- Navigating and selecting in a table -- Adding new rows or columns -- Deleting rows or columns -- Moving a table -- Removing duplicate rows from a table -- Sorting and filtering a table -- Working with the Total row -- Using formulas within a table -- Referencing data in a table -- Converting a table to a list -- Using Advanced Filtering -- Setting up a criteria range -- Applying an advanced filter -- Clearing an advanced filter -- Specifying Advanced Filter Criteria -- Specifying a single criterion -- Specifying multiple criteria -- Specifying computed criteria -- Using Database Functions -- Inserting Subtotals -- Chapter 10: Miscellaneous Calculations -- Unit Conversions -- Rounding Numbers -- Basic rounding formulas. | |
| 520 | 8 | |a Annotation|b 'Excel 2016 Formulas' is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. | |
| 588 | 0 | |a Online resource; title from PDF title page (EBSCO, viewed January 14, 2016). | |
| 630 | 0 | 0 | |a Microsoft Excel (Computer file)|0 http://id.loc.gov/authorities/names/n86025775 |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 fast |
| 650 | 0 | |a Electronic spreadsheets|x Computer programs.|0 http://id.loc.gov/authorities/subjects/sh86007613 | |
| 700 | 1 | |a Kusleika, Dick,|e author. | |
| 758 | |i has work:|a Excel 2016 formulas (Text)|1 https://id.oclc.org/worldcat/entity/E39PCGc68TxPRRRVKCKVG77HBX|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version:|a Alexander, Michael.|t Excel 2016 Formulas.|d : Wiley, ©2015|z 9781119067863 |
| 830 | 0 | |a Mr. Spreadsheet's bookshelf.|0 http://id.loc.gov/authorities/names/no2007092934 | |
| 856 | 4 | 0 | |u https://www.aclib.us/OReilly |