Microsoft 365 Excel All-in-One For Dummies

Häftad, Engelska, 2025

335 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

Beskrivning

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 storyApply basic programming skills using VBAThis 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.

Produktinformation

Utgivningsdatum:2025-08-28
Mått:224 x 50 x 187 mm
Vikt:1 465 g
Format:Häftad
Språk:Engelska
Serie:For Dummies
Antal sidor:816
Förlag:John Wiley & Sons Inc
ISBN:9781394344635

Utforska kategorier

Människa – datorinteraktion inom Data och IT
Affärsapplikationer inom Data och IT

Mer om författaren

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

Innehållsförteckning

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