The main new feature in Excel 2007 is Excel Ribbon Menu. Excel has introduced ribbon menu in Office 2007 and added verity of the features in each release: Features of Excel 2007 We can use Excel for wide range of applications. Excel Provides, verity of the Add-ins for Data analysis and ETL process.Protection: Excel provides Workbook, Worksheet and VBA Protection options.SpellCheck: Built-in spell check feature helps us to avoid the spelling and grammatical errors in the data.This helps to highlight the significant data range. Conditional Format: We can format the data based on certain conditions.Hyperlinks: We can add hyperlinks in the Excel to quickly navigate the different parts of the Excel Workbook.Add-ins: We can develop the Excel Add-ins with VBA or.
We can use Macros feature to automate the repetitive tasks.
VBA Macros: Excel comes with VBA Programming. Verity of the formulas (Text, Date, String, Maths,etc) will help to perform verity of calculations. Functions: There are more than 300 built-in formulas to use in the Excel Cells. Grouping: We can group the rows and columns with parent and child records.Įxcel Tools and Functions will help to perform powerful calculations and enhance the Excel Application Features. We can also provide the drop-down to choose from the pre-defined list. 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. Sorting: We can sort the data in Excel. We can connect to verity of the data bases and import the data into Excel. Database: We can use Excel as Data base to store the 1 million records. Sparklines: Introduced in Excel 2010, we can insert the light weight charts into the cells. This will be helpful to quickly perform further analysis. We can create the tables in the data in records and fields format. Slicers: Slicers are introduced in Excel 2010, this will helps us to connect the multiple pivot tables and filter the data with buttons. PivotTables: We can use the Summarize the data and create powerful cross tables. Example backgrounds of Worksheets, Shapes and Charts.Įxcel can be used as data base and perform of verity of data operations. Pictures: We can insert any image to enhance the objects. Clip Arts: We can add the ready to use clip arts to convey our message in pictorial representation. SmartArts: We can use the SmartArts to align the data in a creative designs and visually communicate the information. 3 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.
0 kommentar(er)
