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:



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 allow you to create functions as per user requirement that can be used while working on worksheets.