On this page:
"Excel is everywhere. It is by far the most popular program in the history of business applications"
Microsoft Excel can be used to set up tables of information, both textual and numerical. It is particularly useful for calculating using formulas and functions (built-in more complex formulas). It can also be used to visualise numerical data with the use of charts and graphs. Excel can also be used as a simple database and can be queried and filtered to display only information meeting required criteria. This makes Microsoft Excel a very useful program for basic data analysis, statistics and graphs.
Microsoft Excel makes it possible to analyse, manage, and share information. You can do this by:
Using formulae and functions to carry out a variety of calculations, from simple arithmetic to complex logical and statistical tasks.
Creating a range of highly editable charts
Importing data from a variety of sources and using functions to clean and organise it.
Creating tables and lists that can be sorted and filtered.
Using standard MS Office tools such as shapes and SmartArt to create diagrams using your data.
Using macros to automate repetitive tasks.
You can also easily access your important data on the go from almost any Web browser, tablet or smartphone.