Learning Microsoft Excel 2016 for Mac

Create a new Excel 2016 for Mac workbook from a blank template, then save it locally or to cloud using save, save as, or command-s.

Open and close workbooks in Excel 2016 for Mac via the open dialog and file menu, with prompts to save changes and quick access to recently used and pinned files.

Save and open Excel 2016 files in online locations by using OneDrive or iCloud, sign in to access OneDrive, create folders, and compare benefits across devices.

Learn how to save a Mac Excel workbook in multiple formats, including xlsx, xls (97–2004), csv text, and pdf, to share with older versions and aid distribution.

Add new sheets, rename them, delete, move, and copy worksheets within a workbook, then color the sheet tabs for organization.

Explore Excel 2016 templates from the welcome screen or file new from template, using templates like credit card payoff calculator and online sales tracker to learn saving and editing templates.

Learn how to start a blank workbook, save it, and enter text, numbers, and dates in Excel, noting default alignment and how to preserve leading zeros or avoid date misreads.

Edit existing cells in Excel 2016 for Mac using double-click, F2, or the formula bar to modify content and manage truncation with wrap text and column width.

Learn how to undo and redo actions in excel for mac, using keyboard shortcuts and menu options to reverse edits, cancel entry with escape, and repeat the last action.

Master cutting, copying, and pasting in Excel for Mac by manipulating cells and ranges, using keyboard shortcuts and icons, and moving content across sheets and workbooks.

Learn to use drag and drop in Excel for Mac to move or copy cell contents across sheets, using edge dragging, Alt/Option copy, and command-key sheet transfers.

Discover how to use the Excel fill handle to automatically copy text, numbers, and dates, create patterns for days, months, and weekdays, and fill horizontally or vertically.

Insert and delete rows and columns in Excel for Mac, move data along as you add space, and manage the last column constraint using the home ribbon or right-click.

Adjust column widths and row heights in Excel 2016 for Mac by dragging, auto fit, or entering exact measurements; balance sheets or revert to default widths for presentation.

Learn to hide and unhide rows, columns, and sheets in Excel 2016 for Mac by selecting ranges, using right-click or the format menu, and restoring hidden data safely.

Learn to search across an Excel workbook for Mac using the search box, switch between current sheet and workbook, and use advanced options like match case and whole cell contents.

Learn to build basic mathematical formulas in Excel using addition, subtraction, multiplication, division, and exponent, starting with an equals sign and cell references.

Show how bodmas governs excel formulas, emphasizing that the power operation, then multiplication and division, then addition and subtraction determine results, and how brackets override the order.

Master basic formulas in Excel by using the sum function on a range of cells, whether row or column, and learn how count, max, min, and average reveal data insights.

Master the new formula builder to insert functions such as sum, count, max, and min. Use the quick sigma method to fill ranges and create totals across rows and columns.

Learn how to copy and paste formulas in Excel for Mac, and how relative references adjust as you drag, fill, or double-click to apply across rows and columns.

Learn how to display formulas on a worksheet, toggle show formulas on and off, and use the formula text function to view both formulas and results for easier troubleshooting.

Learn how to select single, multiple, and noncontiguous cells in Excel for Mac, and use the Home ribbon to format bold, size, color, and borders with keyboard and mouse shortcuts.

Master modifying typeface, font size, and colors in Excel for Mac, including fonts, bold/italic/underline, fill and pattern colors, borders, and superscript and subscript.

Learn to adjust horizontal and vertical alignment, change text orientation, wrap or shrink text, and merge cells to create headings in Excel 2016 for Mac.

Learn how to format numbers in Excel for Mac, including money with accounting vs currency, comma style for thousand separators, percentages, decimals, and how to format negatives in red.

Learn to add and remove borders in Excel for Mac 2016 using border commands to apply, customize color and style, erase, and reset borders, including no borders.

Learn how Excel for Mac 2016 stores dates as serial numbers and formats them with short, long, or custom date formats, including two-digit year century rules and current-year inference.

Learn to use the format painter and fill formatting to copy cell formats—colors, fonts, borders, and currency formats—across rows and columns, with double-click, escape, and fill formatting only options.

Learn how to print in Excel for Mac by managing the active area, print preview, orientation, margins, and scaling to fit while previewing before printing.

Define a print area to print only selected data, set and clear it, and use print titles to repeat header rows across pages for clean landscape printing.

Control how your worksheet prints in Excel 2016 for Mac by inserting, removing, and dragging page breaks, then use landscape and fit to page to adjust.

Add headers and footers to an Excel Mac worksheet for print, using built-in or custom headers with left, center, and right sections to include date, page numbers, and file details.

Learn to create headers and footers in Excel 2016 for Mac using the page layout view, editing left, center, and right sections with file name, page numbers, and date.

Explore print options in Excel for Mac, including grid lines, row and column headings, borders, and page order from page setup, master spell checking with change, ignore, and dictionary additions.

Explore print setup options in Excel 2016 for Mac, scale to fit, and create a pdf from a worksheet, preview before saving or emailing as an attachment.

Master the sum function in Excel for Mac, learning to add single or multiple ranges, including nonconsecutive ones, and using AutoSum for quick, accurate totals.

Master the average, max, and min functions in Excel 2016 for Mac. Apply them to fruit sales data, calculating averages and extremes.

Learn four Excel count functions: count, counta, countblank, and countif, using a range and criteria to count numbers, nonempty cells, empty cells, and negatives.

Explore the average functions in Excel for Mac, including mean, mode, and median. Learn to count numeric entries, compute totals, and identify the data range middle value.

Explore how to use the PI function in Excel to compute circle measurements, including circumference and area from diameter, and apply these to cylinder volume calculations.

Explore absolute referencing in Excel for Mac by learning how to lock rows and columns with dollar signs, ensuring formulas copy correctly for VAT, totals, and pricing calculations.

Create and use formulas that pull the previous year's totals from other sheets, perform cross-sheet linking, and summarize annual sales across multiple years.

Master 3-d referencing in Excel 2016 for Mac by summing the same cell across multiple sheets to calculate monthly and multi-year totals.

Discover how naming ranges, such as apples and oranges, enables cross-sheet sums and easy replication using formulas, indirect, and 3D referencing across worksheets.

Learn date and time formulas in Excel for Mac, including today and now functions and custom date formats. Combine shapes with dynamic text using cell formulas and ampersand concatenation.

Discover how to use the if statement in Excel 2016 for Mac to perform conditional logic, assess a value against a threshold, and return custom results or handle divide-by-zero errors.

Learn to add, edit, delete, and print cell comments in Excel for Mac 2016, including showing, hiding, resizing, moving comments, and choosing print options.

Create your own custom lists in Excel for Mac to speed data entry with auto fill, including months, days of the week, regions, and fruits, plus importing lists from cells.

Convert data to a table using format as table to quickly apply table styles, a header row, a total row, and filter drop-downs.

Learn how to activate and deactivate protection for worksheets and workbooks in Excel 2016 for Mac, including password options, locking cells, and protecting structure.

Learn to guard formula cells while enabling data entry by unlocking specific cells and applying sheet protection, so users can edit only unlocked areas on a Mac.

Protect the workbook by setting a password to open or to modify, and choose read-only as an extra safety net.

Master Excel 2016 for Mac basics—create and save workbooks, format and print, use templates and iCloud or OneDrive storage, and apply formulas, functions, absolute references, and data tools.