1.

Record Nr.

UNINA9910139202003321

Autore

Etheridge Denise

Titolo

Excel data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge

Pubbl/distr/stampa

Indianapolis, Ind., : Wiley, 2010

ISBN

1-118-03623-9

1-118-98393-9

1-62198-432-X

1-282-68507-4

9786612685071

0-470-90172-1

Edizione

[3rd ed.]

Descrizione fisica

1 online resource (371 p.)

Collana

Visual Blueprint

Altri autori (Persone)

SimonJinjer L. <1966->

Disciplina

005.54

Soggetti

Electronic spreadsheets - Computer programs

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di contenuto

Excel® Data Analysis: Your visual blueprintTM for creating and analyzing data, charts, and PivotTables, 3rd Edition; TABLE OF CONTENTS; Chapter 1: Getting Started; Introducing Data Analysis with Excel; Tour the Excel Window; Explore the Ribbon; Using the Mini Toolbar and Context Menu; Select Options on the Status Bar; Take a Look at Backstage View; Upload a File to Excel's Web-based Application; Create a File Using Excel's Web-based Application; Enter Data; Select Cells; Chapter 2: Formatting a Worksheet; Using the Ribbon to Format Numbers; Using the Format Cells Dialog Box

Understanding Dates and TimesFormat Percentages; Format Fractions; Format in Scientific Notation; Format as Text; Add a Border; Change the Font or Font Size; Add a Background Color; Change the Font Color; Bold, Underline, or Italicize; Align Data; Rotate Data; Wrap Text; Merge and Center; Apply a Style; Using Format Painter; Clear Formats; Chapter 3: Structuring Your Workbook; Cut, Copy, and Paste Cells; Using Live Preview with Paste; Paste from the Office Clipboard; Insert or Delete; Find and Replace Information; Change the Name of a Worksheet;



Change Column Widths or Row Heights

Hide Columns or RowsHide a Worksheet; Move or Copy a Worksheet; Freeze Worksheet Titles; Hide Gridlines, Headings, or the Formula Bar; Chapter 4: Creating Formulas; Understanding Formulas; Calculate with an Operator; Calculate Using a Function and Cell Addresses; Create an Array Formula; Using the Sum, Average, Count, Min, and Max Functions; Create a Formula that Refers to Another Worksheet; Understanding Relative and Absolute Cell Addresses; Edit Formulas; Name Cells and Ranges; Define and Display Constants; Create Formulas That Include Names; Check Formulas for Errors

Trace Precedents and DependentsChapter 5: Using Functions; Understanding the Function Wizard; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve Column or Row Numbers; Using VLOOKUP; Determine the Location of a Value; Using INDEX; Perform Date and Time Calculations; Chapter 6: Using Financial Functions; Calculate Future Value; Calculate Present Value; Calculate Loan Payments; Calculate Principal or Interest; Calculate the Interest Rate; Calculate the Internal Rate of Return

Calculate Straight-Line DepreciationCalculate Declining Balance Depreciation; Calculate Double-Declining Balance Depreciation; Calculate Sum-of-the-Years-Digits Depreciation; Chapter 7: Using Statistical Functions and Tools; Calculate an Average; Calculate a Conditional Average; Calculate the Median or the Mode; Calculate Rank; Determine the Nth Largest Value; Calculate Frequency; Calculate Variance and Standard Deviation; Find the Correlation; Install Excel Add-Ins; Calculate a Moving Average; Compare Variances; Using the Data Analysis Toolpak to Determine Rank and Percentile

Calculate Descriptive Statistics

Sommario/riassunto

Advanced techniques for Excel power users Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.Provides a clear look at power-using Excel, the world's l



2.

Record Nr.

UNINA9910820087803321

Autore

Gasston Peter

Titolo

The book of CSS3 [[electronic resource] ] : a developer's guide to the future of web design / / by Peter Gasston

Pubbl/distr/stampa

San Francisco, : No Starch Press, 2011

ISBN

1-59327-363-0

Edizione

[1st edition]

Descrizione fisica

1 online resource (308 p.)

Disciplina

006.7

006.76

Soggetti

Web sites - Design

Cascading style sheets

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di contenuto

Foreword; Preface; Introduction; The Scope of This Book; A Quick Note About Browsers and Platforms; The Appendices and Further Resources; 1: Introducing CSS3; What CSS3 Is and How It Came to Be; A Brief History of CSS3; CSS3 Is Modular; Module Status and the Recommendation Process; CSS3 Is Not HTML5; Let's Get Started: Introducing the Syntax; Browser-Specific Prefixes; Future-Proofing Experimental CSS; Getting Started; 2: Media Queries; The Advantages of Media Queries; Syntax; Media Features; Width and Height; Device Width and Height; Using Media Queries in the Real World; Orientation

Aspect RatioPixel Ratio; Multiple Media Features; Mozilla-Specific Media Features; Summary; Media Queries: Browser Support; 3: Selectors; Attribute Selectors; New Attribute Selectors in CSS3; Beginning Substring Attribute Value Selector; Ending Substring Attribute Value Selector; Arbitrary Substring Attribute Value Selector; Multiple Attribute Selectors; The General Sibling Combinator; Summary; Selectors: Browser Support; 4: Pseudo-classes and Pseudo-elements; Structural Pseudo-classes; The nth-* Pseudo-classes; first-of-type, last-child, and last-of-type; only-child and only-of-type

Other Pseudo-classestarget; empty; root; not; UI Element States; Pseudo-elements; The selection pseudo-element; Summary; DOM and Attribute Selectors: Browser Support; 5: Web Fonts; The @font-face Rule; Defining Different Faces; True vs. Artificial Font Faces; A



"Bulletproof" @font-face Syntax; Using Local Fonts; Font Formats; The Final "Bulletproof" Syntax; The Fontspring Bulletproof Syntax; Licensing Fonts for Web Use; A Real-World Web Fonts Example; More Font Properties; font-size-adjust; font-stretch; OpenType Features; Summary; Web Fonts: Browser Support

6: Text Effects and Typographic StylesUnderstanding Axes and Coordinates; Applying Dimensional Effects: text-shadow; Multiple Shadows; Letterpress Effect; Adding Definition to Text: text-outline and text-stroke; More Text Properties; Restricting Overflow; Resizing Elements; Aligning Text; Wrapping Text; Setting Text Rendering Options; Applying Punctuation Properties; Summary; Text Effects: Browser Support; 7: Multiple Columns; Column Layout Methods; Prescriptive Columns: column-count; Dynamic Columns: column-width; A Note on Readability; Different Distribution Methods in Firefox and WebKit

Combining column-count and column-widthColumn Gaps and Rules; Containing Elements within Columns; Elements Spanning Multiple Columns; Elements Breaking over Multiple Columns; Summary; Multiple Columns: Browser Support; 8: Background Images and Other Decorative Properties; Background Images; Multiple Background Images; Background Size; Background Clip and Origin; background-repeat; Background Image Clipping; Image Masks; Summary; Background Images: Browser Support; 9: Border and Box Effects; Giving Your Borders Rounded Corners; border-radius Shorthand

Differences in Implementation Across Browsers

Sommario/riassunto

CSS3 is the latest revision of cascading style sheets, the language used to define the look and formatting of web documents. A still-evolving standard, CSS3 presents a moving target for developers who need to stay abreast of which features are supported by particular web browsers. The Book of CSS3 uses real-world examples to teach developers the fundamentals of the CSS3 specification, highlighting the latest developments and future features, while paying close attention to current browser implementations. Each chapter examines a different CSS3 module, and teaches the reader to use exciting new