-10% student

Microsoft Excel 365 Bible

AvMichael Alexander,Dick Kusleika

Häftad, Engelska, 2025

Del i serien Bible

473 kr

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

Beskrivning

Your complete guide to Excel 365, written for newbies all the way to seasoned professionals Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel—from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions. Written by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including: Entering and editing worksheet data, with information on data types, formulas, dates, times and other cell contentsBuilding formulas with Excel table objects, correcting common formula errors and using formula variablesWorking with data series, changing basic chart elements and making use of chart customizationLoading data from other sources, performing common transformations and applying conditional logicMicrosoft Excel 365 Bible earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.

Produktinformation

Utgivningsdatum:2025-04-17
Mått:188 x 234 x 58 mm
Vikt:1 520 g
Format:Häftad
Språk:Engelska
Serie:Bible
Antal sidor:1 088
Upplaga:2
Förlag:John Wiley & Sons Inc
ISBN:9781394298242

Ingår i kampanjer

-10% student

Utforska kategorier

Databaser inom Data och IT
Affärsapplikationer inom Data och IT

Mer om författaren

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community. Dick Kusleika has been working with Microsoft Office for more than 20 years. He was formerly a Microsoft MVP, having been awarded 12 consecutive years. Dick has written several books about Excel and Access.

Innehållsförteckning

Introduction xliPart I: Getting Started with Excel 1Chapter 1: Introducing Excel 3Chapter 2: Entering and Editing Worksheet Data 29Chapter 3: Performing Basic Worksheet Operations 55Chapter 4: Working with Excel Ranges and Tables 75Chapter 5: Formatting Worksheets 125Chapter 6: Understanding Excel Files and Templates 161Chapter 7: Printing Your Work 181Chapter 8: Customizing the Excel User Interface 203Part II: Working with Formulas and Functions 213Chapter 9: Introducing Formulas and Functions 215Chapter 10: Understanding and Using Array Formulas 251Chapter 11: Using Common Formulas for Math and Dates 273Chapter 12: Using Formulas to Manipulate Text 311Chapter 13: Using Formulas for Conditional Analysis 331Chapter 14: Using Formulas for Matching and Lookups 347Chapter 15: Using Formulas with Conditional Formatting 365Chapter 16: Making Your Formulas Error-Free 379Part III: Creating Charts and Other Visualizations 399Chapter 17: Getting Started with Excel Charts 401Chapter 18: Using Advanced Charting Techniques 439Chapter 19: Creating Sparkline Graphics 473Chapter 20: Visualizing with Custom Number Formats and Shapes 487Part IV: Managing and Analyzing Data 519Chapter 21: Importing and Cleaning Data 521Chapter 22: Using Data Validation 553Chapter 23: Creating and Using Worksheet Outlines 567Chapter 24: Linking and Consolidating Worksheets 577Chapter 25: Introducing Pivot Tables 597Chapter 26: Analyzing Data with Pivot Tables 619Chapter 27: Performing Spreadsheet What-If Analysis 653Chapter 28: Analyzing Data Using Goal Seeking and Solver 675Chapter 29: Analyzing Data with the Analysis ToolPak 695Chapter 30: Protecting Your Work 707Part V: Understanding Power Pivot and Power Query 721Chapter 31: Introducing Power Pivot 723Chapter 32: Working Directly with the Internal Data Model 747Chapter 33: Adding Formulas to Power Pivot 757Chapter 34: Introducing Power Query 787Chapter 35: Transforming Data with Power Query 813Chapter 36: Making Queries Work Together 845Chapter 37: Enhancing Power Query Productivity 861Part VI: Automating Excel 873Chapter 38: Introducing Visual Basic for Applications 875Chapter 39: Creating Custom Worksheet Functions 903Chapter 40: Creating UserForms 917Chapter 41: Using UserForm Controls in a Worksheet 939Chapter 42: Working with Excel Events 953Chapter 43: Creating Custom Excel Add-Ins 967Chapter 44: Office Scripts for Excel 977Index 1009