LEADER 05533nam 2200673 a 450 001 9910779582003321 005 20200520144314.0 010 $a1-118-55018-8 035 $a(CKB)2550000001006036 035 $a(EBL)1124990 035 $a(OCoLC)828298686 035 $a(SSID)ssj0000886036 035 $a(PQKBManifestationID)11536575 035 $a(PQKBTitleCode)TC0000886036 035 $a(PQKBWorkID)10815651 035 $a(PQKB)10720014 035 $a(JP-MeL)3000030582 035 $a(Au-PeEL)EBL1124990 035 $a(CaPaEBR)ebr10660560 035 $a(CaONFJC)MIL450845 035 $a(CaSebORM)9781118550212 035 $a(MiAaPQ)EBC1124990 035 $a(EXLCZ)992550000001006036 100 $a20121226d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel 2013 all-in-one for dummies$b[electronic resource] /$fby Greg Harvey 205 $a1st edition 210 $aHoboken, N.J. $cJ. Wiley & Sons, Inc.$d2013 215 $a1 online resource (795 p.) 225 0$a--For dummies 300 $a"8 books in 1: Excel basics, Worksheet design, Formulas and functions, Worksheet collaboration and review, Charts and graphics, Data management, Data analysis, Macros and VBA"--Cover. 300 $aIncludes index. 311 $a1-118-55021-8 311 $a1-118-51010-0 327 $aExcel® 2013 All-in-One For Dummies®; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Conventions Used in This Book; Icons Used in This Book; Where to Go from Here; Book I: Excel Basics; Contents at a Glance; Contents at a Glance; Chapter 1: The Excel 2013 User Experience; Excel 2013's New Look and Feel; Excel's Start Screen; Excel's Ribbon User Interface; Getting Help; Launching and Quitting Excel; Chapter 2: Customizing Excel 2013; Tailoring the Quick Access Toolbar to Your Tastes; Exercising Your Options; Using Office Apps; Add-In Mania 327 $aBook II: Worksheet DesignContents at a Glance; Chapter 1: Building Worksheets; Designer Spreadsheets; It Takes All Kinds (Of Cell Entries); Data Entry 101; Saving the Data; Document Recovery to the Rescue; Chapter 2: Formatting Worksheets; Making Cell Selections; Adjusting Columns and 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; Hiring Out the Format Painter; Using Cell Styles; Conditional Formatting 327 $aChapter 3: Editing and Proofing WorksheetsOpening a Workbook; Cell Editing 101; A Spreadsheet with a View; Copying and Moving Stuff Around; Find and Replace This Disgrace!; Spell Checking Heaven; Looking Up and Translating Stuff; Marking Invalid Data; Eliminating Errors with Text to Speech; Chapter 4: Managing Worksheets; Reorganizing the Worksheet; Reorganizing the Workbook; Working with Multiple Workbooks; Consolidating Worksheets; Chapter 5: Printing Worksheets; Printing from the Excel 2013 Backstage View; Quick Printing the Worksheet; Working with the Page Setup Options 327 $aHeaders and FootersSolving Page Break Problems; Printing the Formulas in a Report; Book III: Formulas and Functions; Contents at a Glance; Chapter 1: Building Basic Formulas; Formulas 101; Copying Formulas; Adding Array Formulas; Range Names in 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; Removing Errors from the Printout; Chapter 3: Date and Time Formulas 327 $aUnderstanding Dates and TimesUsing Date Functions; Using Time Functions; Chapter 4: Financial Formulas; Financial Functions 101; The PV, NPV, and FV Functions; The PMT Function; Depreciation Functions; Analysis ToolPak Financial Functions; Chapter 5: Math and Statistical Formulas; Math & Trig Functions; Statistical Functions; Chapter 6: Lookup, Information, and Text Formulas; Lookup and Reference; Information, Please . . .; Much Ado about Text; Book IV: Worksheet Collaboration and Review; Contents at a Glance; Chapter 1: Protecting Workbooks and Worksheet Data; Password-Protecting the File 327 $aProtecting the Spreadsheet 330 $a The comprehensive reference, now completely up-to-date for Excel 2013! As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and 517 1 $aMicrosoft Excel 2013 all-in-one for dummies 606 $aElectronic spreadsheets 606 $aBusiness$xComputer programs 615 0$aElectronic spreadsheets. 615 0$aBusiness$xComputer programs. 676 $a005.54 700 $aHarvey$b Greg$021041 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910779582003321 996 $aExcel 2013 all-in-one for dummies$93795324 997 $aUNINA