Excel 2019 Bible
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 a...
| Otros Autores: | , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley
[2018]
|
| Colección: | Wiley ebooks.
|
| Acceso en línea: | Conectar con la versión electrónica |
| Ver en Universidad de Navarra: | https://innopac.unav.es/record=b40635284*spi |
Tabla de Contenidos:
- 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 mouseUsing 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 DataExploring 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 simultaneouslyChanging 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 boxAdding 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.
