Excel 2019 bible / / Michael Alexander, Dick Kusleika, previously by John Walkenbach

• Record Nr.: UNINA9910526529603321
• Autore: Alexander Michael
• Pubbl/distr/stampa: Indianapolis, Ind. : , : Wiley, , c2019
• ISBN: 1-119-51476-2; 1-119-54937-X; 1-119-51477-0
• Edizione: [1st edition]
• Descrizione fisica: 1 online resource (1,123 pages)
• Collana: THEi Wiley ebooks
• Disciplina: 005.369
• Soggetti: Business - Computer programs; Electronic spreadsheets
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index
• 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.
• Sommario/riassunto: The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.

Innovations in Multivariate Statistical Modeling : Navigating Theoretical and Multidisciplinary Domains / / edited by Andriëtte Bekker, Johannes T. Ferreira, Mohammad Arashi, Ding-Geng Chen

• Record Nr.: UNINA9910635396703321
• Pubbl/distr/stampa: Cham : , : Springer International Publishing : , : Imprint : Springer, , 2022
• ISBN: 9783031139710; 3031139712
• Edizione: [1st ed. 2022.]
• Descrizione fisica: 1 online resource (434 pages)
• Collana: Emerging Topics in Statistics and Biostatistics, , 2524-7743
• Disciplina: 780; 519.535
• Soggetti: Statistics; Applied Statistics; Statistical Theory and Methods; Anàlisi multivariable; Llibres electrònics
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Nota di bibliografia: Includes bibliographical references.
• Nota di contenuto: Preface -- PART 1: Trends in Multi- and Matrix-Variate Analysis -- Q. Guo, X. Deng and N. Ravishanker: Association-based Optimal Subpopulation Selection of Multivariate Data -- T. B. Mattos, L. A. Matos, V. H Lachos Aldo: Likelihood-Based Inference For Linear Mixed-Effects Models With Censored Response Using Skew-Normal Distribution -- Y. Melnykov, M. Perry, V. Melnykov: Robust Estimation of Multiple Change Points in Multivariate Processes -- T. Botha, J. T Ferreira and A. Bekker: Some Computational Aspects Of A Noncentral Dirichlet Family -- Y. Murat Bulut and Olcay Arslan: Modeling Handwritten Digits Dataset Using The Matrix Variate T Distribution -- B. Byukusenge, D. von Rosen and M. Singull: On The Identification Of Extreme Elements In A Residual For The Gmanova-Manova Model -- M. Billio, R. Casarin, M. Costola and M. Iacopini: Matrix-variate Smooth Transition Models for Temporal Networks -- H. Baghishani and J. Ownuk: A Flexible Matrix-Valued Response Regression For Skewed ; Data -- J. Trink,H. Haghbin and M. Maadooliat: Multivariate Functional Singular Spectrum Analysis: A Nonparametric Approach for Analyzing Functional Time Series -- M. Greenacre: Compositional Data Analysis — Linear Algebra, Visualization And Interpretation -- A. Alzaatreh, F. Famoye and C. Lee: Multivariate Count Data Regression Models And Their Applications -- A. Iranmanesh, M. Rafiei and D. Nagar: A Generalized Multivariate Gamma Distribution -- PART 2: Aspects of High Dimensional Methodology and Bayesian Learning -- G. D' Angella and C. Hennig: A Comparison Of Different Clustering Approaches For High-Dimensional Presence-Absence Data -- S. Millard, M. Arashi and G. Maribe: High-Dimensional Feature Selection For Logistic Regression Using Blended Penalty Functions -- I. Munaweera, S. Muthukumarana and M. Jafari Jozani: A Generalized Quadratic Garrote Approach Towards Ridge Regression Analysis -- M. Roozbeh: High Dimensional Nonlinear Optimization Problem In Semiparametric Regression Model -- PART 3: Frontiers in Robust Analysis and Mixture Modelling -- A. Punzo and S. D. Tomarchia: Parsimonious Finite Mixtures Of Matrix-Variate Regressions -- F. Zehra Doğru and Olcay Arslan:Robust Multivariate Modelling for Heterogeneous Data Sets With Mixtures of Multivariate Skew Laplace Normal Distributions -- M. Norouzirad, M. Arashi, F. J Marques and F. Esmaeili: Robust Estimation Through Preliminary Testing Based On The Lad-Lasso.
• Sommario/riassunto: Multivariate statistical analysis has undergone a rich and varied evolution during the latter half of the 20th century. Academics and practitioners have produced much literature with diverse interests and with varying multidisciplinary knowledge on different topics within the multivariate domain. Due to multivariate algebra being of sustained interest and being a continuously developing field, its appeal breaches laterally across multiple disciplines to act as a catalyst for contemporary advances, with its core inferential genesis remaining in that of statistics. It is exactly this varied evolution caused by an influx in data production, diffusion, and understanding in scientific fields that has blurred many lines between disciplines. The cross-pollination between statistics and biology, engineering, medical science, computer science, and even art, has accelerated the vast amount of questions that statistical methodology has to answer and report on. These questions are often multivariate in nature, hoping to elucidate uncertainty on more than one aspect at the same time, and it is here where statistical thinking merges mathematical design with real life interpretation for understanding this uncertainty. Statistical advances benefit from these algebraic inventions and expansions in the multivariate paradigm. This contributed volume aims to usher novel research emanating from a multivariate statistical foundation into the spotlight, with particular significance in multidisciplinary settings. The overarching spirit of this volume is to highlight current trends, stimulate a focus on, and connect multidisciplinary dots from and within multivariate statistical analysis. Guided by these thoughts, a collection of research at the forefront of multivariate statistical thinking is presented here which has been authored by globally recognized subject matter experts.