I'm a student
I'm an educator
Request full copy

Microsoft Excel Inside Out (Office 2021 and Microsoft 365), 1st edition

Published by Microsoft Press (December 16, 2021) © 2022

  • Bill Jelen

eTextbook

$52.99

  • Available for purchase from all major ebook resellers, including InformIT.com.
  • To request a review copy, click on the "Request a Review Copy" button.
$43.99

  • A print text (hardcover or paperback) 
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

Renowned Excel expert Bill Jelen offers a complete tour of Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards.Topics include:

  • Customizing the Excel workspace
  • Best practices for designing and managing worksheets
  • Creating formulas and functions
  • Performing statistical, what-if, and other data analysis
  • Core to advanced charting techniques
  • Using graphics and sparklines
  • Managing databases and tables
  • Automating Excel with macros and custom functions
  • Collaborating in Excel online, in the cloud, and more
  • Extending Excel
  • Timesaving solutions
  • Troubleshooting tips
  • Workarounds
Will be updated for all the new features and functions; updates for Power Query and Power BI with Excel. Covers all Microsoft 365 features.

Part I   The Excel interface

Chapter 1        What's new in Microsoft 365 Excel

Chapter 2        Using the Excel interface

Chapter 3        Customizing Excel

Chapter 4        Keyboard shortcuts

 

Part II  Calculating with Excel

Chapter 5        Understanding formulas

Chapter 6        Controlling formulas

Chapter 7        Understanding functions

Chapter 8        Using everyday functions: math, date and time, and text functions

Chapter 9        Using powerful functions: logical, lookup, and database functions

Chapter 10      Using names, LET, LAMBDA, and Data Types in Excel

Chapter 11      Connecting worksheets and workbooks

Chapter 12      Dynamic array formulas and names in Excel


Part III Data analysis with Excel

Chapter 13      Transforming data with Power Query

Chapter 14      Summarizing data using subtotals or filter

Chapter 15      Using pivot tables to analyze data

Chapter 16      Using slicers and filtering a pivot table

Chapter 17      Mashing up data with Power Pivot

Chapter 18      Using What-If, Scenario Manager, Goal Seek, and Solver

Chapter 19      Automating repetitive functions using VBA macros

Chapter 20      More tips and tricks for Excel

 

Part IV Excel visuals

Chapter 21      Formatting worksheets

Chapter 22      Using data visualizations and conditional formatting

Chapter 23      Graphing data using Excel charts

Chapter 24      Using 3D Maps

Chapter 25      Using sparklines

Chapter 26      Formatting spreadsheets for presentation

Chapter 27      Printing

Chapter 28      Collaborating in Excel

 

Part V  Appendixes

Appendix A     Excel functions

Appendix B      Excel functions with DAX or Power Query equivalents

Appendix C      Adding functionality to Excel with add-ins

Index

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars