- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full Description
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.
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
