Excel Mac Intermediate-Excel Mac Intermediate

Excel Mac Intermediate - Course Outline

Pdf Summary

This course outline for <strong>Microsoft Excel 2016 for Mac (Intermediate)</strong> focuses on building practical skills to work faster, analyze data more effectively, and present results professionally.

Learners begin with <strong>charts</strong>, covering how to create standard and recommended charts, move and resize them, and choose appropriate chart types (including switching row/column data). The course also teaches improving chart appearance using layouts, styles, and colors; adding and formatting titles, legends, gridlines, labels, and data tables; modifying chart data series; filtering charts; adding and editing trendlines; creating dual-axis charts; saving and using chart templates; and inserting sparklines.

Next, the course addresses <strong>printing and distribution</strong>, including changing page size and scaling, setting print areas, managing page breaks, printing titles/gridlines/headings, using headers and footers, and adjusting margins and page orientation.

The <strong>intermediate formulas</strong> section covers referencing other worksheets and workbooks, understanding relative vs. absolute references, and applying the correct order of operations. It also introduces creating and managing named cells/ranges, inserting functions, and using specific functions such as <strong>CONCATENATE</strong>, <strong>PMT</strong>, <strong>TODAY()</strong>, and <strong>NOW()</strong>. Learners also practice displaying and auditing formulas by showing/hiding and highlighting them.

In <strong>data management</strong>, topics include outlining and subtotals, data validation with input/error messages, Flash Fill, and importing/exporting data.

The <strong>tables</strong> module teaches creating tables, applying styles, converting tables to ranges, sorting and filtering (single and multi-column), adding/removing rows and columns, removing duplicates, using slicers, and writing structured references.

<strong>Intermediate formatting</strong> includes conditional formatting (including advanced rules), applying/removing cell styles, creating/modifying styles, and applying themes.

Finally, <strong>collaboration and protection</strong> covers comments, sharing workbooks, tracking and reviewing changes (including saving history), protecting worksheets and workbook structure, hiding formulas, and adding password protection.

Keywords

Microsoft Excel 2016 for Mac

Intermediate Excel course

Excel charts and sparklines

Chart formatting and templates

Printing and page setup

Intermediate Excel formulas

Named ranges and structured references

Data validation and Flash Fill

Excel tables sorting filtering slicers

Workbook collaboration and protection