Team PUL

Intro to Excel.

Intro to Excel

Excel is a Microsoft-developed spreadsheet software. It can store data, create graphs, and show trends in data, and has many applications in data science. Some useful tools include the = function, which allows you to set the value of a cell based on the value stored in another cell. So for example, you can put 4 in A1 and then set B1 as =A1*3. B1 will now be 12. If you change A1 to 2, B1 will now be 6.

Another useful feature is shown in this video below. Excel can recognize patterns in your data, and if you highlight the pattern and extend it, it can automatically fill in cells with values.

If you want to learn more about Excel, you can visit the Microsoft Support site or Excel Easy

Lastly, Excel has a very cool tool called Analyze. It can be used to find specific trends, suggest how to sort the data, and show summary statistics. More information about it can be found here.