Excel 2016 All-In-One for Dummies.

Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- How This Book Is Organized -- Book I: Excel Basics -- Book II: Worksheet Design -- Book III: Formulas and Functions -- Book IV: Worksheet Collaboration and Review -- Book V: Charts and Graphics -- Book VI: Data Management -- Book VII: Data Analysis -- Book VIII: Macros and VBA -- Conventions Used in This Book -- Icons Used in This Book -- Where to Go from Here -- Book I Excel Basics -- Chapter 1 The Excel 2016 User Experience -- Excel 2016's Sleek Look and Feel -- Excel's Start Screen -- Excel's Ribbon User Interface -- Going behind the scenes to Excel's Backstage view -- Ripping through the Ribbon -- Adjusting to the Quick Access toolbar -- Fooling around with the Formula bar -- What's up with the Worksheet area? -- Taking a tour of the status bar -- Getting Help -- Show‐and‐tell help with the Tell Me feature -- Using the Excel online help -- Launching and Quitting Excel -- Starting Excel from the Windows 10 Start menu -- Starting Excel from the Windows 10 Ask Me Anything text box -- Telling Cortana to Start Excel 2016 for you -- Starting Excel from the Windows 8 Start screen -- Starting Excel from the Windows 7 Start menu -- When it's quitting time -- Chapter 2 Customizing Excel 2016 -- Tailoring the Quick Access Toolbar to Your Tastes -- Adding Ribbon commands to the Quick Access toolbar -- Adding non-Ribbon commands to the Quick Access toolbar -- Adding macros to the Quick Access toolbar -- Exercising Your Options -- Changing some of the more universal settings on the General tab -- Changing common calculation options on the Formulas tab -- Changing correction options on the Proofing tab -- Changing various save options on the Save tab -- Changing the Office 2016 language preferences.

Changing a whole lot of other common options on the Advanced tab -- Customizing the Excel 2016 Ribbon -- Using Office Add-ins -- Using Excel's Own Add-Ins -- Managing the standard Excel add-ins -- Managing Excel COM add-ins -- Purchasing third-party add-ins -- Book II Worksheet Design -- Chapter 1 Building Worksheets -- Designer Spreadsheets -- Take it from a template -- Designing a workbook from scratch -- It Takes All Kinds (Of Cell Entries) -- What's in a label? -- What's the value? -- Data Entry 101 -- Data entry keyboard style -- Doing data entry with the Touch keyboard -- You AutoComplete this for me -- You AutoCorrect this right now! -- Constraining data entry to a cell range -- Getting Excel to put in the decimal point -- You AutoFill it in -- Saving the Data -- Saving workbooks in other commonly used file formats -- Changing the default file location -- Saving a new workbook in the old file format -- Document Recovery to the Rescue -- Chapter 2 Formatting Worksheets -- Making Cell Selections -- Selecting cells with the mouse -- Selecting cells by touch -- Selecting cells with the keyboard -- You AutoSelect that range! -- Selecting cells with Go To -- Name that range! -- Adjusting Columns and Rows -- You AutoFit the column to its contents -- Adjusting columns the old fashioned way -- Setting a new standard width -- Hiding out a column or two -- Rambling rows -- Formatting Tables from the Ribbon -- Formatting Tables with the Quick Analysis Tool -- Formatting Cells from the Ribbon -- Formatting Cell Ranges with the Mini-Toolbar -- Using the Format Cells Dialog Box -- Assigning number formats -- Altering the alignment -- Fancy fonts and colors -- Basic borders, fills, and patterns -- Hiring Out the Format Painter -- Using Cell Styles -- Using the Number Format cell styles -- Defining a custom cell style by example.

Creating a new cell style from scratch -- Merging styles into other workbooks -- Conditional Formatting -- Graphical conditional formatting -- Formatting with the Quick Analysis tool -- Identifying particular values or text entries in a cell range -- Highlighting duplicate values in a cell range -- Creating your own conditional formatting rules -- Managing conditional formatting rules -- Chapter 3 Editing and Proofing Worksheets -- Opening a Workbook -- Using the Open screen in the Backstage view -- Using the Open dialog box -- Opening more than one workbook at a time -- Finding misplaced workbooks -- Using the other Open options -- Cell Editing 101 -- Undo and Redo -- Get that out of here! -- Can I just squeeze this in here? -- A Spreadsheet with a View -- "Zoom, zoom, zoom" -- Freezing window panes -- Saving custom views -- Copying and Moving Stuff Around -- Doing it with drag-and-drop -- Carried away with cut-and-paste -- Find and Replace This Disgrace! -- Finding stuff -- Finding and replacing stuff -- Spell Checking Heaven -- Changing the spelling options -- Adding words to the custom dictionary -- Looking Up and Translating Stuff -- Marking Invalid Data -- Eliminating Errors with Text to Speech -- Chapter 4 Managing Worksheets -- Reorganizing the Worksheet -- Inserting and deleting columns and rows -- Eradicating columns and rows -- Adding new columns and rows -- Splitting the worksheet into panes -- Outlining worksheets -- Reorganizing the Workbook -- Renaming sheets -- Designer sheets -- Adding and deleting sheets -- Changing the sheets -- Group editing -- "Now you see them -- now you don't" -- Opening windows on different sheets -- Working with Multiple Workbooks -- Comparing windows on different workbooks -- Transferring data between open windows -- Transferring sheets from one workbook to another -- Consolidating Worksheets.

Consolidating by position -- Consolidating by category -- Linking consolidated data -- Chapter 5 Printing Worksheets -- Printing from the Excel 2016 Backstage View -- Selecting the printer to use -- Previewing the printout -- Checking the paging in Page Layout view -- Previewing the pages of the report -- Quick Printing the Worksheet -- Working with the Page Setup Options -- 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 -- Headers and Footers -- Adding a ready-made header or footer -- Creating a custom header or footer -- Solving Page Break Problems -- Printing the Formulas in a Report -- Book III Formulas and Functions -- Chapter 1 Building Basic Formulas -- Formulas 101 -- Formula building methods -- Editing formulas -- When you AutoSum numbers in a spreadsheet -- Totals and sums with the Quick Analysis tool -- Building formulas with operators -- Using the Insert Function button -- Copying Formulas -- Absolute references -- A mixed bag of references -- Adding Array Formulas -- Building an array formula -- Editing an array formula -- Range Names in Formulas -- Defining range names -- Naming constants and formulas -- Using names in building formulas -- Creating names from column and row headings -- Managing range names -- Applying names to existing formulas -- Adding Linking Formulas -- Controlling Formula Recalculation -- Circular References -- Chapter 2 Logical Functions and Error Trapping -- Understanding Error Values -- Using Logical Functions -- Error-Trapping Formulas -- Whiting-Out Errors with Conditional Formatting -- Formula Auditing -- Tracing precedents -- Tracing dependents -- Error checking -- Changing the Error Checking options -- Error tracing -- Evaluating a formula -- Removing Errors from the Printout -- Chapter 3 Date and Time Formulas.

Understanding Dates and Times -- Changing the Regional date settings -- Building formulas that calculate elapsed dates -- Building formulas that calculate elapsed times -- Using Date Functions -- TODAY -- DATE and DATEVALUE -- DAY, WEEKDAY, MONTH, and YEAR -- DAYS360 -- Other special Date functions -- Using Time Functions -- NOW -- TIME and TIMEVALUE -- HOUR, MINUTE, and SECOND -- Chapter 4 Financial Formulas -- Financial Functions 101 -- The PV, NPV, and FV Functions -- Calculating the Present Value -- Calculating the Net Present Value -- Calculating the Future Value -- The PMT Function -- Depreciation Functions -- Analysis ToolPak Financial Functions -- Chapter 5 Math and Statistical Formulas -- Math &amp -- Trig Functions -- Rounding off numbers -- POWER and SQRT -- The SUM of the parts -- Conditional summing -- Statistical Functions -- AVERAGE, MAX, and MIN -- Counting cells -- Using specialized statistical functions -- Chapter 6 Lookup, Information, and Text Formulas -- Lookup and Reference -- Looking up a single value with VLOOKUP and HLOOKUP -- Performing a two‐way lookup -- Reference functions -- Information, Please . . . -- Getting specific information about a cell -- Are you my type? -- Using the IS functions -- Much Ado about Text -- Using text functions -- Concatenating text -- Book IV Worksheet Collaboration and Review -- Chapter 1 Protecting Workbooks and Worksheet Data -- Password-Protecting the File -- Protecting the workbook when saving the file -- Assigning a password to open from the Info screen -- Entering the password to gain access -- Entering the password to make changes -- Changing or deleting a password -- Protecting the Worksheet -- Changing a cell's Locked and Hidden Protection formatting -- Protecting the worksheet -- Enabling cell range editing by certain users.

Doing data entry in the unlocked cells of a protected worksheet.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.