AutoSave is a different feature which automatically saves your file as you work - just like if you save the file manually - so that you don't have to worry about saving on the go. On the Mac, AutoSave is available in Excel, Word, and PowerPoint for Microsoft 365 for Mac subscribers. When AutoSave is turned on AutoRecover files are rarely needed. Excel 2019 for Apple Mac Book and e-Book Tutorials. You can now find details of all Excel 2019 for Apple Mac books and e-books here. Excel Tutorials. Free Basic Skills tutorials Printed books and e-books Wholesale printed books Retired products. Charts Formatting Formulas Get & Transform (Power Query) Pivot Tables Power Pivot. The book will equip you with excellent Excel 2019 for Mac skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Excel 2019 for Mac Expert Skills book. About the Book Author Geetesh Bajaj is a Microsoft PowerPoint MVP. His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com. James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.
I'm using an older Mac version of Excel. Is there a free Basic Skills book for earlier versions?
Books On Excel For Mac
No. We only publish this Apple Mac title for the current Excel 2016 for Mac version.
We do publish books (including the free Basic Skills book) for the older Windows versions (Excel 2007, 2010 and 2013) along with comprehensive video courses for the same titles.
Which version of Excel was used to record these videos?
Unlike Windows versions there is no schedule for the release of Excel versions for the Mac.
We update the Excel for Windows versions in January and July each year (when the Excel for Windows semi-annual update is published). At the same time we update the Mac courses to the latest version available at that time.
Book Excel For Mac
You will learn more about update channels in this book (Lesson 1‑3: Check that your Excel version is up to date).
The free Basic Skills Excel for Apple Mac tutorial will get you started with Excel fundamentals. Even though it is a basic skills course you’ll still master many skills that professional Excel users are unable to use. Available entirely free as an e-book.
Click here and the e-book will open straight away. Read the first two pages and you’ll immediately realize why millions of learners have found this free course so useful.
Also available for Excel 2007, Excel 2010, Excel 2013 and Excel 2016 for Windows.
Teaching a class? Order printed copies of this book at our not-for-profit printing cost price.
In Office 2011 for Mac, use Excel’s Group tool to identify ranges of rows in worksheets that you can then turn on and off. Activate the rows by using switches in a new margin that’s displayed when Group is active. Group is particularly useful when you have large tables with Total Rows turned on because it lets you hide data rows to reduce visual clutter on a busy worksheet.
To group an Excel worksheet that has multiple data tables that all begin flush left (or at least in the first few columns), do the following:
- Select the rows that contain the tables with Total Rows turned on.Tables need at least one empty row between them as separators. Contracted rows may not be included in Total Row calculations.
- On the Ribbon’s Data tab, go to the Group & Outline group and choose Group→Auto Outline.Excel turns on the group controls in a new margin.
Best Books For Excel Macros
To use the new controls, here’s what you do:
- Click the 1 button at the top of the new margin to contract all groups. A plus sign displays next to the Total Row of each contracted group.
- Click the + and – signs in the margin to expand or contract individual tables.
- Click the 2 button at the top of the new margin to expand all groups.
Books For Excel Macros Formulas Functions
You can select a range of adjacent rows within a single table and on the Ribbon’s Data tab; go to the Group & Outline group and choose Group→Group to group just the selected rows.
To ungroup, go to the same Group & Outline group on the Data tab and choose Ungroup→Ungroup or Clear Outline.