Skip to content
Microsoft Productivity Tools

Insert data in cells and ranges in Excel


Course
Quantity
For someone else
Quantity
For someone else
Purchase for $99.95 or enter access code

This online course will teach you the essential skills needed to insert and manage data in Excel. From understanding the Excel interface to advanced data entry techniques, you will gain hands-on experience in appending data to worksheets, finding and replacing data, copying and pasting data, using the AutoFill tool, expanding data across columns, and inserting and deleting cells. By the end of this course, you will be able to confidently insert and organize data in Excel for a variety of real-world applications.

Here is the course outline:

1. Introduction to Excel and Cell Basics

This module provides an overview of Excel interface, understanding cells and ranges, and techniques for data entry. The module will also introduce different data types and basic formulas.

Understanding the Excel Interface
Mastering Cell Basics
Advanced Data Entry Techniques
Quiz

2. Advanced Excel Techniques

This module delves deep into advanced data entry, using functions, and linking data. Participants will learn about the AutoFill tool, expanding data across columns, and finding and replacing data.

Appending Data to Worksheets
Finding and Replacing Data
Copying and Pasting Data
Quiz

3. Summary and Data Import/Export in Excel

The final module will recap all the learned skills and introduce data import and export techniques. It will cover inserting and deleting cells, copying and pasting data, and appending data to worksheets.

Appending Data to Worksheets
Finding and Replacing Data
Copying and Pasting Data
Quiz
Glossary
Back to top