x

Our Privacy Policy has changed. By using this site, you agree to the Privacy Policy.

Excel 2013 for Dummies

ISBN-10: 1118510127
ISBN-13: 9781118510124
Edition: 2013
Authors: Greg Harvey
List price: $24.99 Buy it from $16.19
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: Excel 2013 For Dummies will be updated to reflect the major changes Microsoft is making to Office. Covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, entering  More...

New Starting from $20.14
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.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $24.99
Copyright year: 2013
Publisher: John Wiley & Sons, Incorporated
Publication date: 1/29/2013
Binding: Paperback
Pages: 408
Size: 7.50" wide x 9.25" long x 1.00" tall
Weight: 1.606

Excel 2013 For Dummies will be updated to reflect the major changes Microsoft is making to Office. Covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and sending worksheets via e-mail. 

Greg Harvey is a prolific author of personal computing books that are highly informative, yet entertaining and easy to understand. Harvey earned a B.A. in classics and American history from the University of Illinois in Urbana in 1970. He moved to San Francisco the following year and worked as a draftsman on civil engineering projects for the next 10 years Harvey became interested in the growing computer field in the early 1980s. While teaching college computer classes at Golden Gate University, he wrote his first books, WordPerfect Desktop Companion (1987) and WordPerfect Instant Reference (1988). Since then, he has written, in his own words, "tons of books." These include Lotus 1-2-3 Instant Reference (1989), Encyclopedia Lotus 1-2-3 (1991), and WordPerfect 6 for Windows Quickstart (1993). Since 1993, Harvey has written exclusively for Dummies Press of IDG Books, for whom he has turned out several personal computing classics, such as 1-2-3 for Dummies (1993), DOS for Dummies (third edition, 1998), and Excel 2000 for Windows for Dummies (1998).

Introduction
About This Book
How to Use This Book
What You Can Safely Ignore
Foolish Assumptions
How This Book Is Organized
Getting Started with Excel 2013
Editing without Tears
Getting Organized and Staying That Way
Digging Data Analysis
Life beyond the Spreadsheet
The Part of Tens
Conventions Used in This Book
Selecting Ribbon commands
Icons Used in This Book
Where to Go from Here
Getting Started With Excel 2013
The Excel 2013 User Experience
Excel's Ribbon User Interface
Going Backstage
Using the Excel Ribbon
Customizing the Quick Access toolbar
Having fun with the Formula bar
What to do in the Worksheet area
Showing off the Status bar
Launching and Quitting Excel
Starting Excel from the Windows 8 Start screen
Starting Excel from the Windows 7 Start menu
Adding an Excel 2013 shortcut to your Windows 7 desktop
Pinning Excel 2013 to your Windows 7 Start menu
Pinning Excel 2013 to the Windows 7 taskbar
Exiting Excel
Help Is on the Way
Creating a Spreadsheet from Scratch
So What Ya Gonna Put in That New Workbook of Yours?
The ins and outs of data entry
You must remember this
Doing the Data-Entry Thing
It Takes All Types
The telltale signs of text
How Excel evaluates its values
Fabricating those fabulous formulas!
If you want it, just point it out
Altering the natural order of operations
Formula flub-ups
Fixing Those Data Entry Flub-Ups
You really AutoCorrect that for me
Cell editing etiquette
Taking the Drudgery out of Data Entry
I'm just not complete without you
Fill 'er up with AutoFill
Fill it in a flash
Inserting special symbols
Entries all around the block
Data entry express
How to Make Your Formulas Function Even Better
Inserting a function into a formula with the Insert Function button
Editing a function with the Insert Function button
I'd be totally lost without AutoSum
Sums via Quick Analysis Totals
Making Sure That the Data Is Safe and Sound
Changing the default file location
The difference between the XLSX and XLS file format
Saving the Workbook as a PDF File
Document Recovery to the Rescue
Editing Without Tears
Making It All Look Pretty
Choosing a Select Group of Cells
Point-and-click cell selections
Keyboard cell selections
Using the Format as Table Gallery
Cell Formatting from the Home Tab
Formatting Cells Close to the Source with the Mini-bar
Using the Format Cells Dialog Box
Understanding the number formats
The values behind the formatting
Make it a date!
Ogling some of the other number formats
Calibrating Columns
Rambling rows
Now you see it, now you don't
Futzing with the Fonts
Altering the Alignment
Intent on indents
From top to bottom
Tampering with how the text wraps
Reorienting cell entries
Shrink to fit
Bring on the borders!
Applying fill colors, patterns, and gradient effects to cells
Doing It in Styles
Creating a new style for the gallery
Copying custom styles from one workbook into another
Fooling Around with the Format Painter
Conditional Formatting
Formatting with scales and markers
Highlighting cells ranges
Formatting via the Quick Analysis tool
Going Through Changes
Opening Your Workbooks for Editing
Opening files in the Open screen
Operating the Open dialog box
Changing the Recent files settings
Opening multiple workbooks
Find workbook files
Using the Open file options
Much Ado about Undo
Undo is Redo the second time around
What to do when you can't Undo?
Doing the Old Drag-and-Drop Thing
Copies, drag-and-drop style
Insertions courtesy of drag and drop
Copying Formulas with AutoFill
Relatively speaking
Some things are absolutes!
Cut and Paste, Digital Style
Paste it again, Sam
Keeping pace with Paste Options
Paste it from the Clipboard task pane
So what's so special about Paste Special?
Let's Be Clear about Deleting Stuff
Sounding the all clear!
Get these cells outta here!
Staying in Step with Insert
Stamping Out Your Spelling Errors
Eliminating Errors with Text to Speech
Printing the Masterpiece
Previewing Pages in Page Layout View
Using the Backstage Print Screen
Printing the Current Worksheet
My Page Was Set Up!
Using the buttons in the Page Setup group
Using the buttons in the Scale to Fit group
Using the Print buttons in the Sheet Options group
From Header to Footer
Adding an Auto Header and Footer
Creating a custom header or footer
Solving Page Break Problems
Letting Your Formulas All Hang Out
Getting Organized and Staying That Way
Maintaining the Worksheet
Zooming In and Out
Splitting the Worksheet into Windows
Fixed Headings with Freeze Panes
Electronic Sticky Notes
Adding a comment to a cell
Comments in review
Editing comments in a worksheet
Getting your comments in print
The Range Name Game
If I only had a name
Name that formula!
Naming constants
Seek and Ye Shall Find
Replacing Cell Entries
Doing Your Research
Controlling Recalculation
Putting on the Protection
Maintaining Multiple Worksheets
Juggling Multiple Worksheets
Sliding between the sheets
Editing en masse
Don't Short-Sheet Me!
A worksheet by any other name
A sheet tab by any other color
Getting your sheets in order
Opening Windows on Your Worksheets
Comparing Worksheets Side by Side
Shifting Sheets to Other Workbooks
Summing Stuff on Different Worksheets
Digging data Analysis
Doing What-lf Analysis
Playing What-lf with Data Tables
Creating a one-variable data table
Creating a two-variable data table
Playing What-lf with Goal Seeking
Making the Case with Scenario Manager
Setting up the various scenarios
Producing a summary report
Playing with Pivot Tables
Data Analysis with Pivot Tables
Pivot tables via the Quick Analysis tool
Pivot tables by recommendation
Manually producing pivot tables
Formatting Pivot Tables
Refining the Pivot Table style
Formatting values in the pivot table
Sorting and Filtering Pivot Table Data
Filtering the report
Filtering column and row fields
Filtering with slicers
Filtering with timelines
Sorting the pivot table
Modifying Pivot Tables
Modifying the pivot table fields
Pivoting the table's fields
Modifying the table's summary function
Creating Pivot Charts
Moving pivot charts to separate sheets
Filtering pivot charts
Formatting pivot charts
Life beyond the Spreadsheet
Charming Charts and Gorgeous Graphics
Making Professional-Looking Charts
Charts thanks to Recommendation
Charts from the Ribbon
Charts via the Quick Analysis tool
Charts on their own chart sheets
Moving and resizing embedded charts
Moving embedded charts to chart sheets
Customizing charts from the Design tab
Customizing chart elements
Editing the generic titles in a chart
Adding Great-Looking Graphics
Sparking up the data with sparklines
Telling all with a text box
Downloading online images
Inserting local images
Editing inserted pictures
Formatting inserted images
Adding preset graphic shapes
Working with WordArt
Make mine SmartArt
Screenshots anyone?
Theme for a day
Controlling How Graphic Objects Overlap
Reordering the layering of graphic objects
Grouping graphic objects
Hiding graphic objects
Printing Just the Charts
Getting on the Data List
Creating Data Lists
Adding records to data lists
Moving through records in the data form
Finding records with the data form
Sorting Data Lists
Sorting on a single field
Sorting on multiple fields
Filtering Data Lists
Using ready-made number filters
Using ready-made date filters
Using custom filters
Importing External Data
Querying Access database tables
Performing web queries
Linking, Automating, and Sharing Spreadsheets
Using Apps for Office
Using Excel Add-Ins
Adding Hyperlinks to a Worksheet
Automating Commands with Macros
Recording new macros
Running macros
Assigning macros to the Ribbon and the Quick Access toolbar
Sharing Your Worksheets
Sharing workbooks via SkyDrive
E-mailing workbooks
Sharing workbooks with IM
Presenting worksheets online
Editing worksheets online
Reviewing workbooks online
The Part of Tens
Top Ten Beginner Basics
The Ten Commandments of Excel 2013
Index

×
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.

×