Free Excel Tutorial for Engineers : More Interesting Concept

More advance features in Excel are discussed in this section. The chapters included in this section are:

More

Pivot:

The pivot option allows you to summarize the data in lengthy worksheets in short tables or charts.

Sheet Protection:

This option allows you to protect your worksheets with passwords so that no one else can edit or tamper with your data.

Data Validation:

This option allows you to create a drop down menu for data that has to be entered repeatedly in a worksheet.

Graphs & Charts:

This option allows you to spice up your worksheets with colourful and varied graphs and charts to depict lengthy data.

Macros:

Macros allow you to create functions as per user requirement that can be used while working on worksheets.