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.
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. Start quickly with the most recent versions of Word, Excel, PowerPoint, Outlook, OneNote and OneDrive —combining the familiarity of Office and the unique Mac features you love. Work online or offline, on your own or with others in real time—whatever works for what you’re doing.
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.
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.
To use the new controls, here’s what you do:
Books For Excel Macros Formulas Functions
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.
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.
Books On Excel For Mac
To ungroup, go to the same Group & Outline group on the Data tab and choose Ungroup→Ungroup or Clear Outline.