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