Autore	Walkenbach John
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, N.J., : Wiley
Descrizione fisica	1 online resource (1106 p.)
Disciplina	005.54
Collana	Mr. Spreadsheet's bookshelf
Soggetto topico	Visual programming (Computer science)
ISBN	1-281-73243-5 9786611732431 1-118-25759-6 0-470-15130-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel 2007 Power Programming with VBA; About the Author; Preface; Topics Covered; What You Need to Know; What You Need to Have; Conventions in This Book; What the Icons Mean; How This Book Is Organized; About the Companion CD-ROM; About the Power Utility Pak Offer; How to Use This Book; Reach Out; Contents at a Glance; Table of Contents; Part I: Some Essential Background; Chapter 1: Excel 2007: Where It Came From; A Brief History of Spreadsheets; Why Excel Is Great for Developers; Excel's Role in Microsoft's Strategy; Chapter 2: Excel in a Nutshell; Thinking in Terms of Objects; Workbooks Excel's User InterfaceCustomizing the Display; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features; Analysis Tools; Add-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 3: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Array Formulas; Counting and Summing Techniques; Working with Dates and Times; Creating Megaformulas; Chapter 4: Understanding Excel's Files; Starting Excel; File Types Working with Template FilesInside an Excel File; The QAT File; The XLB File; Add-In Files; Excel Settings in the Registry; Part II: Excel Application Development; Chapter 5: What Is a Spreadsheet Application?; Spreadsheet Applications; The Developer and the End User; Solving Problems with Excel; Basic Spreadsheet Types; Chapter 6: Essentials of Spreadsheet Application Development; Determining User Needs; Planning an Application That Meets User Needs; Determining the Most Appropriate User Interface; Concerning Yourself with the End User; Other Development Issues Part III: Understanding Visual Basic for ApplicationsChapter 7: Introducing Visual Basic for Applications; Some BASIC Background; About VBA; The Basics of VBA; Introducing the Visual Basic Editor; Working with the Project Explorer; Working with Code Windows; Customizing the VBE Environment; The Macro Recorder; About Objects and Collections; Properties and Methods; The Comment Object: A Case Study; Some Useful Application Properties; Working with Range Objects; Things to Know about Objects; Chapter 8: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments Variables, Data Types, and ConstantsAssignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 9: Working with VBA Sub Procedures; About Procedures; Executing Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 10: Creating Function Procedures; Sub Procedures versus Function Procedures; Why Create Custom Functions?; An Introductory Function Example; Function Procedures; Function Arguments; Function Examples Emulating Excel's SUM Function
Record Nr.	UNINA-9910841651703321

Autore	Etheridge Denise
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, NJ, : Wiley Pub.
Descrizione fisica	1 online resource (258 p.)
Disciplina	005.54
Collana	Visual read less, learn more Top 100 simplified tips & tricks
Soggetto topico	Electronic spreadsheets - Computer programs Business - Computer programs
Soggetto genere / forma	Electronic books.
ISBN	1-118-07895-0 1-281-23788-4 9786611237882 0-470-37748-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel 2007 Top 100 Simplified Tips & Tricks; Table of Contents; Chapter 1 Boost Your Efficiency; Validate with a VALIDATION LIST; Validate with DATA ENTRY RULES; Extend a series with AUTOFILL; Insert SYMBOLS OR SPECIAL CHARACTERS; Hide rows by GROUPING AND OUTLINING; FIND AND REPLACE formats; ADD COMMENTS to your worksheet; Let Excel READ BACK YOUR DATA; Create your own SORT OR AUTOFILL; Chapter 2 Work with Formulas and Functions; ENTER FORMULAS using a variety of methods; Name CELLS AND RANGES; Define a CONSTANT; CREATE FORMULAS that include names; Calculate with THE FUNCTION WIZARD Figure out LOAN TERMS Determine the INTERNAL RATE OF RETURN; Determine the NTH LARGEST VALUE; Create a CONDITIONAL FORMULA; Calculate a CONDITIONAL SUM; Add a CALCULATOR; Find PRODUCTS AND SQUARE ROOTS; Perform TIME CALCULATIONS; Perform DATE CALCULATIONS; Chapter 3 Copy, Format, and More; CHECK YOUR FORMULAS for errors; TRACE precedents and dependents; Change TEXT TO NUMBERS; CONVERT A ROW to a column; Copy with the OFFICE CLIPBOARD; Adjust column widths with PASTE SPECIAL; Specify how to paste with PASTE SPECIAL; Create your own STYLE; COPY STYLES to another workbook Conditionally FORMAT YOUR WORKSHEET TRACK CHANGES while editing; CONSOLIDATE worksheets; Chapter 4 Manipulate Records; ENTER DATA with a form; Filter DUPLICATE RECORDS; Perform simple SORTS AND FILTERS; Perform COMPLEX SORTS; SORT by cell color, font color, or icon; Perform COMPLEX FILTERS; Filter by MULTIPLE CRITERIA; SUBTOTAL sorted data; CHART FILTERED DATA easily; COUNT filtered records; LOOK UP INFORMATION in your worksheet; DEFINE DATA as a table; Modify a TABLE STYLE; Chapter 5 Explore the Patterns inYour Data; Create a PIVOTTABLE; Modify PIVOTTABLE DATA AND LAYOUT Compute Pivot Table SUB AND GRAND TOTALS Create a PivotTable CALCULATED FIELD; HIDE ROWS OR COLUMNS in a PivotTable; SORT a PivotTable; Create a PIVOTCHART; DESCRIBE DATA with statistics; FIND THE CORRELATION between variables; Explore outcomes with WHAT-IF ANALYSIS; Optimize a result with GOAL SEEK; Chapter 6 Create Charts; CREATE A CHART that has visual appeal; Add CHART DETAILS; Change the CHART TYPE; Add a TRENDLINE; Add and remove CHART DATA; Add ERRORS BARS; Create a HISTOGRAM; Create a COMBINATION CHART; Chapter 7 Present Worksheets; FORMAT numbers, dates, and times APPLY FORMATS to cells Fill with a GRADIENT; Format quickly with FORMAT PAINTER; INSERT SHAPES into your worksheet; INSERT TEXT BOXES into your worksheet; INSERT PHOTOGRAPHS into your worksheet; ARRANGE THE GRAPHICS in your worksheet; Insert a BACKGROUND IMAGE; TAKE A PICTURE of your worksheet; Chapter 8 Protect, Save, and Print; PROTECT your worksheet; Save a workbook as A TEMPLATE; CHOOSE A FORMAT when saving a workbook; PRINT MULTIPLE AREAS of a workbook; PRINT MULTIPLE WORKSHEETS from a workbook; Chapter 9 Extend Excel; PASTE LINK into Word or PowerPoint; EMBED a worksheet CREATE A LINK from an Excel workbook
Record Nr.	UNINA-9910450674903321

Autore	Quirk Thomas J
Edizione	[1st ed. 2013.]
Pubbl/distr/stampa	New York, NY : , : Springer New York : , : Imprint : Springer, , 2013
Descrizione fisica	1 online resource (247 p.)
Disciplina	005.54
Soggetto topico	Statistics Statistics for Life Sciences, Medicine, Health Sciences Statistics and Computing/Statistics Programs Statistics, general
ISBN	1-4614-5779-3
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel 2010 for Biological and Life Sciences Statistics; Preface; Acknowledgments; Contents; 1 Sample Size, MeanMean, Standard DeviationStandard deviation, and Standard Error of the MeanMean; 1.1...MeanMean; 1.2...Standard DeviationStandard deviation; 1.3...Standard Error of the MeanMean; 1.4...Sample SizeSample size, MeanMean, Standard DeviationStandard deviation, and Standard Error of the MeanMean; 1.4.1 Using the Fill/Series/Columns CommandsFill/Series/Columns commands; 1.4.2 Changing the Width of a Column; 1.4.3 Centering Information in a Range of Cells 1.4.4 Naming a Range of CellsNaming a range of cells1.4.5 Finding the Sample SizeSample size Using the =COUNT Function; 1.4.6 Finding the MeanMean Score Using the =AVERAGE Function; 1.4.7 Finding the Standard DeviationStandard deviation Using the =STDEV Function; 1.4.8 Finding the Standard Error of the MeanMean; 1.4.8.1 Formatting NumbersFormatting numbers in Number Format (2 Decimal Places); 1.5...Saving a SpreadsheetSaving a spreadsheet; 1.6...Printing a SpreadsheetPrinting a spreadsheet 1.7...Formatting NumbersFormatting numbers in Currency FormatFormatting numberscurrency format (2 Decimal Places)1.8...Formatting NumbersFormatting numbers in Number Format (3 Decimal Places); 1.9...End-of-Chapter Practice Problems; References; 2 Random Number Generator; 2.1...Creating Frame NumbersRandom number generatorframe numbers for Generating Random Numbers; 2.2...Creating Random Numbers in an Excel Worksheet; 2.3...Sorting Frame NumbersRandom number generatorframe numbers into a Random Sequence; 2.4...Printing an Excel File so that All of the Information Fits onto One Page 2.5...End-of-Chapter Practice Problems3 Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing; 3.1...Confidence Interval About the MeanConfidence interval about the mean; 3.1.1 How to Estimate the Population MeanMean; 3.1.2 Estimating the Lower LimitConfidence interval about the meanlower limit and the Upper LimitConfidence interval about the meanupper limit of the 95 Percent Confidence Interval About the MeanConfidence interval about the mean; 3.1.3 Estimating the Confidence Interval for the Chevy Impala in Miles Per Gallon 3.1.4 Where Did the Number ''1.96'' Come From?3.1.5 Finding the Value for t in the Confidence Interval Formula; 3.1.6 Using Excel's TINV Function to Find the Confidence Interval About the MeanConfidence interval about the mean; 3.1.7 Using Excel to find the 95 % Confidence Interval for a Car's mpg Claim; 3.2...Hypothesis TestingHypothesis testing; 3.2.1 Hypotheses Always Refer to the Population of People, Plants, or Animals that you are Studying; 3.2.2 The Null HypothesisHypothesis testingnull hypothesis and the Research (Alternative) Hypothesis 3.2.2.1 Determining the Null HypothesisHypothesis testingnull hypothesis and the Research HypothesisHypothesis testingresearch hypothesis When Rating Scales are Used
Record Nr.	UNINA-9910437877503321