Excel Mac Basic-Excel Mac Basic

Excel Mac Basic - Course Outline

Pdf Summary

This course, <strong>Microsoft Excel 2016 Mac Basic</strong>, introduces foundational Excel skills for Mac users to help them create, edit, format, and manage professional-looking spreadsheets. It begins with <strong>Getting Started</strong>, covering the Excel interface, creating workbooks (blank or from templates), navigating worksheets and cells (including Go To and keyboard shortcuts), opening and saving files in different formats, and using AutoRecover. Learners also practice customizing the <strong>Quick Access Toolbar</strong>, printing with preview and print options, sharing workbooks for collaboration or as attachments, accessing Help, and properly closing files and exiting Excel.

The <strong>Edit a Workbook</strong> section focuses on selecting cells and ranges (including rows, columns, and entire worksheets), entering and modifying cell data, and using essential editing tools such as cut, copy, paste, drag-and-drop moves, and undo/redo/repeat. It also introduces advanced paste options like transposing data and pasting values or formats, inserting, moving, and deleting cells/rows/columns, checking spelling, using Find and Replace, hiding and unhiding rows/columns, and viewing/editing document properties.

In <strong>Basic Formulas</strong>, learners build core calculation skills: creating and editing formulas, understanding automatic recalculation, using the Formulas tab, applying AutoFill for copying and generating series, and working with common functions including SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA.

<strong>Basic Formatting</strong> teaches how to format text (fonts, size, color, partial-cell formatting), align and merge cells, wrap text, apply number/date formats (including custom formats), add borders and shading, copy formatting, and adjust row heights and column widths.

The course also covers <strong>inserting objects</strong> (images, shapes, hyperlinks, and accessibility-related alt text) and <strong>viewing/managing worksheets</strong>, including worksheet views, zoom, custom views, working with multiple windows, moving/copying sheets, inserting/renaming/deleting sheets, tab color changes, freezing panes, and hiding worksheets or gridlines.

Keywords

Microsoft Excel 2016 for Mac

Excel interface navigation

workbook creation templates

Quick Access Toolbar customization

file saving formats AutoRecover

printing preview options

cell range selection editing

cut copy paste transpose

Find and Replace spelling check

basic formulas functions SUM AVERAGE