Includes index.

Getting Started with Excel 2016 -- The Excel 2016 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 10 Start menu -- Starting Excel from the Windows 10 Ask Me Anything text box -- Starting Excel from the Windows 8 Start screen -- Starting Excel from the Windows 7 Start menu -- Adding an Excel 2016 shortcut to your Windows 7 desktop -- Pinning Excel 2016 to your Windows 7 Start menu -- Pinning Excel 2016 to the Windows 7 taskbar -- Exiting Excel -- Help Is on the Way -- Using the Tell Me help feature -- Getting online help -- 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 formats -- 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 -- Customizing table formats -- Creating a new custom Table Style -- 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 with Smart Lookup -- 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-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 -- 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 -- Inserting 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 Office Add-ins -- 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 saved on OneDrive -- E-mailing workbooks -- Sharing workbooks with IM -- Presenting worksheets online -- Editing worksheets online -- The Part of Tens -- Top Ten Beginner Basics -- The Ten Commandments of Excel 2016 -- Top ten Ways to Manage Your Data -- Top Ten Ways to

Analyze Your Data

Available to OhioLINK libraries