Insert, Data and View Tabs — Excel Course

Understand the most useful tools in Insert, Data and View for everyday Excel work. Learn it step by step with guided practice on Excelquro.

Understand

Insert helps you add analysis objects such as tables and charts. Data contains tools for sorting, filtering, validation and transformations. View contains controls such as Freeze Panes and Zoom that improve navigation.

Worked example

Follow along

1. Open Insert and locate the chart area.
2. Open Data and find Sort and Filter.
3. Open Data and locate Data Validation.
4. Open View and find Freeze Panes.
5. Try Zoom and notice that it changes the view, not the data.

Interactive practice runs in your browser.