The Important features of Excel

Excel users come in all levels, from novice to power user to developer. But there are several Excel behaviors and features everyone needs to learn. Some of these seem basic. But to the novice, they can seem like rocket science -- at least until you explain them. With these skills conquered, even beginners can use Excel competently.

Features Description
Excel Formulas Excel Formulas paly a vitl role in analyzing data and presenting outputs. If you want to become a data or business analyst then you must develop good understanding of Excel formulas and become fluent in them. Few of them are: Basic Arithmetic expressions, SUMIFS, VLOOKUP, INDEX-MATCH, If Formula, Nesting Forumals, Text formulas NETWORKDAYS and WORKDAYS forumalas, SMALL and LARGE Formulas
Pivot Tables They save you a ton of times, let you create complex reports, charts and caluculations all with few clicks. Pivot tables are ideal tools for managers and analytics who always have to answer quaetion like.
Lookup Formulas Lookup formulas help you locate any information in your workbooks based on input criteria. By Knowing how to write lookup formulas, you can build dashboard, make interavtive charts, create effative models and feel pretty darn awesome. Example of lookup formulas are: VLOOKUP, HLOOKUP, INDEX, MATCH etc.
Excel Charts Excel charts help you communicate insights and information with ease, By choosing your charts wisely and formmating them cleanly, you can convey a lot.
Sorting and Filtering Data Whenever you are working with huge lists of data, filtering and sorting is one simple way analyze the data quickly.
Conditional formatting Conditional formatting is a hidden fetures in excel that can make your workbooks lok great. just add some CF to highlight your data and you will turn boring into interesting. eith new fetures like data bars, color, scales and icon sets. condtional formatting is even more powerful.

Excel spreadsheets are commonly used across business to display financial information and other data relevant to the running of the business. This could be information relevant to the customer relationship management department, sales, marketing or HR. With so many business functions now reliant on IT and the internet, Excel continues to be seen as a vital tool for administration and the effective running of a business.

Build great charts

Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells. Data is inserted into individual cells in rows or columns, allowing it to be sorted and filtered, and then displayed in a visual presentation. Using pie charts, graphs and clustered columns adds meaning to data, which otherwise may just exist as row after row of numbers. These visualisations can add extra emphasis to business reports and persuasive marketing material. Excel recommends charts most suitable for the type of data being presented on the X and Y axis.

Excel Advatages

"Microsoft Excel helps companies maximise the value of their data, helping to control costs more effectively and obtain business information."

MIS Reporting in Excel

"This extensive report is compiled from the responses of fabless semiconductor companies highlighting the MIS systems used. We have collected information such as respondent company revenue and headcount to provide a frame of reference for company size. It is our hope that these improvements will streamline the data collection process as well as enhance accessibility of the results, resulting in higher value for GSA members."