Appendix A

A Crash Course in Excel

In this appendix, I review the basic Microsoft Excel skills that you may need to get the most benefit from some chapters in this book. If you plan to download and work with the sample workbooks from my website, https://stephenlnelson.com, you need some of the skills that this primer covers.

If you’ve used Excel much, even for just a few weeks, you probably possess all these skills. Nevertheless, if you’re even a teensy bit concerned about whether you have the right skills, take the time to read this appendix.

Note: I used Microsoft Excel for Microsoft 365 MSO and Windows 10 Pro when writing this appendix. If you’re using an earlier or later version of Excel, you may notice some slight differences between the images that appear here and what you see on your monitor. If you need detailed guidance, pick up the latest edition of Excel For Dummies, by Greg Harvey (John Wiley & Sons, Inc.).

If you do not own a licensed copy of Microsoft Excel, you can use Google Sheets or Excel for the Web. Each program is free with a Google or Microsoft website registration, and each offers the basic functionality of Microsoft Excel with some minor differences.

Starting Excel

You can start Excel in two ways, neither of which requires a PhD in physics. You can click the Start button and then click the Excel tile that appears on the Start menu’s list of programs, or you can open an Excel workbook.

If you’re going to use the Excel tile, you simply find the Excel tile ...

Get QuickBooks 2024 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.