Working with Spreadsheets & Data Organization

Objective

Learn how to organize, structure, and manage information using spreadsheets.

Topics Covered

  1. Spreadsheet Fundamentals
    • Rows, columns, cells, and workbook structure
  2. Data Entry & Editing in Excel
    • Entering, modifying, and organizing data
  3. Formatting & Presentation Techniques
    • Fonts, alignment, borders, and formatting consistency
  4. Basic Spreadsheet Formulas
    • SUM, AVERAGE, COUNT, and simple calculations
  5. Sorting & Filtering Data
    • Organizing and searching information efficiently

Activity

Create, organize, and format a structured dataset using Microsoft Excel.

Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare