Microsoft 365 Excel All-in-One For Dummies
Home > Computing and Information Technology > Business applications > Spreadsheet software > Microsoft 365 Excel All-in-One For Dummies
Microsoft 365 Excel All-in-One For Dummies

Microsoft 365 Excel All-in-One For Dummies


     0     
5
4
3
2
1



International Edition


X
About the Book

Get into the nitty gritty of Excel, the all-important spreadsheet tool Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automate your spreadsheets. You'll also get a glimpse into how AI tools can boost your work. Eight mini-books come together in this expanded Excel reference. With Microsoft 365 Excel All-in-One For Dummies, you'll soon be the go-to Excel guru in your office or school. Learn the basics of Excel—organizing data, performing calculations, and formatting your spreadsheet. Use functions to handle advanced math and financial analysis. Create data visualizations and summaries to help tell your story Apply basic programming skills using VBA This book is perfect for professionals or students who need to up their Excel game with insight from pros who know the classic spreadsheet app inside and out.

Table of Contents:
Introduction 1 Book 1: Getting Started with Excel 5 Chapter 1: Getting Started with Spreadsheets 7 Chapter 2: Carrying Out Basic Calculations 31 Chapter 3: Formatting Cells and Worksheets 53 Chapter 4: Organizing Data and Creating Tables 79 Chapter 5: Navigating Worksheets and Workbooks 113 Book 2: Working with Formulas and Functions 129 Chapter 1: Tapping Into Formula and Function Fundamentals 131 Chapter 2: Saving Time with Function Tools 161 Chapter 3: Building Array Formulas and Functions 177 Chapter 4: Fixing Errors in Formulas 191 Book 3: Going Farther with Functions 207 Chapter 1: Calculating Loans, Interest, and Depreciation 209 Chapter 2: Performing Functional Math. 241 Chapter 3: Working with Date and Time Functions 271 Chapter 4: Manipulating Text with Functions 291 Book 4: Analyzing Data 317 Chapter 1: Using Basic Data Analysis Techniques 319 Chapter 2: Working with Data Analysis Tools 343 Chapter 3: Analyzing Table Data with Functions 365 Book 5: Summarizing, Visualizing, and Illustrating Data 377 Chapter 1: Creating Charts 379 Chapter 2: Creating and Using PivotTables 391 Chapter 3: Performing PivotTable Calculations 413 Chapter 4: Building PivotCharts 435 Book 6: Reporting and Querying Data 455 Chapter 1: Introducing Power Pivot 457 Chapter 2: Advanced Moves with PivotTables 469 Chapter 3: Working Directly with the Internal Data Model 499 Chapter 4: Adding Formulas to Power Pivot 513 Chapter 5: Meeting Power Query and Its Connection Types 531 Book 7: Creating Dashboards and Reports 559 Chapter 1: Getting in the Dashboard State of Mind 561 Chapter 2: Building a Super Model 575 Chapter 3: Dressing Up Your Data Tables 619 Chapter 4: Formatting Your Way to Visualizations 635 Chapter 5: Displaying Performance against a Target 663 Book 8: Automating Excel with Macros and VBA 679 Chapter 1: Macro Fundamentals 681 Chapter 2: Getting Cozy with the Visual Basic Editor 701 Chapter 3: The Anatomy of Macros 715 Chapter 4: Working with Workbooks 729 Index 753

About the Author :
This book collects bestselling Excel content from the For Dummies series, including selections from Microsoft 365 Excel For Dummies (David H. Ringstrom), Microsoft Excel Dashboards & Reports (Michael Alexander), Microsoft 365 Excel Formulas & Functions For Dummies (Ken Bluttman), Microsoft Excel Power Pivot & Power Query For Dummies (Michael Alexander), Microsoft Excel Data Analysis For Dummies (Paul McFedries), Excel Macros For Dummies (Dick Kusleika).


Best Sellers


Product Details
  • ISBN-13: 9781394344635
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: For Dummies
  • Height: 234 mm
  • No of Pages: 816
  • Returnable: Y
  • Spine Width: 51 mm
  • Width: 185 mm
  • ISBN-10: 1394344635
  • Publisher Date: 28 Aug 2025
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Returnable: Y
  • Weight: 1066 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft 365 Excel All-in-One For Dummies
John Wiley & Sons Inc -
Microsoft 365 Excel All-in-One For Dummies
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Microsoft 365 Excel All-in-One For Dummies

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!