Learn Excel for Mac - by Guy Hart-Davis (Paperback)

Book Synopsis

Microsoft Excel 365 for macOS is a powerful and widely used Office app, but many of its most useful features can be hard to master. Learn Excel macOS: Mastering Excel Essentials provides a practical, hands-on approach to learning the key features of Excel so that you can get work done quickly and accurately on macOS. From using the Excel Ribbon and menus to crunching data with formulas and functions, from opening workbooks automatically to illustrating worksheets with graphical objects, you'll grasp everything you need to know to harness this vital app's capabilities to the full in your workplace.

What You'll Learn

- Navigate the Excel for Mac user interface smoothly and confidently.
- Configure Excel to suit your work and your work style.
- Save time and effort by developing templates for workbooks you frequently create.
- Highlight out-of-band values in worksheets and validate data input.
- Perform calculations by using formulas and functions.
- Brighten up your worksheets with graphics and illustrations.

Who is This Book For

This book provides easy-to-follow instructions for beginning and intermediate users wanting to develop expertise in using Excel for Mac productively in the workplace, for their studies, or for home businesses.

From the Back Cover

Learn Excel for Mac: Mastering Excel Essentials, gives you a firm grounding in using Excel for Mac. First, you meet the Excel interface and learn how to manipulate it; then you configure Excel's key options to work in the way you prefer. Next, you grasp how to create workbooks and worksheets to contain your data and how to create templates for the different types of workbooks you use regularly. From here, you move on to learn how to format worksheets quickly and efficiently, how to perform custom calculations using formulas, and how to put Excel's hundreds of built-in functions to work for you. Finally, you learn how to illustrate your worksheets using pictures, SmartArt, and other graphical objects.

What You'll Learn

- Navigate the Excel for Mac user interface smoothly and confidently.
- Configure Excel to suit your work and your work style.
- Save time and effort by developing templates for workbooks you frequently create.
- Highlight out-of-band values in worksheets and validate data input.
- Perform calculations by using formulas and functions.
- Brighten up your worksheets with graphics and illustrations.

About the Author

Guy Hart-Davis is the author of more than 200 computer books, including several books from Apress--among them Deploying iPads in the Classroom, Deploying Raspberry Pi in the Classroom, and Deploying Chromebooks in the Classroom.