It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
"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.
Features and benefits of Excel
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.
Watch this video to learn the basics. When you use cell references in a formula, Excel calculates the answer using the numbers in the referenced cells. When you change the value in a cell, the formula calculates the new result automatically.
Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.
Online and video tutorials - more advanced features
You want to automate a repetitive task in Excel so that you can do the task again with a single click. The best way to do that? Record a macro. And the macro recorder is the easiest way to create a new macro in Excel.
Many also have step-by-step instructions below the video.