Microsoft� Excel 2013

ISBN-10: 0735681015

ISBN-13: 9780735681019

Edition: 2013

Authors: Curtis D. Frye

List price: $27.99 Buy it from $13.07
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description:

The smart way to learn Excel 2013—one step at a time!Experience learning made easy—and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.Discover how to:Work with Excel 2013 in touch modeWrite formulas, create macros, and organize dataPresent data visually and add images to worksheetsConsolidate multiple sets of data into a single workbookAnalyze data using the Quick Analysis LensCollaborate with colleagues and present workbooks online
New Starting from $30.59
eBooks Starting from $27.99
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $27.99
Copyright year: 2013
Publisher: Microsoft Press
Publication date: 3/31/2014
Binding: Paperback
Pages: 512
Size: 7.50" wide x 9.00" long x 1.00" tall
Weight: 2.068
Language: English

Curtis Frye is the author of numerous books on Excel and other Office products, most recently Microsoft Excel 2010 Step by Step. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×