Excel 2013 for dummies

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.