Excel 2021 Basic-Excel 2021 Basic

Excel 2021 Basic - Course Outline

Pdf Summary

This course outline for <strong>Microsoft Excel 2021 Basic</strong> introduces foundational skills for creating, editing, formatting, and managing Excel workbooks and worksheets. It begins with <strong>Excel Fundamentals</strong>, covering how to understand the Excel interface, create workbooks from scratch or templates, navigate within worksheets efficiently (including the Go To dialog and keyboard shortcuts), and manage files by opening different formats, saving with AutoSave and Save As options, and recovering work using AutoRecover. Learners also customize the <strong>Quick Access Toolbar</strong>, use built-in help tools (Tell Me and Help Pane), print worksheets with preview and printing options, and properly close workbooks and exit Excel.

The <strong>Edit a Workbook</strong> section focuses on selecting cells and ranges (including non-adjacent selections and entire sheets), entering and modifying cell data, and using essential editing tools such as cut, copy, paste, drag-and-drop moving, and undo/redo/repeat. It also introduces advanced paste options like transposing data, pasting values only, and pasting formats. Additional skills include inserting and deleting cells, rows, and columns; checking spelling; finding and replacing text; hiding and unhiding rows/columns; and viewing or editing workbook document properties (including author and advanced properties).

In <strong>Basic Formulas</strong>, students learn formula fundamentals (creating, editing, and recalculation behavior), AutoFill for copying data and generating series, and common calculations such as SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA.

The <strong>Basic Formatting</strong> module teaches text formatting, alignment tools (wrap, indent, merge/split cells), number and date formats (including custom formats), borders, shading, copying formatting, and adjusting row heights and column widths.

Finally, learners <strong>insert objects</strong> (images, shapes, hyperlinks, and alt text) and <strong>manage worksheets</strong> using views, zoom and custom views, multiple window arrangements, moving/copying sheets, inserting/renaming/deleting sheets, freezing panes, and hiding worksheets or gridlines.

Keywords

Microsoft Excel 2021 Basic

Excel fundamentals

workbooks and worksheets

Excel interface navigation

Go To dialog and keyboard shortcuts

AutoSave AutoRecover Save As

Quick Access Toolbar customization

cell editing cut copy paste

basic formulas SUM AVERAGE MIN MAX COUNT

formatting cells number date borders alignment