Excel 2021 Basic-Excel 2021 Basic - Document

Excel 2021 Basic - Document - Student Guide

Pdf Summary

This document is a CustomGuide “Excel 2021 Basic” training manual that introduces core Microsoft Excel skills for new users. It begins with Excel fundamentals, explaining the workbook/worksheet structure and key screen elements such as the Ribbon, Quick Access Toolbar, Name Box, Formula Bar, Status Bar, and the “Tell Me” search field. It then covers creating workbooks from scratch or from templates, navigating large worksheets by selecting cells, jumping to specific addresses with the Name Box or Go To dialog box, and using common navigation shortcuts.<br /><br />File management topics include opening existing workbooks (including non-Excel formats like CSV and text files), saving files to locations such as OneDrive, SharePoint, or a local PC, using Save As and different export formats (XLSX, XLS, CSV, PDF, HTML, templates), and understanding AutoSave and AutoRecover for crash recovery and version protection. The guide also explains printing workflows, print preview, and configurable print settings.<br /><br />Next, it focuses on editing data efficiently: selecting cells, rows, columns, ranges (including non-adjacent selections), entering/replacing/deleting/editing cell contents, using cut/copy/paste and drag-and-drop, and applying undo/redo/repeat. It introduces Paste Special options such as transpose, values-only, and formatting-only. Additional productivity tools include inserting/moving/deleting cells, rows, and columns; spell check; find and replace with advanced search options; hiding/unhiding rows and columns; and viewing/editing document properties like author and keywords.<br /><br />The manual also introduces basic formulas and functions (operators, SUM, AVERAGE, MIN, MAX, COUNT/COUNTA/COUNTBLANK), Auto Fill for copying or creating series, and automatic recalculation. Formatting lessons cover fonts, alignment, wrapping, merging, number/date formats (including custom formats), borders, fills, Format Painter, and adjusting row/column sizes (including AutoFit). Finally, it covers inserting objects (images, shapes, hyperlinks) with properties and accessibility alt text, plus worksheet viewing/management (views, zoom, custom views, multiple windows, moving/copying/renaming/deleting sheets, freeze panes, and hiding sheets/gridlines/headings).

Keywords

Excel 2021 basics

workbook and worksheet structure

Ribbon and Quick Access Toolbar

Name Box and Go To navigation

opening and saving workbooks

OneDrive and SharePoint storage

AutoSave and AutoRecover

printing and print settings

cell editing and Paste Special

formulas and functions (SUM AVERAGE MIN MAX COUNT)