Excel
Excel is both a teaching and a learning tool for quantitative analysis. As a statistical program that is readily available to students and universities, Excel is used for many different educational applications from tutorials in courses to fieldwork. The graphical functions and computational ability of this program make it invaluable to the study of Earth Sciences.
The following module consists of resources and videos which provide some of the basic functioning and usage of Excel. These videos and links can be used as the starting point for some topics, and as a refresher for others. There are many valuable resources such as textbooks and YouTube videos which can be consulted for specific troubleshooting, but the aim here is to provide the first building blocks towards ease of use with Excel. Though these videos do not need to be watched in a particular order, they build upon each other content wise. Take a look through the table of contents and see if there’s anything you’re unclear about – or return here when working on exercises that are completed using Excel.
1. Navigating datasets | 1.1 Starting in Excel | 1.1.1 Cell addresses 1.1.2 Navigation tips 1.1.3 Click 1.1.4 CTRL + Shift 1.1.5 Bar, scroll |
1.2 Organising cells | 1.2.1 Hiding columns 1.2.2 Freeze panes |
|
1.3 Data Handling & Sorting | 1.3.1 Find and Replace 1.3.2 Sort and Filter 1.3.3 Finding anomalies 1.3.4 Copying (without blank cells) 1.3.5 Custom sorting 1.3.6 .csv/.txt data handling |
|
1.4 Formatting Cells | 1.4.1 CTRL + 1 1.4.2 Tidying cells |
|
2. Entering simple commands | 2.1 Excel as Calculator | 2.1.1 Excel as calculator 2.1.2 AVG, SUM, STDEV, COUNT 2.1.3 Absolute cells |
2.2 Fill and series | 2.2.1 Numbers, dates 2.2.2 Flash fill |
|
3. Creating basic graphs in Excel | 3.1 Histograms without tool pack | 3.1.1 Format data 3.1.2 Create graph 3.1.3 Bin distribution 3.1.4 Axis labels and title |
3.2 Histograms with tool pack | 3.2.1 Format data 3.2.2 Create graph 3.2.3 Bin distribution 3.2.4 Axis labels and title |
|
3.3 Scatterplots | 3.3.1 Format data 3.3.2 Create graph 3.3.3 Format data labels 3.3.4 Chart elements 3.3.5 Formatting and recolouring |