Organize, analyze, and visualize data with Excel!

Excel The Comprehensive Guide

written by
$49.99

Available

$54.95

Available

$64.99

Available

Print edition E-book Bundle
910 pages, , Print edition paperback
ISBN 978-1-4932-2780-8
910 pages,
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2781-5
910 pages, , Print edition paperback
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2782-2
If you’re using Excel, this is the all-in-one manual you need—brimming with solutions for every conceivable task! Learn how to design tables, use formulas to perform calculations, create analyses, graphically present your data, and share your results. With detailed coverage of both basic functions and advanced features, this book provides guidance for beginners and serves as a reliable reference if you’re already familiar with Excel. Up to date for Excel 2024 and Microsoft 365!
  • Your A-to-Z guide to Microsoft Excel
  • Master basic features, data analysis, visualizations, and more
  • Work with formulas, table functions, and VBA
About the E-book About the Book E-book in full color. PDF (49 MB) and EPUB (36 MB) files for download, DRM-free with personalized digital watermark. Copy and paste, bookmarks, and print-out permitted. Table of contents, in-text references, and index fully linked. Including online book edition in dedicated reader application. 910 pages, paperback, 1.75 in. Including downloadable code examples. Reference book format 7 x 10 in. Printed black and white on 50# offset paper from sustainable sources. Reader-friendly serif font (TheAntiquaB 9.5 Pt.). One-column layout.

In this book, you’ll learn about:

  1. Excel Fundamentals

    Follow a workflow that guides you through Excel’s user interface, introduces basic concepts, and demonstrates the core features for working with tables, diagrams, and files.

  2. All Your Excel Tasks

    Dive into everything Excel has to offer. Master spreadsheet functions, formula usage, and table design. Get step-by-step instructions for analyzing, visualizing, and publishing your data; then see how to automate and customize your tasks with macros and VBA.

  3. Practical Examples

    See Excel’s features in action. Detailed examples and annotated screenshots guide you through each and every spreadsheet function, table design and analysis, data model management, and more.

Highlights include:

  • Mastering basic features
  • Creating spreadsheets
  • Working with formulas
  • Evaluating what-if analyses
  • Designing charts and diagrams
  • Visualizing data with sparklines
  • Organizing data in tables
  • Exporting, importing, and exchanging data
  • Automating tasks with macros
  • Using Visual Basic for Applications (VBA)

Helmut Vonhoegen is a freelance author and IT consultant. He has published more than 80 books since 1992 and written numerous articles in specialist journals.

more >

Product supplements

Here you can find downloadable supplements for the product.

Supplements list >

You may also like:

  • Cover of SAP Fiori Apps for SAP S/4HANA

    SAP Fiori Apps for SAP S/4HANA
    The Quick Reference Guide

    Anand Seetharaju, Jon Simmonds, Tinotenda F. Chiraudi

    681 pages, paperback

    Are you working with SAP Fiori? Then you need an encyclopedia of applications at your fingertips! Look up more than 1,700 apps and find need-to-know information: What does the app do? How does it enhance your workflow? Does it replace More about the book

    from $64.99

    Available

    E-book | Print edition | Bundle
  • Cover of Inventory Management with SAP S/4HANA

    Inventory Management with SAP S/4HANA

    Bernd Roedel, Johannes Esser

    477 pages, hardcover

    Are you ready to manage inventory in SAP S/4HANA? Get the instructions you need in this comprehensive guide. Start by configuring inventory-specific and cross-functional settings to suit your business needs. Then use SAP Fiori apps to plan and adjust your More about the book

    from $84.99

    Available

    E-book | Print edition | Bundle
  • Cover of ABAP Cookbook

    ABAP Cookbook
    Practical Recipes for Modern Programming

    Fabian Lupa, Sven Treutler

    444 pages, hardcover

    Ready to get cooking with ABAP? Discover shortcuts and solutions for all of your regular ABAP tasks in this practical guide. Walk step by step through important programming techniques and tools, from table management to extension implementation, following "recipes" for More about the book

    from $84.99

    Available

    E-book | Print edition | Bundle