false
OasisLMS
Login
Catalog
Excel 2021 Basic
Excel 2021 Basic - Course Outline
Excel 2021 Basic - Course Outline
Back to course
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
×
Please select your language
1
English