Excel 2016 Bible
The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features a...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, New Jersey :
John Wiley & Sons, Inc
[2015]
|
| Edición: | 1st edition |
| Colección: | Bible
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629850306719 |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright
- Contents
- Acknowledgments
- Introduction
- Part I: Getting Started with Excel
- Chapter 1: Introducing Excel
- Identifying What Excel Is Good For
- Seeing What's New in Excel 2016
- 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 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 cell pointer after entering data
- Using navigation keys instead of pressing Enter
- Selecting a range of input cells before entering data
- Using Ctrl+Enter to place information into multiple cells simultaneously
- 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: Essential 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 Cells and Ranges
- 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
- Printing comments
- Hiding and showing comments
- Selecting comments
- Editing comments
- Deleting comments
- Chapter 5: Introducing Tables
- What Is a Table?
- Creating a Table
- Changing the Look of a Table
- Working with Tables
- Navigating in a table
- Selecting parts of a table
- Adding new rows or columns
- Deleting rows or columns
- Moving a table
- Working with the Total Row
- Removing duplicate rows from a table
- Sorting and filtering a table
- Sorting a table
- Filtering a table
- Filtering a table with slicers
- Converting a table back to a range
- Chapter 6: Worksheet Formatting
- Getting to Know the Formatting Tools
- Using the formatting tools on the Home tab
- Using the Mini toolbar
- Using the Format Cells dialog box
- Using Different 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
- Controlling the text direction
- Using Colors and Shading
- Adding Borders and Lines
- Adding a Background Image to a Worksheet
- 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 7: Understanding Excel Files
- 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 Versions options
- Browser View options
- Compatibility Mode section
- Closing Workbooks
- Safeguarding Your Work
- Excel File Compatibility
- Checking compatibility
- Recognizing the Excel 2016 file formats
- Saving a file for use with an older version of Excel
- Chapter 8: Using and Creating Templates
- Exploring Excel Templates
- Viewing templates
- Creating a workbook from a template
- Modifying a template
- Understanding Custom Excel Templates
- Working with the default templates
- Using the workbook template to change workbook defaults
- Creating a worksheet template
- Editing your template
- Resetting the default workbook
- Creating custom templates
- Saving your custom templates
- Using custom templates
- Getting ideas for creating templates
- Chapter 9: Printing Your Work
- 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
- Other header and footer options
- 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
- Part II: Working with Formulas and Functions
- Chapter 10: 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
- Inserting functions into formulas
- Function entry tips
- Editing Formulas
- Using Cell References in Formulas
- Using relative, absolute, and mixed references
- Changing the types of your references
- Referencing cells outside the worksheet
- Referencing cells in other worksheets
- Referencing cells in other workbooks
- Using Formulas in Tables
- Summarizing data in a table
- Using formulas within a table
- Referencing data in a table
- Correcting Common Formula Errors
- Handling circular references
- Specifying when formulas are calculated
- Using Advanced Naming Techniques
- Using names for constants
- Using names for formulas
- Using range intersections
- Applying names to existing references
- Working with Formulas
- Not hard-coding values
- Using the Formula bar as a calculator
- Making an exact copy of a formula
- Converting formulas to values.
- Chapter 11: Creating Formulas That Manipulate Text.
