false
OasisLMS
Login
Catalog
Excel 2021 Intermediate
Excel 2021 Intermediate - Quick Reference Guide
Excel 2021 Intermediate - Quick Reference Guide
Back to course
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
×
Please select your language
1
English