give me a excel features
Answers
Answer:
Add Multiple Rows. ...
Absolute References. ...
Print Optimisation. ...
Extend formula across/down. ...
Flash Fill.
Explanation:
Microsoft Office Excel is one of the most important tools to perform the calculation, analysis, and visualization of data and information. It helps people to organize and process data by the use of columns and rows with formulas and some cool features of Excel.
Add Multiple Rows. ...
Absolute References. ...
Print Optimisation. ...
Extend formula across/down. ...
Flash Fill.
FOLLOW ME
Explanation:
Sorting Filtering data
If Microsoft ever needs few extra billions of cash, they just have to turn sorting filtering features in Excel to pay-per-use. These ad-hoc analysis features are so powerful simple that any aspiring analyst must be fully aware of them.
Excel Tables Structural References
Excel tables, a new feature added in Excel 2007 is a very powerful way to structure, maintain use tabular data the bread and butter of any data analysis situation. With tables, you can add or remove data, set up structural references, connect them to external sources (SQL server, ODBC etc.), add them to data models (Excel 2013 onwards), link them to PowerPivot (Excel 2010 onwards), format automatically, filter sort with ease and still be out of office before lunch break. ,
hope it helps!