Excel 2013 for scientists / / Dr. Gerard M. Verschuuren ; Shannon Mattiza, cover design |
Autore | Verschuuren G. M. N (Geert M. N.) |
Edizione | [Revised & expanded third edition.] |
Pubbl/distr/stampa | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
Descrizione fisica | 1 online resource (321 p.) |
Disciplina | 005.1 |
Collana | Excel for Professionals series |
Soggetto topico |
Computer software - Development
Electronic spreadsheets |
ISBN | 1-61547-217-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title page; Copyright page; Contents; About the Author; Introduction; Part 1: General Spreadsheet Techniques; Chapter 2: The Fill Handle; Chapter 3: Relative vs. Absolute Cell References; Chapter 4: Range Names; Chapter 5: Nested Functions; Part 1 Exercises; Part 2: Data Analysis; Chapter 7: Subtotals; Chapter 8: Summary Functions; Chapter 9: Unique Lists; Chapter 10: Data Validation; Chapter 11: Conditional Formatting; Chapter 12: Filtering Tools; Chapter 13: Lookups; Chapter 14: Working with Trends; Chapter 15: Fixing Numbers; Chapter 16: Copying Formulas
Chapter 17: Multi-cell ArraysChapter 18: Single-cell Arrays; Chapter 19: Date Manipulation; Chapter 20: Time Manipulation; Part 2 Exercises; Part 3: Plotting Data; Chapter 22: A Chart's or Graph's Data Source; Chapter 23: Combining Chart Types; Chapter 24: Changing Graph Locations; Chapter 25: Templates and Defaults; Chapter 26: Axis Scales; Chapter 27: More Axes; Chapter 28: Error Bars; Chapter 29: More Bars; Chapter 30: Line Markers; Chapter 31: Interpolation; Chapter 32: Graph Formulas; Part 3 Exercises; Part 4: Regression and Curve Fitting; Chapter 34: Nonlinear Regression Chapter 35: Curve FittingChapter 36: Sigmoid Curves; Chapter 37: Predictability; Chapter 38: Correlation; Chapter 39: Multiple Regression: Linear Estimates; Chapter 40: Reiterations and Matrixes; Chapter 41: Solving Equations; Chapter 42: What-If Controls; Chapter 43: Syntax of Functions; Chapter 44: Worksheet Functions; Part 4 Exercises; Part 5: Statistical Analysis; Chapter 46: Types of Distributions; Chapter 47: Simulating Distributions; Chapter 48: Sampling Techniques; Chapter 49: Test Conditions and Outliers; Chapter 50: Estimating Means; Chapter 51: Estimating Proportions Chapter 52: Significant MeansChapter 53: Significant Proportions; Chapter 54: Significant Frequencies; Chapter 55: More on Chi-Squared Testing and Box-Cox Power; Chapter 56: Analysis of Variance; Part 5 Exercises; Index |
Record Nr. | UNINA-9910822513503321 |
Verschuuren G. M. N (Geert M. N.)
![]() |
||
Uniontown, Ohio : , : Holy Macro! Books, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2013 power programming with VBA [[electronic resource] /] / by John Walkenbach |
Autore | Walkenbach John |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2013 |
Descrizione fisica | 1 online resource (1107 p.) |
Disciplina | 650.02855365 |
Collana | Mr. Spreadsheet's Bookshelf |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets Electronic spreadsheets - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-49040-1
1-118-49180-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Microsoft® Excel® 2013 Power Programming with VBA; Introduction; 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 This Book's Website; About the Power Utility Pak Offer; How to Use This Book; Part 1: Some Essential Background; Chapter 1: Excel in a Nutshell; About Excel; Thinking in Terms of Objects; Workbooks; Excel's User Interface; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features
Analysis ToolsAdd-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 2: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Excel Auditing Tools; Array Formulas; Counting and Summing Techniques; Lookup Formulas; Working with Dates and Times; Creating Megaformulas; Chapter 3: Understanding Excel Files; Starting Excel; File Types; Excel File Compatibility; Protected View; Using AutoRecover; Working with Template Files; Inside an Excel File; The OfficeUI File; The XLB File; Add-In Files Excel Settings in the RegistryChapter 4: Essentials of Spreadsheet Application Development; What Is a Spreadsheet Application?; Steps for 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 2: Understanding Visual Basic for Applications; Chapter 5: Introducing Visual Basic for Applications; Getting Some BASIC Background; Delving into VBA; Covering the Basics of VBA; Introducing Visual Basic Editor; Working with Project Explorer Working with Code WindowsCustomizing 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 6: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments; Variables, Data Types, and Constants; Assignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 7: Working with VBA Sub Procedures About ProceduresExecuting Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 8: 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; Extended Date Functions; Debugging Functions; Dealing with the Insert Function Dialog Box; Using Add-ins to Store Custom Functions; Using the Windows API; Chapter 9: VBA Programming Examples and Techniques Learning by Example |
Record Nr. | UNINA-9910462904903321 |
Walkenbach John
![]() |
||
Hoboken, N.J., : Wiley, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2013 power programming with VBA [[electronic resource] /] / by John Walkenbach |
Autore | Walkenbach John |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2013 |
Descrizione fisica | 1 online resource (1107 p.) |
Disciplina | 650.02855365 |
Collana | Mr. Spreadsheet's Bookshelf |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets Electronic spreadsheets - Computer programs |
ISBN |
1-118-49040-1
1-118-49180-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Microsoft® Excel® 2013 Power Programming with VBA; Introduction; 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 This Book's Website; About the Power Utility Pak Offer; How to Use This Book; Part 1: Some Essential Background; Chapter 1: Excel in a Nutshell; About Excel; Thinking in Terms of Objects; Workbooks; Excel's User Interface; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features
Analysis ToolsAdd-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 2: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Excel Auditing Tools; Array Formulas; Counting and Summing Techniques; Lookup Formulas; Working with Dates and Times; Creating Megaformulas; Chapter 3: Understanding Excel Files; Starting Excel; File Types; Excel File Compatibility; Protected View; Using AutoRecover; Working with Template Files; Inside an Excel File; The OfficeUI File; The XLB File; Add-In Files Excel Settings in the RegistryChapter 4: Essentials of Spreadsheet Application Development; What Is a Spreadsheet Application?; Steps for 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 2: Understanding Visual Basic for Applications; Chapter 5: Introducing Visual Basic for Applications; Getting Some BASIC Background; Delving into VBA; Covering the Basics of VBA; Introducing Visual Basic Editor; Working with Project Explorer Working with Code WindowsCustomizing 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 6: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments; Variables, Data Types, and Constants; Assignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 7: Working with VBA Sub Procedures About ProceduresExecuting Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 8: 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; Extended Date Functions; Debugging Functions; Dealing with the Insert Function Dialog Box; Using Add-ins to Store Custom Functions; Using the Windows API; Chapter 9: VBA Programming Examples and Techniques Learning by Example |
Record Nr. | UNINA-9910786256403321 |
Walkenbach John
![]() |
||
Hoboken, N.J., : Wiley, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2013 power programming with VBA [[electronic resource] /] / by John Walkenbach |
Autore | Walkenbach John |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2013 |
Descrizione fisica | 1 online resource (1107 p.) |
Disciplina | 650.02855365 |
Collana | Mr. Spreadsheet's Bookshelf |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets Electronic spreadsheets - Computer programs |
ISBN |
1-118-49040-1
1-118-49180-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Microsoft® Excel® 2013 Power Programming with VBA; Introduction; 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 This Book's Website; About the Power Utility Pak Offer; How to Use This Book; Part 1: Some Essential Background; Chapter 1: Excel in a Nutshell; About Excel; Thinking in Terms of Objects; Workbooks; Excel's User Interface; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features
Analysis ToolsAdd-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 2: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Excel Auditing Tools; Array Formulas; Counting and Summing Techniques; Lookup Formulas; Working with Dates and Times; Creating Megaformulas; Chapter 3: Understanding Excel Files; Starting Excel; File Types; Excel File Compatibility; Protected View; Using AutoRecover; Working with Template Files; Inside an Excel File; The OfficeUI File; The XLB File; Add-In Files Excel Settings in the RegistryChapter 4: Essentials of Spreadsheet Application Development; What Is a Spreadsheet Application?; Steps for 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 2: Understanding Visual Basic for Applications; Chapter 5: Introducing Visual Basic for Applications; Getting Some BASIC Background; Delving into VBA; Covering the Basics of VBA; Introducing Visual Basic Editor; Working with Project Explorer Working with Code WindowsCustomizing 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 6: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments; Variables, Data Types, and Constants; Assignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 7: Working with VBA Sub Procedures About ProceduresExecuting Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 8: 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; Extended Date Functions; Debugging Functions; Dealing with the Insert Function Dialog Box; Using Add-ins to Store Custom Functions; Using the Windows API; Chapter 9: VBA Programming Examples and Techniques Learning by Example |
Record Nr. | UNINA-9910814172503321 |
Walkenbach John
![]() |
||
Hoboken, N.J., : Wiley, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2013 simplified [[electronic resource] /] / by Paul McFedries |
Autore | McFedries Paul |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, 2013 |
Descrizione fisica | 1 online resource (289 p.) |
Disciplina | 005.54 |
Collana | Simplify it Excel 2013 simplified |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN |
1-299-24244-8
1-118-64755-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910464939403321 |
McFedries Paul
![]() |
||
Indianapolis, Ind., : Wiley, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2013 simplified [[electronic resource] /] / by Paul McFedries |
Autore | McFedries Paul |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, 2013 |
Descrizione fisica | 1 online resource (289 p.) |
Disciplina | 005.54 |
Collana | Simplify it Excel 2013 simplified |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-299-24244-8
1-118-64755-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910789309103321 |
McFedries Paul
![]() |
||
Indianapolis, Ind., : Wiley, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2013 simplified [[electronic resource] /] / by Paul McFedries |
Autore | McFedries Paul |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, 2013 |
Descrizione fisica | 1 online resource (289 p.) |
Disciplina | 005.54 |
Collana | Simplify it Excel 2013 simplified |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-299-24244-8
1-118-64755-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910815643903321 |
McFedries Paul
![]() |
||
Indianapolis, Ind., : Wiley, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2019 Bible / / Michael Alexander, Dick Kusleika ; previously by John Walkenbach |
Autore | Alexander Michael |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN : , : Wiley, , [2019] |
Descrizione fisica | 1 online resource (1,123 pages) |
Disciplina | 005.369 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN |
1-119-54937-X
1-119-51477-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910466835403321 |
Alexander Michael
![]() |
||
Indianapolis, IN : , : Wiley, , [2019] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2019 bible / / Michael Alexander, Dick Kusleika, previously by John Walkenbach |
Autore | Alexander Michael |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind. : , : Wiley, , c2019 |
Descrizione fisica | 1 online resource (1,123 pages) |
Disciplina | 005.369 |
Collana | THEi Wiley ebooks |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-119-51476-2
1-119-54937-X 1-119-51477-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover -- Title Page -- Copyright -- About the Authors -- About the Technical Editors -- Credits -- Acknowledgments -- Contents -- Introduction -- Is This Book for You? -- Software Versions -- Conventions Used in This Book -- Excel commands -- Typographical conventions -- Mouse conventions -- How This Book Is Organized -- How to Use This Book -- What's on the Website -- Part I: Getting Started with Excel -- Chapter 1: Introducing Excel -- Understanding What Excel Is Used For -- Looking at What's New in Excel 2019 -- Understanding Workbooks and Worksheets -- Moving around a Worksheet -- Navigating with your keyboard -- Navigating with your mouse -- Using the Ribbon -- Ribbon tabs -- Contextual tabs -- Types of commands on the Ribbon -- Accessing the Ribbon by using your keyboard -- Using Shortcut Menus -- Customizing Your Quick Access Toolbar -- Working with Dialog Boxes -- Navigating dialog boxes -- Using tabbed dialog boxes -- Using Task Panes -- Creating Your First Excel Workbook -- Getting started on your worksheet -- Filling in the month names -- Entering the sales data -- Formatting the numbers -- Making your worksheet look a bit fancier -- Summing the values -- Creating a chart -- Printing your worksheet -- Saving your workbook -- Chapter 2: Entering and Editing Worksheet Data -- Exploring Data Types -- Numeric values -- Text entries -- Formulas -- Entering Text and Values into Your Worksheets -- Entering numbers -- Entering text -- Using Enter mode -- Entering Dates and Times into Your Worksheets -- Entering date values -- Entering time values -- Modifying Cell Contents -- Deleting the contents of a cell -- Replacing the contents of a cell -- Editing the contents of a cell -- Learning some handy data-entry techniques -- Automatically moving the selection after entering data -- Selecting a range of input cells before entering data.
Using Ctrl+Enter to place information into multiple cells simultaneously -- Changing modes -- Entering decimal points automatically -- Using AutoFill to enter a series of values -- Using AutoComplete to automate data entry -- Forcing text to appear on a new line within a cell -- Using AutoCorrect for shorthand data entry -- Entering numbers with fractions -- Using a form for data entry -- Entering the current date or time into a cell -- Applying Number Formatting -- Using automatic number formatting -- Formatting numbers by using the Ribbon -- Using shortcut keys to format numbers -- Formatting numbers by using the Format Cells dialog box -- Adding your own custom number formats -- Chapter 3: Performing Basic Worksheet Operations -- Learning the Fundamentals of Excel Worksheets -- Working with Excel windows -- Moving and resizing windows -- Switching among windows -- Closing windows -- Activating a worksheet -- Adding a new worksheet to your workbook -- Deleting a worksheet you no longer need -- Changing the name of a worksheet -- Changing a sheet tab color -- Rearranging your worksheets -- Hiding and unhiding a worksheet -- Controlling the Worksheet View -- Zooming in or out for a better view -- Viewing a worksheet in multiple windows -- Comparing sheets side by side -- Splitting the worksheet window into panes -- Keeping the titles in view by freezing panes -- Monitoring cells with a Watch Window -- Working with Rows and Columns -- Inserting rows and columns -- Deleting rows and columns -- Changing column widths and row heights -- Changing column widths -- Changing row heights -- Hiding rows and columns -- Chapter 4: Working with Excel Ranges and Tables -- Understanding Cells and Ranges -- Selecting ranges -- Selecting complete rows and columns -- Selecting noncontiguous ranges -- Selecting multisheet ranges -- Selecting special types of cells. Selecting cells by searching -- Copying or Moving Ranges -- Copying by using Ribbon commands -- Copying by using shortcut menu commands -- Copying by using shortcut keys -- Copying or moving by using drag-and-drop -- Copying to adjacent cells -- Copying a range to other sheets -- Using the Office Clipboard to paste -- Pasting in special ways -- Using the Paste Special dialog box -- Performing mathematical operations without formulas -- Skipping blanks when pasting -- Transposing a range -- Using Names to Work with Ranges -- Creating range names in your workbooks -- Using the Name box -- Using the New Name dialog box -- Using the Create Names from Selection dialog box -- Managing names -- Adding Comments to Cells -- Formatting comments -- Changing a comment's shape -- Reading comments -- Hiding and showing comments -- Editing comments -- Deleting comments -- Working with Tables -- Understanding a table's structure -- The header row -- The data body -- The total row -- The resizing handle -- Creating a table -- Adding data to a table -- Sorting and filtering table data -- Sorting a table -- Filtering a table -- Filtering a table with slicers -- Changing the table's appearance -- Chapter 5: Formatting Worksheets -- Getting to Know the Formatting Tools -- Using the formatting tools on the Home tab -- Using the Mini toolbar -- Using the Format Cells dialog box -- Formatting Your Worksheet -- Using fonts to format your worksheet -- Changing text alignment -- Choosing horizontal alignment options -- Choosing vertical alignment options -- Wrapping or shrinking text to fit the cell -- Merging worksheet cells to create additional text space -- Displaying text at an angle -- Using colors and shading -- Adding borders and lines -- Using Conditional Formatting -- Specifying conditional formatting -- Using graphical conditional formats -- Using data bars. Using color scales -- Using icon sets -- Creating formula-based rules -- Understanding relative and absolute references -- Conditional formatting formula examples -- Identifying weekend days -- Highlighting a row based on a value -- Displaying alternate-row shading -- Creating checkerboard shading -- Shading groups of rows -- Working with conditional formats -- Managing rules -- Copying cells that contain conditional formatting -- Deleting conditional formatting -- Locating cells that contain conditional formatting -- Using Named Styles for Easier Formatting -- Applying styles -- Modifying an existing style -- Creating new styles -- Merging styles from other workbooks -- Controlling styles with templates -- Understanding Document Themes -- Applying a theme -- Customizing a theme -- Chapter 6: Understanding Excel Files and Templates -- Creating a New Workbook -- Opening an Existing Workbook -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- Using AutoRecover -- Recovering versions of the current workbook -- Recovering unsaved work -- Configuring AutoRecover -- Password-Protecting a Workbook -- Organizing Your Files -- Other Workbook Info Options -- Protect Workbook options -- Check for Issues options -- Manage Workbook options -- Browser View options -- Compatibility Mode section -- Closing Workbooks -- Safeguarding Your Work -- Working with Templates -- Exploring Excel templates -- Viewing templates -- Creating a workbook from a template -- Modifying a template -- Using default templates -- Using the workbook template to change workbook defaults -- Creating a worksheet template -- Editing your template -- Resetting the default workbook -- Using custom workbook templates -- Creating custom templates -- Saving your custom templates -- Using custom templates -- Chapter 7: Printing Your Work -- Doing Basic Printing. Changing Your Page View -- Normal view -- Page Layout view -- Page Break Preview -- Adjusting Common Page Setup Settings -- Choosing your printer -- Specifying what you want to print -- Changing page orientation -- Specifying paper size -- Printing multiple copies of a report -- Adjusting the page margins -- Understanding page breaks -- Inserting a page break -- Removing manual page breaks -- Printing row and column titles -- Scaling printed output -- Printing cell gridlines -- Printing row and column headers -- Using a background image -- Adding a Header or a Footer to Your Reports -- Selecting a predefined header or footer -- Understanding header and footer element codes -- Exploring other header and footer options -- Exploring Other Print-Related Topics -- Copying Page Setup settings across sheets -- Preventing certain cells from being printed -- Preventing objects from being printed -- Creating custom views of your worksheet -- Creating PDF files -- Chapter 8: Customizing the Excel User Interface -- Customizing the Quick Access Toolbar -- About the Quick Access toolbar -- Adding new commands to the Quick Access toolbar -- Other Quick Access toolbar actions -- Customizing the Ribbon -- Why you may want to customize the Ribbon -- What can be customized -- How to customize the Ribbon -- Creating a new tab -- Creating a new group -- Adding commands to a new group -- Resetting the Ribbon -- Part II: Working with Formulas and Functions -- Chapter 9: Introducing Formulas and Functions -- Understanding Formula Basics -- Using operators in formulas -- Understanding operator precedence in formulas -- Using functions in your formulas -- Examples of formulas that use functions -- Function arguments -- More about functions -- Entering Formulas into Your Worksheets -- Entering formulas manually -- Entering formulas by pointing. Pasting range names into formulas. |
Altri titoli varianti | Microsoft Excel 2019 bible |
Record Nr. | UNINA-9910526529603321 |
Alexander Michael
![]() |
||
Indianapolis, Ind. : , : Wiley, , c2019 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel best practices for business [[electronic resource] /] / Loren Abdulezer |
Autore | Abdulezer Loren |
Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub., c2004 |
Descrizione fisica | 1 online resource (547 p.) |
Disciplina | 005.54 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN |
1-280-35184-5
9786610351848 0-7645-5756-4 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Excel Best Practices for Business; About the Author; Credits; Preface; Acknowledgments; Contents at a Glance; Contents; Introduction; How to Use This Book; What You Need to Use This Book; What This Book Covers; Conventions Used in this Book; Icons Used in the Book; How This Book Is Organized; Part I: Best Practice Essentials; Chapter 1: A Foundation for Developing Best Practices; Preliminaries; Working with Different Ways To Compute a Number in Excel; Understanding Alternative Ways to Represent Cells; Computing a Number in Excel; Excel Functions; Closing Thoughts
Chapter 2: Mastering Spreadsheet Construction Techniques One Size Does Not Fit All; Understanding Simple Spreadsheets; Building a Spreadsheet: A Simple Example; Complex Spreadsheets; Closing Thoughts; Chapter 3: Your Handy Reference for Manipulating Data; Excel String Manipulation Functions You Need to Know; Sorting Techniques; First Steps to Tidying Up Your Data; The Sentinel Look Ahead Technique; Other Functions for Effective Data Manipulation; Useful Sorting Techniques; Data Surgery and Data Manipulation; Closing Thoughts; Chapter 4: Compiling, Managing, and Viewing Your Data; Preliminaries The Number Line-Up Putting Data into Perspective with Pivot Tables; Preparing Your Data; Closing Thoughts; Part II: Spreadsheet Ergonomics; Chapter 5: Scaling the Peaks of Mt. Data; The Art of Data Slogging; Climbing Past the Foothills; Closing Thoughts; Chapter 6: Let the Data Speak for Itself: Viewing and Presenting Data; They Threw In the Kitchen Sink; Using Excel Filters; Presentation Tear Sheets; Advanced Filters; Tips for Spreadsheet Comments; Closing Thoughts; Chapter 7: Creating and Using Smart Data; What Is Smart Data, Anyhow?; Conditional Formatting From RAGs to Riches: An Interactive Array of Colors Perimeter Surveillance: Smart Borders; Miscellaneous Topics; Closing Thoughts; Chapter 8: Analyzing Data; Charting Your Course in a Sea of Data; Quantifying Uncertainty: Techniques and Rules; Data Sculpting: Crafting Data with the Excel Goal Seek and Solver Tools; Suggestions for Further Reading; Closing Thoughts; Chapter 9: How Not to Get Stuck in the MUD ( Messed-Up Data); Ambiguous and Incomplete Data; Inconsistent Data and Computations; Square Peg/Round Hole Scenario; Analyses/Reports Built on Too Much White Noise or Static Closing Thoughts Part III: Special Topics: Getting the Numbers Right; Chapter 10: Going for the Face lift: Spreadsheet Makeovers; Spreadsheet Makeover Techniques; A Hands-On Example of a Spreadsheet Makeover; Alternative Approaches; Closing Thoughts; Chapter 11: Spreadsheet Auditing: Challenging the Numbers of Others; Structural Analysis of Spreadsheets; Off-Spreadsheet Analysis; State Transition Analysis; Testing the Reasonableness of Spreadsheets; Closing Thoughts; Chapter 12: Spreadsheet Portals, XML, and Web Services; Spreadsheet Portals and Desktop Client Portals; Simple Client Portals Complex Spreadsheet Portals |
Record Nr. | UNINA-9910455756903321 |
Abdulezer Loren
![]() |
||
Indianapolis, IN, : Wiley Pub., c2004 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|