
Microsoft 365 Excel For Dummies
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
Make Excel work for you with this brand new guide to spreadsheet essentials
Knowing a little about Excel is essential for almost every profession. Knowing a lot about Excel makes you one of the most valuable people in the office. Microsoft 365 Excel For Dummies helps you build your spreadsheet skills as it walks you through the basics of creating a spreadsheet, organizing data, performing calculations, and creating charts and graphs in Microsoft's powerful spreadsheet software. This brand new version of the book, written by an Excel guru and expert trainer, helps you develop the skills you need to impress your boss-or just to get things done faster. You'll also get ideas for using Excel to make daily life easier. Ready to become a number cruncher?
- Create your first spreadsheet and learn how to enter data
- Import data from other sources, sort tables, and organize information
- Run basic calculations and get more advanced with functions
- Build data visualizations, customize the look of your spreadsheets, and beyond
These days, almost everyone who works with computers needs to have basic knowledge of Excel-and more is usually better. Microsoft 365 Excel For Dummies will help you get there.
More details
Other editions
Additional editions

Person
David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. He offers training on Excel and other accounting software to thousands of students and explains the concepts, techniques, and strategies they need to work effectively in Excel. David is also author of QuickBooks Online For Dummies.
Content
Introduction 1
Part 1: Explaining Excel Fundamentals 7
Chapter 1: Getting Started with Spreadsheets 9
Chapter 2: Carrying Out Basic Calculations 37
Chapter 3: Formatting Cells and Worksheets 61
Chapter 4: Sifting Through Data. 93
Chapter 5: Tackling Tables 115
Part 2: Mastering Formulas and Functions 135
Chapter 6: Leveraging Lookup Formulas 137
Chapter 7: Transforming Text and Numbers 163
Chapter 8: Harnessing Logic Functions 191
Chapter 9: Carving Data with Dynamic Arrays 219
Chapter 10: Tracing and Debugging Formulas 239
Part 3: Expanding Beyond the Basics. 259
Chapter 11: Navigating Through Worksheets and Workbooks 261
Chapter 12: Visualizing and Summarizing Data. 281
Chapter 13: Contemplating Conditional Formatting 311
Chapter 14: User-Proofing Excel Spreadsheets 339
Part 4: Automating Analysis 365
Chapter 15: Accessing Artificial Intelligence 367
Chapter 16: Recording Macros 379
Part 5: The Part of Tens 407
Chapter 17: Ten Timesaving Keyboard Shortcuts 409
Chapter 18: Ten Disaster Recovery Techniques 417
Index 431
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.