Data validations: Data Validation Feature helps to restrict the cell to accept certain type of the data.Excel has the Advanced Filtering option to perform the more complex filters. We can set verity of the options to filter with required options. Filtering: We can Filter the data in Excel.We can sort Ascending or Descending with on or more columns.
#10 uses of microsoft excel free#
We can draw any shape with the free form feature in Excel. Shapes: We can create verity of shapes to represent the data in shapes and info-graphics.Charts: We can use charts to represent the data in rich visualized graphical representation.We can divide the Main features of the Excel into Graphical, Data Base and Functional Features:Įxcel have verity of the graphical features to represent the data in Charts and pictorial format. Here are the main features of the Microsoft Excel. Microsoft added many features in each release of Excel 2007, 2010, 2013, 2016 and Office Online 365.
Excel is the very popular application because of its wide range of features and powerful tools. Features of Excel made the Excel as most widely using application.