Bill Jelen - Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

(Office 2021 and Microsoft 365)

Bill Jelen
MrExcel

Pearson is dedicated to creating bias-free content that reflects the diversity of all learners. We embrace the many dimensions of diversity, including but not limited to race, ethnicity, gender, socioeconomic status, ability, age, sexual orientation, and religious or political beliefs.

Education is a powerful force for equity and change in our world. It has the potential to deliver opportunities that improve lives and enable economic mobility. As we work with authors to create content for every product and service, we acknowledge our responsibility to demonstrate inclusivity and incorporate diverse scholarship so that everyone can achieve their potential through learning. As the worlds leading learning company, we have a duty to help drive change and live up to our purpose to help more people create a better life for themselves and to create a better world.

Our ambition is to purposefully contribute to a world where:

• Everyone has an equitable and lifelong opportunity to succeed through learning.

• Our educational products and services are inclusive and represent the rich diversity of learners.

• Our educational content accurately reflects the histories and experiences of the learners we serve.

• Our educational content prompts deeper discussions with learners and motivates them to expand their own learning (and worldview).

While we work hard to present unbiased content, we want to hear from you about any concerns or needs with this Pearson product so that we can investigate and address them.

• Please contact us with concerns about any potential bias at https://www.pearson.com/report-bias.html.

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. He has produced more than 2,400 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 64 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenchesworking as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. When he is not geeking out about Excel, you will find him kayaking Sykes Creek or photographing rocket launches from Cape Canaveral. Check out his photography at WeReportSpace.com. He lives in Merritt Island, Florida, with his wife, Mary Ellen.

Inside OUT

You can find my favorite tricks in the Inside Out sidebars throughout this book.

If you have a favorite Excel trick or technique that is not in this book, consider sending it via email to InsideTips@MrExcel.com. Anyone sending in a tip that is new to me will win bragging rights and a collectible Excel Guru patch, designed by the same people who design the NASA mission patches.

Microsoft 365 Excel is now the dominant way to purchase Excel. Microsoft did a good job of offering more value to Microsoft 365. They are reluctantly releasing a perpetual edition of Excel 2021, but they say that it is only for specific scenarios where people do not have access to the Internet.

Those people without the Internet will be paying quite a premium for an obsolete version of Excel without any of the connected features. The price for the perpetual version of Office increased by 10% to $440 per device for Office 2021. In contrast, you can license Microsoft 365 for five devices for $99 per year.

The Excel team has been responsive to items requested through the Excel.UserVoice.com website, and many small features and improvements have happened since the last edition of this book.

• You can now unhide multiple worksheets at once.

• The Conditional Formatting Rules Manager dialog box is now resizable.