Excel 2021 Intermediate-Excel 2021 Intermediate

Excel 2021 Intermediate - Course Outline

Pdf Summary

This course outline for <strong>Microsoft Excel 2021 Intermediate</strong> covers skills for creating professional spreadsheets, analyzing data, and collaborating effectively. Learners start with <strong>charts</strong>, including creating standard and recommended charts, moving/resizing and deleting charts, changing chart types, switching row/column data, and applying layouts, styles, and color schemes. It also includes editing titles, axis titles, legends, gridlines, data labels, and data tables; formatting chart elements and series; modifying chart data (adding, renaming, and reordering series); filtering charts; adding and editing trendlines; building dual-axis charts; saving and using chart templates; and inserting sparklines.

The <strong>Print and Distribute</strong> section focuses on preparing workbooks for printing by adjusting page size, scaling, print areas, and page breaks, plus adding print titles, gridlines, headings, headers/footers, margins, and orientation. It also teaches inspecting workbooks for potential issues, including accessibility and compatibility checks.

In <strong>Intermediate Formulas</strong>, learners work with references to other worksheets and workbooks, understand relative vs. absolute references and order of operations, and create and manage named ranges. The outline includes inserting functions and using key functions such as <strong>CONCAT</strong>, <strong>PMT</strong>, <strong>TODAY</strong>, and <strong>NOW</strong>, along with displaying and auditing formulas.

<strong>Manage Data</strong> topics include Quick Analysis, creating outlines and subtotals, data validation with input/error messages, Flash Fill, and importing/exporting data.

The <strong>Tables</strong> module covers creating tables, applying styles, converting tables to ranges, sorting and filtering (including multi-column sorts), adding/removing rows and columns, removing duplicates, using slicers, and applying structured references and table naming.

<strong>Formatting</strong> focuses on conditional formatting (including advanced rules), applying/removing cell styles, creating/modifying custom styles, finding/replacing formatting, and applying themes.

Finally, <strong>Collaboration</strong> includes comments, sharing and co-authoring workbooks, version history recovery, and protecting worksheets/workbooks with locking, hiding formulas, structure protection, and password protection.

Keywords

Microsoft Excel 2021 Intermediate

Excel chart creation

Chart formatting and templates

Sparklines

Print setup and workbook distribution

Intermediate Excel formulas

Named ranges and cell references

Data validation and Flash Fill

Excel tables sorting filtering slicers

Collaboration co-authoring and workbook protection