• Excel 2013 All-in-one For Dummies See large image

    Excel 2013 All-in-one For Dummies (For Dummies) (Paperback) By (author) Greg Harvey

    $28.58 - Save $11.77 29% off - RRP $40.35 Free delivery worldwide Available
    Dispatched in 3 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

    DescriptionThe 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 Excel and VBA. Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse Details new ways to explore your data more intuitively and then analyze and display your results with a single click Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.


Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10

 

Reviews | Bibliographic data
  • Full bibliographic data for Excel 2013 All-in-one For Dummies

    Title
    Excel 2013 All-in-one For Dummies
    Authors and contributors
    By (author) Greg Harvey
    Physical properties
    Format: Paperback
    Number of pages: 792
    Width: 188 mm
    Height: 236 mm
    Thickness: 44 mm
    Weight: 1,134 g
    Language
    English
    ISBN
    ISBN 13: 9781118510100
    ISBN 10: 1118510100
    Classifications

    BIC E4L: COM
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 05
    B&T Modifier: Subject Development: 06
    Nielsen BookScan Product Class 3: S10.4
    B&T Modifier: Continuations: 02
    B&T Modifier: Text Format: 01
    LC subject heading:
    B&T Merchandise Category: COM
    DC22: 005.54
    LC subject heading:
    B&T Approval Code: A93905800
    Warengruppen-Systematik des deutschen Buchhandels: 26350
    BISAC V2.8: COM054000
    Ingram Subject Code: XW
    Libri: I-XW
    BIC subject category V2: UFCE
    LC subject heading:
    B&T General Subject: 230
    B&T Approval Code: A48401631
    LC subject heading:
    DC23: 005.54
    LC classification: HF5548.4.M523 H36685 2013
    Thema V1.0: UFC
    Illustrations note
    ill
    Publisher
    John Wiley & Sons Inc
    Imprint name
    John Wiley & Sons Inc
    Publication date
    08 March 2013
    Publication City/Country
    New York
    Author Information
    Greg Harvey , PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies , Excel All-in-One For Dummies , and Excel Workbook For Dummies .
    Back cover copy
    8 books in 1Excel BasicsWorksheet DesignFormulas and FunctionsWorksheet Collaboration and ReviewCharts and GraphicsData ManagementData AnalysisMacros and VBAExcel newbie or expert in older versions -- here's the reference you need for Excel 2013!Understanding how to use the many features of Excel 2013 is only half the battle. The other half is understanding what these features can do for you. So whether you're starting out or upgrading, using Excel on your desktop or tablet, this all-in-one guide covers what you need to know to master worksheets, formulas, functions, charts, even data analysis.For beginners -- start out right with an entire minibook devoted to mastering Excel basicsWorking with worksheets -- learn to set up, edit, manage, and dress up worksheets and print reportsGet functional -- explore formulas and functions from basic to complex and put them to work Team effort -- share and collaborate on worksheets while keeping your data secure Make it look great -- present your data with impressive charts and graphs that help interpret the informationManage your data -- take advantage of Excel's tools for managing large amounts of data and filtering out the information you needLook ahead -- use Excel's computational abilities to forecast and predict possible future outcomesExtend Excel -- install Apps for Office, use COM add-ins, and write macros and custom functions with the Visual Basic Editor"Open the book and find: How to build your own workbook templatesInstructions for using Excel on a touchscreenAll the ways to enter dataTips for preventing formula errorsHints for sharing data with other Office 2013 programsGraphics you can include in your chartsHow to query external data sourcesA guide to PowerPivot and Power View add-ins
    Table of contents
    Introduction 1 About This Book 1 Foolish Assumptions 2 How This Book Is Organized 3 Book I: Excel Basics 3 Book II: Worksheet Design 3 Book III: Formulas and Functions 4 Book IV: Worksheet Collaboration and Review 5 Book V: Charts and Graphics 5 Book VI: Data Management 6 Book VII: Data Analysis 6 Book VIII: Macros and VBA 6 Conventions Used in This Book 7 Icons Used in This Book 8 Where to Go from Here 9 Book I: Excel Basics 11 Chapter 1: The Excel 2013 User Experience 13 Chapter 2: Customizing Excel 2013 41 Book II: Worksheet Design 73 Chapter 1: Building Worksheets 75 Chapter 2: Formatting Worksheets 125 Chapter 3: Editing and Proofing Worksheets 183 Chapter 4: Managing Worksheets 231 Chapter 5: Printing Worksheets 269 Book III: Formulas and Functions 297 Chapter 1: Building Basic Formulas 299 Chapter 2: Logical Functions and Error Trapping 339 Chapter 3: Date and Time Formulas 361 Chapter 4: Financial Formulas 375 Chapter 5: Math and Statistical Formulas 389 Chapter 6: Lookup, Information, and Text Formulas 409 Book IV: Worksheet Collaboration and Review 431 Chapter 1: Protecting Workbooks and Worksheet Data 433 Chapter 2: Using Hyperlinks 455 Chapter 3: Sending Workbooks Out for Review 463 Chapter 4: Sharing Workbooks and Worksheet Data 489 Book V: Charts and Graphics 513 Chapter 1: Charting Worksheet Data 515 Chapter 2: Adding Graphic Objects 545 Book VI: Data Management 575 Chapter 1: Building and Maintaining Data Lists 577 Chapter 2: Filtering and Querying a Data List 601 Book VII: Data Analysis 643 Chapter 1: Performing What-If Scenarios 645 Chapter 2: Generating Pivot Tables 667 Book VIII: Macros and VBA 707 Chapter 1: Building and Running Macros 709 Chapter 2: VBA Programming 721 Index 745