Excel 365: Enter & Edit Data

Course description

Entering data effectively is one of the most essential skills in Microsoft Excel 365, as every worksheet and analysis begins with accurate and properly formatted information. This course introduces learners to the fundamentals of data entry, covering Excel’s primary data types, cell and range addressing, selection techniques, and common commands. Learners will begin by exploring the four core data types—numbers, text, boolean/logical values, and errors—while understanding how Excel interprets and applies them in formulas and functions. Special attention is given to formatting considerations, such as when to treat numeric values like postal codes or phone numbers as text, ensuring data accuracy and compatibility with future exports. The course then introduces the concept of cell referencing, explaining how Excel identifies cells by their column and row designations and how this becomes essential in formulas, charts, and tables. From there, participants learn practical methods for selecting and highlighting data, including continuous ranges, independent ranges, rows, columns, and entire worksheets, while mastering shortcuts like Shift, Control, and Control + A to streamline the process. Learners will also gain familiarity with commonly used commands available through right-click menus and the Quick Access Toolbar, including formatting, insertion, deletion, and lookup options. Finally, the course covers methods for moving, copying, and pasting data, whether through drag-and-drop tools, cut-and-paste commands, or duplication with copy and paste shortcuts. By the end, learners will be equipped to enter, manage, and manipulate data efficiently, creating a solid foundation for more advanced Excel tasks.

Course outline