- Browse
- » Microsoft Excel 2013
Microsoft Excel 2013
Author
Publisher
Varies, see individual formats and editions
Publication Date
Varies, see individual formats and editions
Language
English
Description
Loading Description...
Table of Contents
From the Book
Introduction
Who this book is for
How this book is organized
Download the practice files
Your companion ebook
Getting support and giving feedback
Errata
We want to hear from you
Stay in touch
1. Getting started with Excel 2013
Identifying the different Excel 2013 programs
Identifying new features of Excel 2013
If you are upgrading from Excel 2010
If you are upgrading from Excel 2007
If you are upgrading from Excel 2003
Working with the ribbon
Customizing the Excel 2013 program window
Zooming in on a worksheet
Arranging multiple workbook windows
Adding buttons to the Quick Access Toolbar
Customizing the ribbon
Maximizing usable space in the program window
Creating workbooks
Modifying workbooks
Modifying worksheets
Inserting rows, columns, and cells
Merging and unmerging cells
Key points
2. Working with data and Excel tables
Entering and revising data
Managing data by using Flash Fill
Moving data within a workbook
Finding and replacing data
Correcting and expanding upon worksheet data
Defining Excel tables
Key points
3. Performing calculations on data
Naming groups of data
Creating formulas to calculate values
Summarizing data that meets specific conditions
Working with iterative calculation options and automatic workbook calculation
Using array formulas
Finding and correcting errors in calculations
Key points
4. Changing workbook appearance
Formatting cells
Defining styles
Applying workbook themes and Excel table styles
Making numbers easier to read
Changing the appearance of data based on its value
Adding images to worksheets
Key points
5. Focusing on specific data by using filters
Limiting data that appears on your screen
Filtering Excel table data by using slicers
Manipulating worksheet data
Selecting list rows at random
Summarizing worksheets by using hidden and filtered rows
Finding unique values within a data set
Defining valid sets of values for ranges of cells
Key points
6. Reordering and summarizing data
Sorting worksheet data
Sorting data by using custom lists
Organizing data into levels
Looking up information in a worksheet
Key points
7. Combining data from multiple sources
Using workbooks as templates for other workbooks
Linking to data in other worksheets and workbooks
Consolidating multiple sets of data into a single workbook
Key points
8. Analyzing data and alternative data sets
Examining data by using the Quick Analysis Lens
Defining an alternative data set
Defining multiple alternative data sets
Analyzing data by using data tables
Varying your data to get a specific result by using Goal Seek
Finding optimal solutions by using Solver
Analyzing data by using descriptive statistics
Key points
9. Creating charts and graphics
Creating charts
Customizing the appearance of charts
Finding trends in your data
Creating dual-axis charts
Summarizing your data by using sparklines
Creating diagrams by using SmartArt
Creating shapes and mathematical equations
Key points
10. Using PivotTables and PivotCharts
Analyzing data dynamically by using PivotTables
Filtering, showing, and hiding PivotTable data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from external data
Creating dynamic charts by using PivotCharts
Key points
11. Printing worksheets and charts
Adding headers and footers to printed pages
Preparing worksheets for printing
Previewing worksheets before printing
Changing page breaks in a worksheet
Changing the page printing order for worksheets
Printing worksheets
Printing parts of worksheets
Printing charts
Key points
12. Working with macros and forms
Enabling and examining macros
Changing macro security settings
Examining macros
Creating and modifying macros
Running macros when a button is clicked
Running macros when a workbook is opened
Inserting form controls and setting form properties
Adding text boxes to UserForms
Adding list boxes to UserForms
Adding combo boxes to UserForms
Adding option buttons to UserForms
Adding graphics to UserForms
Adding spin buttons to UserForms
Writing UserForm data to a worksheet
Displaying, loading, and hiding UserForms
Key points
13. Working with other Office programs
Linking to Office documents from workbooks
Embedding workbooks into other Office documents
Creating hyperlinks
Pasting charts into other Office documents
Key points
14. Collaborating with colleagues
Sharing workbooks
Saving workbooks for electronic distribution
Managing comments
Tracking and managing colleagues' changes
Protecting workbooks and worksheets
Authenticating workbooks
Saving workbooks as web content
Importing and exporting XML data
Working with SkyDrive and Excel Web App
Key points
Glossary
Keyboard shortcuts
Ctrl combination shortcut keys
Function keys
Other useful shortcut keys
Index
About the author
Excerpt
Loading Excerpt...
Author Notes
Loading Author Notes...
More Details
ISBN
9780735669390
9780735672086
9780735681019
9780735672086
9780735681019
Staff View
Loading Staff View.

