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