Cargando…
Formulas and functions, Microsoft Excel 2010 /
MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Excel expert Paul McFedries shows how to use Excel 2010's core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Indianapolis, Ind.] :
[Que Pub.],
[©2011]
|
| Colección: | MrExcel library.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocn606573035 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 100412s2011 inua o 000 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d IDEBK |d CEF |d OCLCQ |d SAA |d DEBSZ |d OCLCQ |d OCLCO |d OCLCF |d OCLCQ |d COO |d CDX |d OCLCQ |d YDX |d OCLCO |d UAB |d AU@ |d OCLCQ |d OCLCO |d CZL |d OCLCO | ||
| 019 | |a 670294847 |a 741348890 |a 759006419 |a 1005200211 | ||
| 020 | |a 9780789746573 | ||
| 020 | |a 0789746573 | ||
| 020 | |a 9780789746542 | ||
| 020 | |a 0789746549 | ||
| 020 | |z 9780789743060 | ||
| 020 | |z 078974306X | ||
| 024 | 8 | |a 9786612568954 | |
| 029 | 1 | |a DEBSZ |b 355432765 | |
| 029 | 1 | |a HEBIS |b 291503799 | |
| 035 | |a (OCoLC)606573035 |z (OCoLC)670294847 |z (OCoLC)741348890 |z (OCoLC)759006419 |z (OCoLC)1005200211 | ||
| 037 | |a CL0500000063 |b Safari Books Online | ||
| 050 | 4 | |a HF5548.4.M523 |b M3757 2011 | |
| 072 | 7 | |a UFC |2 bicssc | |
| 082 | 0 | 4 | |a 005.54 |b 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a McFedries, Paul. | |
| 245 | 1 | 0 | |a Formulas and functions, Microsoft Excel 2010 / |c Paul McFedries. |
| 246 | 1 | |i Copyright has title: |a Formulas and functions with Microsoft Office Excel 2010 | |
| 260 | |a [Indianapolis, Ind.] : |b [Que Pub.], |c [©2011] | ||
| 300 | |a 1 online resource (xv, 526 pages) : |b illustrations | ||
| 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 MrExcel library | |
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover13; -- Contents -- Introduction -- Whats in the Book -- This Books Special Features -- I: MASTERING EXCEL RANGES AND FORMULAS -- 1 Getting the Most Out of Ranges -- Advanced Range-Selection Techniques -- Data Entry in a Range -- Filling a Range -- Using the Fill Handle -- Creating a Series -- Advanced Range Copying -- Copying Selected Cell Attributes -- Clearing a Range -- Applying Conditional Formatting to a Range -- 2 Using Range Names -- Defining a Range Name -- Working with Range Names -- 3 Building Basic Formulas -- Understanding Formula Basics -- Understanding Operator Precedence -- Controlling Worksheet Calculation -- Copying and Moving Formulas -- Displaying Worksheet Formulas -- Converting a Formula to a Value -- Working with Range Names in Formulas -- Working with Links in Formulas -- Formatting Numbers, Dates, and Times -- 4 Creating Advanced Formulas -- Working with Arrays -- Understanding Array Formulas -- Using Array Constants -- Using Iteration and Circular References -- Consolidating Multisheet Data -- Applying Data-Validation Rules to Cells -- Using Dialog Box Controls on a Worksheet -- 5 Troubleshooting Formulas -- Understanding Excels Error Values -- Fixing Other Formula Errors -- Handling Formula Errors with IFERROR() -- Using the Formula Error Checker -- Auditing a Worksheet -- II: HARNESSING THE POWER OF FUNCTIONS -- 6 Understanding Functions -- About Excels Functions -- The Structure of a Function -- Typing a Function into a Formula -- Using the Insert Function Feature -- Loading the Analysis ToolPak -- 7 Working with Text Functions -- Excels Text Functions -- Working with Characters and Codes -- Converting Text -- Formatting Text -- Manipulating Text -- Removing Unwanted Characters from a String -- Extracting a Substring -- Searching for Substrings -- Case Study: Generating Account Numbers -- Substituting One Substring for Another -- Case Study: Generating Account Numbers, Part 2 -- 8 Working with Logical and Information Functions -- Adding Intelligence with Logical Functions -- Case Study: Building an Accounts Receivable Aging Worksheet -- Getting Data with Information Functions -- 9 Working with Lookup Functions -- Understanding Lookup Tables -- The CHOOSE() Function -- Looking Up Values in Tables -- 10 Working with Date and Time Functions -- How Excel Deals with Dates and Times -- Using Excels Date Functions -- Using Excels Time Functions -- Case Study: Building an Employee Time Sheer -- 11 Working with Math Functions -- Understanding Excels Rounding Functions -- Case Study: Rounding Billable Time -- Summing Values -- MOD() Function -- Generating Random Numbers -- 12 Working with Statistical Functions -- Understanding Descriptive Statistics -- Counting Items with the COUNT() Function -- Calculating Averages -- Calculating Extreme Values -- Calculating Measures of Variation -- Working with Frequency Distributions -- Using the Analysis ToolPak Statistical Tools -- III: BUILDING BUSINESS MODELS -- 13 Analyzing Data with Tables -- Converting a Range to a Table -- Basic Table Operations -- Sorting a Table -- Filtering Table Data -- Referencing Tables in Formulas -- Excel82. | |
| 520 | |a MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Excel expert Paul McFedries shows how to use Excel 2010's core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010 improvements-from Sparklines to the brand-new version of Solver. Along the way, you'll discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You'll find crystal-clear instructions... insider insights... even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. • Create more powerful formulas • Use conditional formatting to instantly reveal anomalies, problems, or opportunities • Analyze your data with standard tables and PivotTables • Use complex criteria to filter data in lists • Understand correlations between data • Perform sophisticated what-if analyses • Use regression to track trends and make forecasts • Build loan, investment, and discount formulas • Troubleshoot problems with formulas, ranges, and functions About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excelskills, and presents focused tasks and examples for performing them rapidly and effectively. Selectedby Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will: • Dramatically increase your productivity-saving you 50 hours a year, or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make Paul McFedries, president of Logophilia Limited, is a Microsoft Office expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 70 books to his credit, which combined have sold more than three million copies worldwide. His recent titles include Using the Microsoft Office Web Apps, and Microsoft Windows 7 Unleashed. He is also proprietor of Word Spy (www.wordspy.com), a website that tracks new words and phrases as they enter the English language. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |0 (OCoLC)fst01366659 |
| 650 | 0 | |a Business |x Computer programs. | |
| 650 | 0 | |a Electronic spreadsheets. | |
| 650 | 6 | |a Tableurs. | |
| 650 | 7 | |a Business |x Computer programs. |2 blmlsh | |
| 650 | 7 | |a Electronic spreadsheets. |2 blmlsh | |
| 650 | 7 | |a Business |x Computer programs. |2 fast |0 (OCoLC)fst00842283 | |
| 650 | 7 | |a Electronic spreadsheets. |2 fast |0 (OCoLC)fst00907463 | |
| 655 | 4 | |a Electronic resource. | |
| 776 | 0 | 8 | |i Print version: McFedries, Paul. |t Formulas and functions with Microsoft Office Excel 2010. |d Indianapolis, Ind. : Que Pub., ©2011 |z 9780789743060 |w (OCoLC)471787423 |
| 830 | 0 | |a MrExcel library. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780789746573/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Coutts Information Services |b COUT |n 13315862 |c 39.99 USD | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n 256895 | ||
| 938 | |a YBP Library Services |b YANK |n 14851480 | ||
| 994 | |a 92 |b IZTAP | ||