intermediate

Excel — Excel Interface, Data Entry, and Basic Operations + 5 more topics

Comprehensive AI-generated study curriculum with 1 detailed note module.

0 students cloned 2 views 1 notes

Course Syllabus

  1. Excel Interface, Data Entry, and Basic Operations
  2. Formulas and Functions Fundamentals
  3. Data Management, Sorting, and Filtering
  4. Lookup Functions and Conditional Formatting
  5. Data Analysis Tools and Visualization
  6. PivotTables and Introduction to Power Query

Study Notes

Excel Interface, Data Entry, and Basic Operations

Excel is made up of workbooks, which are individual files. Each workbook contains one or more worksheets (tabs at the bottom). A worksheet is a grid of rows (numbered 1, 2, 3...) and columns (lettered A, B, C...). The intersection of a row and a column is called a cell, identified by its column letter and row number (e.g., A1, B5).

Read full note →