Microsoft Excel 2013
Full-color, step-by-step guide to the new release of the world's most popular spreadsheet application Get up and running with Excel 2013 right away--the QuickSteps way. Full-color screenshots on every page with clear instructions make it easy to use the latest release of Microsoft's powerf...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified]
McGraw Hill Education
2013
|
| Edición: | 3rd ed |
| Colección: | QuickSteps
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009755076006719 |
Tabla de Contenidos:
- Cover
- About the Authors
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- Conventions Used in This Book
- Chapter 1: Stepping into Excel
- Start and Explore Excel
- Open Excel
- Using Touch
- Explore the Excel Window
- Become Familiar with the Ribbon
- Work with File View
- Customize the Ribbon
- Customize the Quick Access Toolbar
- Get Help
- Open Help
- Use the Excel Help Window
- Understanding Versions of Office 2013
- Use Workbooks
- Create a New Workbook
- Open an Existing Workbook
- Change the Appearance of New Workbooks
- Save a Workbook
- Understanding Excel's XML File Formats
- Understanding Excel File Compatibility
- Add Identifying Information
- Exit an Excel Session
- Chapter 2: Entering and Editing Data
- Understanding Data Types
- Enter Data
- Enter Text
- Complete an Entry
- Enter Numeric Data
- Enter Dates
- Format Numbers
- Understanding Excel Dates and Times
- Use Times
- Add Data Quickly
- Edit Data
- Edit Cell Data
- Remove Cell Contents
- Select Cells and Ranges
- Copy and Paste Data
- Use the Office Clipboard
- Find and Replace Data
- Verify Spelling
- Modify Automatic Corrections
- Chapter 3: Formatting a Worksheet
- Work with Cells, Rows, and Columns
- Add and Remove Rows, Columns, and Cells
- Adjust Row Height
- Adjust Column Width
- Hide and Unhide Rows and Columns
- Change Cell Borders
- Add a Comment
- Format Comments
- Understanding Excel Formatting
- Apply Formatting
- Apply Themes
- Create Custom Themes
- Search for Themes
- Use Cell Styles
- Change Fonts
- Change Alignment and Orientation
- Add a Background
- Copy Formatting
- Arrange and Organize Worksheets
- Lock Rows and Columns
- Split a Worksheet
- View Worksheets from Multiple Workbooks
- Compare Workbooks
- Work with Worksheets.
- Chapter 4: Using Formulas and Functions
- Reference Cells
- Change Cell References
- Understanding Cell Referencing Types
- Change to R1C1 References
- Name Cells
- Go to a Named Cell
- Using Cell Reference Operators
- Use the Name Manager
- Build Formulas
- Create a Formula
- Adding a Symbolic Formula
- Edit a Formula
- Use Formulas
- Move Formulas
- Copy Formulas
- Recalculate Formulas
- Use External References in Formulas
- Understanding the Trust Center
- Format Conditionally
- Use Functions
- Using Functions Quickly
- Enter a Function
- Enter a Sum in Columns or Rows Quickly
- Find and Correct Errors
- Check for Errors
- Trace Precedent and Dependent Cells
- Watch a Cell
- Evaluate a Formula in Pieces
- Chapter 5: Viewing and Printing Data
- Understanding Excel Views
- Lay Out a Worksheet
- Add Headers and Footers
- Add Content to Headers and Footers
- Add Pictures to Headers and Footers
- Change Margins
- Select Page Orientation
- Work with Zoom
- Use Headings as Page Titles
- Print the Data
- Choose Worksheet Print Options
- Change the Order in Which Pages Print
- Print Comments
- Choose What to Print
- Use Print Areas
- Preview the Print Job
- Scale Your Data Before Printing
- Output the Print Job
- Save and View Custom Views
- Chapter 6: Charting Data
- Create and Design a Chart
- Build a Chart
- Choose a Chart Type
- Selecting Data for Charting
- Choose a Chart Location
- Modify How the Data Is Plotted
- Apply a Chart Layout
- Change a Chart's Style
- Modify Chart Elements
- Select Chart Elements
- Add Titles
- Show or Hide Axes
- Add or Remove Gridlines
- Identifying Chart Elements
- Show or Hide a Legend
- Add Data Labels
- Display the Data Table
- Create Your Own Chart Type
- Use Chart Templates
- Create a Combo Chart
- Format Chart Elements.
- Change Column and Bar Shapes
- Use Charts
- Work with Charts
- Add Charts Elsewhere
- Analyze Charts
- Print a Chart
- Create Sparklines
- Work with Sparklines
- Chapter 7: Working with Illustrations
- Understanding Illustrations
- Add Illustrations
- Add Shapes
- Work with Curves
- Add Text
- Use SmartArt
- Changing SmartArt
- Insert Pictures
- Using Pictures
- Take Screenshots
- Work with Illustrations
- Select, View, and Delete Illustrations
- Use Handles and Borders to Change Illustrations
- Crop Pictures
- Position Illustrations
- Combine Illustrations by Grouping
- Format Illustrations and Text
- Use Styles
- Apply Styling Elements to Pictures
- Change a Picture's Attributes
- Change a Shape's Fill
- Add WordArt Styling to Text
- Make Detailed Formatting Changes
- Chapter 8: Managing Data
- Understanding Excel Tables
- Build Tables
- Create a Table
- Change Rows and Columns in a Table
- Add a Total Row
- Apply Styles to a Table
- Work with Tables
- Validate Data
- Locate Validation Data
- Organize Data
- Sort Data by Columns and Rows
- Create an AutoFilter
- Remove Filters
- Use Advanced Filtering
- Setting Up Criteria and Extract Ranges
- Outline Data Automatically
- Use Outlines
- Outline Data by Manually Grouping
- Add Subtotals
- Chapter 9: Analyzing and Sharing Data
- Get the Results You Want
- Use Goal Seek
- Compare Alternatives Using Scenarios
- Use a One-Variable Columnar Data Table
- Use Multiple Variables to Provide a Result
- Explaining the Solver Example
- Save Solver Results and Settings
- Change Solver Settings
- Work with PivotTables
- Create a PivotTable
- Understanding PivotTable Terms
- Create the PivotTable Layout
- Use PivotTables
- Use Slicers
- Style a PivotTable
- Create a PivotTable Chart
- Work with Other Users
- Preparing to Share Workbooks.
- Protect Workbooks with Passwords
- Share a Workbook
- Work with Changes in a Shared Workbook
- Protect a Shared Workbook
- Discontinue Sharing a Workbook
- Merging Workbooks
- Work with Views
- Protect Worksheet and Workbook Elements
- Chapter 10: Extending Excel
- Acquire Data
- Convert Text to Data
- Add a Table from an Access Database
- Get Data from the Web
- Add External Data from Existing Connections
- Set External Data Range Properties
- Manage Connections
- Use Excel with Web Technology
- Understanding the Difference Between Save and Publish
- Save a Workbook as a Webpage
- Publish Workbook Items as a Webpage
- Understanding SkyDrive and SharePoint
- Use Hyperlinks
- Automate Excel
- Use Recorded Macros
- Edit a Macro
- Index.
