Excel
eBook - ePub

Excel

The Comprehensive Guide

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

Excel

The Comprehensive Guide

About this book

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!

In this book, you'll learn about:

a. 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.

b. 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.

c. 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:

1) Mastering basic features
2) Creating spreadsheets
3) Working with formulas
4) Evaluating what-if analyses
5) Designing charts and diagrams
6) Visualizing data with sparklines
7) Organizing data in tables
8) Exporting, importing, and exchanging data
9) Automating tasks with macros
10) Using Visual Basic for Applications (VBA)

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Excel by Helmut Vonhoegen in PDF and/or ePUB format, as well as other popular books in Computer Science & Desktop Applications. We have over one million books available in our catalogue for you to explore.

Information

Table of contents

  1. Notes on Usage
  2.   Preface
  3. 1   Basic Knowledge for Working with Excel
  4. 2   The Structure of Spreadsheets
  5. 3   Working with Formulas
  6. 4   Designing Worksheets
  7. 5   Analysis and Forecasting
  8. 6   Optimization
  9. 7   Presenting Data Graphically
  10. 8   Using Charts Effectively
  11. 9   Data Visualization with Sparklines
  12. 10   Refining Worksheets with Graphics
  13. 11   Preparing Documents for Publishing
  14. 12   Publishing Workbooks
  15. 13   Excel Data on the Web
  16. 14   Collaborating on Workbooks
  17. 15   Table Functions
  18. 16   Organizing and Managing Information as Tables
  19. 17   Data Queries and Data Extracts
  20. 18   PivotTables and Charts
  21. 19   Working with External Data
  22. 20   Export and Import of Files
  23. 21   Exchanging Data with Other Applications
  24. 22   Automating Routine Tasks with Macros
  25. 23   Visual Basic for Applications
  26. 24   Preview
  27. A   Function Keys, Keys, and Keyboard Shortcuts
  28. B   The Author
  29. Index
  30. Service Pages
  31. Legal Notes