Microsoft Excel 365 Bible - Paperback

by Michael Alexander (Author), Dick Kusleika (Author)

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.

Back Jacket

Your up-to-date guide to Excel 365

Microsoft Excel 365 is the dominant spreadsheet tool for people and businesses around the world. And now, with the second edition of Microsoft^(R) Excel^(R) 365 Bible, you can find all the easy-to-follow info you need in one convenient book. You'll learn to make and navigate spreadsheets, write formulas, use custom functions, visualize your data, and create reports. It's perfect for beginners and power-users.

• Get started with Excel 365 and see what's new in the latest version
• Format your worksheets for readability and a professional appearance
• Learn how to create worksheets and workbooks, import data, and more
• Create your own formulas and functions to help crunch your numbers
• Learn Power Pivot and Power Query
• Use charts and graphs to visualize your data
• Become a data analysis wiz, with What-If analyses, Solver, and other essential tools
• Automate your work and incorporate AI using Microsoft Copilot
• Use Office Scripts in Excel to automate Excel online

Author Biography

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.