Excel 2021 Intermediate-Excel 2021 Intermediate

Excel 2021 Intermediate - Student Guide

Pdf Summary

This Excel 2021 Intermediate guide (CustomGuide) provides practical instruction for creating professional workbooks through improved charting, printing, formulas, data management, tables, formatting, collaboration, and protection.<br /><br />The Charts module explains how to select appropriate chart types (e.g., column, line, pie, scatter), create standard or Recommended Charts, and then move, resize, or place charts on separate chart sheets. It covers changing chart types, switching row/column data, applying layouts, styles, and color schemes, and editing key elements such as titles, axis labels, legends, gridlines, data labels, and data tables. Users learn to emphasize series with formatting, modify chart data (add/rename/reorder series), filter chart displays, add and edit trendlines, build dual-axis (combo) charts with secondary axes, save chart templates for reuse, and insert sparklines for in-cell mini visualizations.<br /><br />Print and Distribute focuses on configuring output: page size, scaling to fit pages, setting/clearing print areas, adjusting page breaks, repeating title rows/columns, printing gridlines and headings, creating headers/footers (page numbers, file info, images), and setting margins and orientation. It also introduces workbook inspection tools for removing hidden data, checking accessibility, and verifying compatibility with older Excel versions.<br /><br />Intermediate Formulas covers external references to other sheets/workbooks, relative vs. absolute references (including F4 shortcuts), order of operations, named ranges with Name Manager, inserting functions via the Insert Function dialog, and using CONCAT, PMT, and common date/time functions (TODAY, NOW, DATE, YEAR, etc.), plus displaying or highlighting formulas.<br /><br />Manage Data introduces Quick Analysis, outlining and subtotals, data validation with input/error messages, Flash Fill, and importing/exporting (CSV/text).<br /><br />Tables and Formatting teach creating tables, sorting/filtering, adding/removing rows/columns, table styles/options, removing duplicates, slicers, structured references, conditional formatting rule management, cell styles, find/replace formatting, and applying/customizing themes.<br /><br />Collaboration and Security covers comments, sharing/co-authoring via OneDrive/SharePoint, version history and recovery settings, worksheet/workbook protection (locking/unlocking cells, hiding formulas), and password protection.

Keywords

Excel 2021 intermediate

chart types

chart formatting

combo chart secondary axis

trendlines

printing and page setup

named ranges Name Manager

data validation

Excel tables and slicers

workbook protection and collaboration