| Contents Notes |
Introduction: -- About this book -- How to use this book -- What you can safely ignore -- Foolish assumptions -- How this book is organized: -- Part 1: Getting Started with Excel 2013 -- Part 2: Editing without tears -- Part 3: Getting organized and staying that way -- Part 4: Digging data analysis -- Part 5: Life beyond the spreadsheet -- Part 6: Part of tens -- Conventions used in this book: -- Selecting Ribbon commands -- Icons used in this book -- Where to go from here -- Part 1: Getting Started With Excel 2013: -- 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 for 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?: -- Ins and outs of data entry -- You must remember this -- Doing the data-entry thing -- It Takes All Types: -- 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 -- Difference between the XLSX and XLS file formats -- Saving the Workbook as a PDF file -- Document Recovery to the rescue -- Part 2: 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 -- Value 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 Workbook For Editing: -- Opening files in the Open screen -- Operating the Open dialog box -- Changing the recent file 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 hand out. Part 3: 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 -- 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! -- Worksheet by any other name -- 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 -- Part 4: Digging Data Analysis: -- Doing What-If Analysis: -- Playing What-If With Data Tables: -- Creating a one-variable data table -- Creating a two-variable data table -- Playing what-if 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 -- Part 5: 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 spark-lines -- 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 OneDrive -- E-mailing workbooks -- Sharing workbooks with IM -- Presenting Worksheets online -- Editing Worksheets online -- Reviewing workbooks online -- Part 6: Part of Tens: -- Top Ten Beginner Basics -- Ten Commandments Of Excel 2013 -- Index. Overview: The bestselling Excel book - completely updated for Excel 2013!. As the world's leading spreadsheet application, Excel has an enormous user base. The release of Office 2013 brings major changes to Excel, so Excel For Dummies comes to the rescue once more! Featuring the friendly For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Walks you through the exciting new features of Excel 2013. -- Presents everything you need to know to perform basic Excel 2013 tasks. -- Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records. -- Discusses printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and much more. Whether you're new to Excel or are looking to get up and running with the 2013 version, Excel 2013 For Dummies has everything you need to know! |
