LEADER 05261nam 2200649 a 450 001 9910465609703321 005 20200520144314.0 010 $a1-118-64232-5 010 $a1-118-65106-5 035 $a(CKB)2560000000103525 035 $a(EBL)1210960 035 $a(SSID)ssj0000970333 035 $a(PQKBManifestationID)11598732 035 $a(PQKBTitleCode)TC0000970333 035 $a(PQKBWorkID)11019404 035 $a(PQKB)11080210 035 $a(OCoLC)850420725 035 $a(MiAaPQ)EBC1210960 035 $a(WaSeSS)IndRDA00019241 035 $a(CaSebORM)9781118642320 035 $a(Au-PeEL)EBL1210960 035 $a(CaPaEBR)ebr10718828 035 $a(CaONFJC)MIL576283 035 $a(EXLCZ)992560000000103525 100 $a20150303d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$a101 excel 2013 tips, tricks & timesavers$b[electronic resource] /$fby John Walkenbach 205 $a1st edition 210 $aHoboken, N.J. $cWiley$dc2013 215 $a1 online resource (314 p.) 225 0 $aMr. Spreadsheet's bookshelf 300 $aIncludes index. 311 $a1-118-64218-X 327 $aAbout the Author; Table of Contents; INTRODUCTION; What You Should Know; What You Should Have; Conventions in This Book; Formula listings; Key names; The Ribbon; Functions, procedures, and named ranges; Mouse conventions; What the icons mean; How This Book Is Organized; How to Use This Book; About the Power Utility Pak Offer; Part I: Workbooks and Files; Tips and Where to Find Them; Tip 1: Changing the Look of Excel; Cosmetic changes; Hiding the Ribbon; Using options on the View tab; Hiding other elements; Hiding the status bar; Tip 2: Customizing the Quick Access Toolbar 327 $aAbout the Quick Access toolbarAdding new commands to the Quick Access toolbar; Performing other Quick Access toolbar actions; Tip 3: Customizing the Ribbon; How to customize the Ribbon; Tip 4: Understanding Protected View; What causes Protected View?; Printing and copying; Forcing a file to open in Normal view; Tip 5: Understanding AutoRecover; Recovering versions of the current workbook; Recovering unsaved work; Tip 6: Using a Workbook in a Browser; Tip 7: Saving to a Read-Only Format; Send a printed copy; Send an electronic copy in the form of a PDF file; Send an MHTML file 327 $aTip 8: Generating a List of FilenamesTip 9: Generating a List of Sheet Names; Tip 10: Using Document Themes; Applying a theme; Customizing a theme; Tip 11: Understanding Excel Compatibility Issues; The Excel 2013 file formats; The Office Compatibility Pack; Checking compatibility; Tip 12: Where to Change Printer Settings; Part II: Formatting; Tips and Where to Find Them; Tip 13: Working with Merged Cells; Other merge actions; Potential problems with merged cells; Locating all merged cells; Unmerging all merged cells; Alternatives to merged cells; Tip 14: Indenting Cell Contents 327 $aTip 15: Using Named StylesUsing the Style gallery; Modifying an existing style; Creating new styles; Merging styles from other workbooks; Tip 16: Creating Custom Number Formats; Parts of a number format string; Custom number format codes; Tip 17: Using Custom Number Formats to Scale Values; Tip 18: Creating a Bulleted List; Using a bullet character; Using SmartArt; Tip 19: Shading Alternate Rows Using Conditional Formatting; Displaying alternate row shading; Creating checkerboard shading; Shading groups of rows; Tip 20: Formatting Individual Characters in a Cell 327 $aTip 21: Using the Format PainterPainting basics; Format Painter variations; Tip 22: Inserting a Watermark; Tip 23: Showing Text and a Value in a Cell; Using concatenation; Using the TEXT function; Using a custom number format; Tip 24: Avoiding Font Substitution for Small Point Sizes; Tip 25: Updating Old Fonts; Part III: Formulas; Tips and Where to Find Them; Tip 26: Resizing the Formula Bar; Tip 27: Monitoring Formula Cells from Any Location; About the Watch Window; Customizing the Watch Window; Navigating with the Watch Window; Tip 28: Learning Some AutoSum Tricks 327 $aTip 29: Knowing When to Use Absolute and Mixed References 330 $aGet the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka ""Mr. Spreadsheet,"" shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming ""impossible"" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and 410 0$aMr. Spreadsheet's bookshelf. 606 $aElectronic spreadsheets 608 $aElectronic books. 615 0$aElectronic spreadsheets. 676 $a005.54 700 $aWalkenbach$b John$061459 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910465609703321 996 $a101 excel 2013 tips, tricks & timesavers$91994601 997 $aUNINA