Advantages of Microsoft Excel Microsoft Excel allows you to manipulate, manage and analyze data helping assist in decision making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal database and expenses Microsoft Excel gives you the right tools to enable you to accomplish all your needs. The advantages of Excel are wide and varied; here are the main advantages:
Easy and effective comparisons - With the powerful analytical tools included within Microsoft Excel you have the ability to analyze large amounts of data to discover trends and patterns that will influence decisions. Microsoft Excel’s graphing capabilities allows you to summarize your data enhancing your ability to organize and structure your data. Powerful analysis of large amounts of data - Recent upgrades to the Excel spreadsheet enhance your ability to analyze large amounts of data. With powerful filtering, sorting and search tools you are able to quickly and easily narrow down the criteria that will assist in your decisions. Combine these tools with the tables, Pivot Tables and Graphs you can find the information that you want quickly and easily even if you have hundreds of thousands of data items. While you will need the latest technology to get the best out of Microsoft Excel it is scalable and can be used at home on your low powered PC or at work on your high powered Laptop. Working Together - With the advent of the Excel Web App you can now work on spreadsheets simultaneously with other users. The ability to work together enhances your ability to streamline processes and allows for ‘brainstorming’ sessions with large sets of data – data – the the collaboration tools allow you to get the most out of the sharing capabilities of Microsoft Excel.The added bonus is that as the Excel Worksheet is web based you can collaborate anywhere – anywhere – you you are no longer tied to your desk but can work on spreadsheets on the go – go – this this is ideal for a businessman on the go. Microsoft Excel Mobile & iPad Apps - With the advent of the tablet and the smart phone it is now possible to take your worksheets to a client or a meeting without having to bring along your Laptop. The power of these mobile devices now allows you to manipulate data and update your spreadsheets and then view the spreadsheets immediately on your phone or tablet.
Advanced users of Microsoft Excel can use Visual Basic for Applications to automate Excel. VBA is a very powerful programming language that allows you to enhance the overall functionality of Excel.
Useful Links
How to Insert Hyperlinks in Microsoft Excel Accounting on Excel: using Templates Excel 2007: converting from the Excel 2003 menus to ...
How to use pivot tables in Microsoft Excel Creating Invoices on Excel How to Freeze a Row in Microsoft Excel Mortgage Loan Calculator using Excel Creating an Excel Schedule Template How to create bar graphs using excel
Disadvantages of Microsoft Excel
Not easy to share – Microsoft have made great strides with their Web applications but the sharing functionality still has a long way to go to become world class. Part of the problem is that often the ability for sharing a tool requires extra software to be installed on the PC and this often becomes cumbersome. Tools like Google Documents are revolutionizing the way people share documents online. Non relational – I use MS Access for databases and love the relational aspect of the database. The idea that you can link data by common elements (such as employee ID, Stock Number etc) greatly assists in the reduction of data, and the ability to analyze data. Aside from some database functions and some lookup tools Microsoft Excel lacks any true relational functionality. Scalability – Excel 2010 has introduced larger spreadsheets and binary formats, howver using large amounts of data on the average PC will slow down and often freeze the PC. As some of the competing tools are in the 'cloud' file size does not become a problem. No Forms – while you can use forms within VBA, the average user will not have much knowledge of VBA and therefore not be able to incorporate functional forms into their spreadsheets quickly. Customizable Graphs – Microsoft Excel does offer a good variety of graph capabilities, however the customization of the standard formats, and the combination of different data sets and different types of graph is awkward and not intuitive. For a powerful worksheet this is a big disadvantage.
Compatibility with Other Excel Users o
Excel users rarely need to worry about file compatibility when sending or receiving spreadsheets to or from colleagues. Due to the extraordinary popularity of Microsoft Excel, Excel users seldom need to worry about converting a spreadsheet to a different format.
Compatibility with Other Financial and Data Manipulation Software o
o
Again due to Excel's popularity, Excel spreadsheets can be inserted, viewed, imported or manipulated from within a variety of other popular software applications, from other Microsoft Office products to third-party accounting and tracking programs. Sponsored Links Excel to Web in Minutes
Transfer Excel data to Web App Download Now & Get a Free Trial. www.AutomationAnywhere.com/Excel
Robust Help and Assistance Availability o
Beyond the extensive help documentation included within Microsoft Excel, users can also find many resources for help online, in libraries and in bookstores in the form of free tutorials, walk-through videos, support forums and comprehensive guides and how-to books.
Powerful Customization o
Although these features are rarely seen by most users, Microsoft Excel offers tremendous customization through macros and Visual Basic add-ons, for those users with specific needs and programming experience.
Ease of Use o
Excel is also widely considered to be one of the most easily accessible spreadsheet programs, with instinctive design, simple point-and-click functionality and helpful wizards to guide new users through the more complicated processes.
What is Excel and its various features? Excel is an Microsoft office application. Excel is mainly used for making calculations and mathematical works. Microsoft excel is a spread sheet application in which no of sheets we can add as per our requirements. In a single sheet, it consists of rows and columns and cells. Every cell has different address. In excel sum, product, subtraction, division and many mathematical, logical functions are available with this application. Other features tables, charts, clip art etc. you can find with Excel. It basically used for payroll, accounts, mathematical and for other business purposes. Features of Excel:1. Hyperlink:-We can link one file to another file or page with the use of Excel. 2. Clip art:- In this we can add images and also audio, video clips can be added here. 3. Charts:- With charts, we can clearly shown products evaluation to the clients. For example which product sale is more or less in this month. 4. Tables:- Tables are created with different fields eg -name, age, address, roll no so we add a table to fill these values. 5. Functions:- MATHEMATICAL:Add, subtract, div, multiply. LOGICAL:average, sum, mod, product 6.Images and Backgrounds:- In this we add images and backgrounds in sheet.
7. Macros:- Macros are used for recording events for further use. 8. Database:- We can add database from other sources with data feature. 9. Sorting and Filter:- In sorting we can sort our data and also filter our data so that repetitions will be removed. 10. Data Validations:- In data tools there are data validations consolidate etc are used. 11. Grouping:- In this we can use group, ungroup subtotal etc. 12: Page layout:- In this themes, colors, sheets, margins, size, backgrounds, breaks, print, titles, sheets height, width, scaling, gridness, headings, views, bring to front of font or back alignment etc will be used.
