Basics of Excel

Learn the basics of Excel with this beginner-friendly guide. Understand workbooks, worksheets, formatting, Find & Select, shortcuts, printing, sharing, and protecting Excel files.

If you are new to Excel or want to strengthen your foundation, this page gives you a complete overview of how Excel works and how its main features are structured.

1. Ribbon

The Ribbon is the main command interface in Excel. It appears at the top of the window and organizes tools into tabs and groups so you can quickly access Excel features.

Key concepts:

2. Workbook

A Workbook is an Excel file that stores worksheets, data, and settings. Every Excel project starts with a workbook.

Key concepts:

  • Creating and saving workbooks
  • Workbook themes
  • Viewing multiple workbooks
  • AutoRecover and file recovery
  • Merging Excel files
  • Excel file formats (.xlsx, .xls)

3. Worksheets

A Worksheet is a single spreadsheet inside a workbook where data is entered, edited, and analyzed.

Key concepts:

  • Adding, deleting, renaming worksheets
  • Navigating between sheet tabs
  • Zoom, split, and freeze panes
  • Grouping worksheets
  • Viewing multiple worksheets at once
  • Hiding and unhiding sheets
  • Chart sheets vs regular worksheets
  • Comments and spell check

4. Format Cells

Format Cells controls how data looks without changing the actual values. Formatting improves clarity, readability, and presentation.

Key concepts:

  • Number formats (General, Date, Currency, Percentage)
  • Decimal places and fractions
  • Currency vs Accounting format
  • Converting text to numbers and numbers to text
  • Custom number formats
  • Format Painter
  • Cell styles
  • Wrap text and merge cells
  • Superscript, subscript, strikethrough
  • Removing leading zeros

5. Find & Select

Find & Select helps you quickly locate, replace, and select specific data in a worksheet or workbook.

Key concepts:

  • Find and Replace
  • Workbook-wide searches
  • Case-sensitive and exact matches
  • Wildcards
  • Go To and Go To Special
  • Selecting visible cells only
  • Finding row differences
  • Deleting blank rows

6. Templates

Templates are pre-built Excel files designed for common tasks, helping you save time and work more efficiently.

Key concepts:

  • Budget templates
  • Calendars and schedules
  • Invoices and automated invoices
  • Timesheets
  • Meal planners
  • Default Excel templates (Book.xltx, Sheet.xltx)
  • Health calculators (BMI)

7. Data Validation

Data Validation controls what users can enter into cells, helping prevent errors and maintain data accuracy.

Key concepts:

  • Restricting dates and numbers
  • Preventing duplicate entries
  • Budget limits
  • Product code rules
  • Drop-down lists
  • Dependent drop-down lists
  • Unit conversions (cm to inches, kg to lbs)

8. Keyboard Shortcuts

Keyboard Shortcuts help you work faster by reducing reliance on the mouse.

Key concepts:

  • Function keys
  • Insert and delete rows
  • Save and Save As shortcuts
  • Convert formulas to values
  • Paste Special
  • Show formulas
  • Line breaks
  • Scroll Lock behavior

9. Print

Excel provides full control over how worksheets appear when printed.

Key concepts:

  • Workbook views
  • Page layout and page breaks
  • Headers and footers
  • Page numbers
  • Print titles
  • Centering content on the page
  • Printing gridlines and headings
  • Print areas

10. Share

Excel makes it easy to share data with other users and applications.

Key concepts:

  • Sharing workbooks
  • OneDrive and cloud collaboration
  • Excel Online
  • Exporting to PDF
  • Importing and exporting text files
  • Working with Access data
  • XML data exchange

11. Protect

Protection features help secure Excel files and control how others interact with your data.

Key concepts:

  • Protecting workbook structure
  • Protecting worksheets
  • Locking cells
  • Read-only workbooks
  • Marking files as final

Next Steps

Once you understand these Excel basics, you’re ready to move forward to:

  • Functions
  • Formulas
  • Data Analysis

Each section above can be explored further through step-by-step how-to guides and practical examples.