Excel 2021 Intermediate-Excel 2021 Intermediate

Excel 2021 Intermediate - Quick Reference Guide

Pdf Summary

This quick reference guide for <strong>Microsoft Excel 2021 (Intermediate)</strong> summarizes key skills across charting, printing, formulas, data management, tables, formatting, and collaboration.

It explains how to <strong>create and modify charts</strong>: select a data range, insert a chart from the Insert tab, then move/resize it by dragging borders or sizing handles. Users can <strong>change chart types</strong>, <strong>filter chart data</strong>, position legends, and show/hide chart elements via the Chart Elements button. It also covers adding <strong>trendlines</strong>, inserting <strong>sparklines</strong>, and creating <strong>dual-axis (combo) charts</strong>. Common chart types are described (column, line, pie, bar, area, scatter, stock, surface), along with optional elements like data labels, data tables, error bars, and trendlines.

For <strong>printing and distribution</strong>, the guide outlines setting page size, defining a print area, printing titles/gridlines/headings, adding headers and footers, and adjusting margins and page orientation.

In <strong>intermediate formulas</strong>, it highlights <strong>absolute references</strong> (using dollar signs), naming cells/ranges for use in formulas, referencing other worksheets/workbooks, and the <strong>order of operations</strong> (PEMDAS). It introduces functions including <strong>CONCAT</strong> for joining text, <strong>PMT</strong> for loan payments, and date functions like <strong>DATE</strong>, <strong>TODAY</strong>, and <strong>NOW</strong>. It also shows how to toggle <strong>Show Formulas</strong>.

Under <strong>data management</strong>, it covers importing/exporting data, using <strong>Quick Analysis</strong>, creating <strong>subtotals/outlines</strong>, using <strong>Flash Fill</strong>, and setting <strong>data validation</strong> rules.

For <strong>tables</strong>, it explains formatting ranges as tables, sorting/filtering, inserting rows/columns, removing duplicates, adding <strong>slicers</strong>, and configuring table style options.

Finally, it includes <strong>formatting and collaboration</strong> tasks: conditional formatting, cell styles, workbook themes, adding comments, sharing/co-authoring, protecting worksheets, and adding workbook passwords.

Keywords

Microsoft Excel 2021

intermediate Excel skills

chart creation and modification

combo dual-axis charts

trendlines and sparklines

printing setup and page layout

absolute cell references

Excel functions CONCAT PMT DATE TODAY NOW

data validation and Flash Fill

Excel tables sorting filtering slicers