Microsoft Excel 2013 Step by Step

Name: Microsoft Excel 2013 Step by Step
Price: 3.93 USD
Availability: InStock
ISBN: 9780735681019

ISBN-10: 0735681015

ISBN-13: 9780735681019

Edition: 2013

Authors: Curtis Frye

List price: $25.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $3.93

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

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

Book details

List price: $25.99
Copyright year: 2013
Publisher: Microsoft Press
Publication date: 4/15/2013
Binding: Paperback
Pages: 512
Size: 7.30" wide x 8.80" long x 1.30" tall
Weight: 1.826
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