Microsoft Excel 365 Bible

Michael Alexander (McKinney, TX), Dick Kusleika (Daily Dose, LLC)

$90.95

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

John Wiley & Sons Inc
14 May 2025

Business applications

Series: Bible

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 contents Building formulas with Excel table objects, correcting common formula errors and using formula variables Working with data series, changing basic chart elements and making use of chart customization Loading data from other sources, performing common transformations and applying conditional logic

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

By: Michael Alexander (McKinney TX), Dick Kusleika (Daily Dose, LLC)
Imprint: John Wiley & Sons Inc
Country of Publication: United States
Edition: 2nd edition
Dimensions: Height: 234mm, Width: 185mm, Spine: 58mm
Weight: 1.474kg
ISBN: 9781394298242
ISBN 10: 1394298242
Series: Bible
Pages: 1088
Publication Date: 14 May 2025
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

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

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.

LATEST SALES & OFFERS: PROMOTIONS

Microsoft Excel 365 Bible

Michael Alexander (McKinney, TX), Dick Kusleika (Daily Dose, LLC)

$90.95

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S