Let’s start by taking a tour of the Excel interface! When you first open up Excel, the sheer number of features can be a little overwhelming. But once you understand the structure behind Excel’s layout, you can find the features you need and put the flexibility of Excel to use.
Excel is structured around two basic purposes:
- Storing data and analyses of data
- Performing analyses of data
Let’s walk through the schematic of Excel in the learning environment to the right. At the bottom of the schematic are tabs corresponding to three sheets named
The actual sheets appear above the tabs with the sheet names. The sheets are where Excel stores data tables and the results of data analysis, like charts or calculations. The data analysis tools themselves are stored above the sheets.
The formula bar is directly above the sheets. This is where you can view and edit any calculations you are using in your analysis.
The area above the formula bar displays different analytics options depending on which tab is open. In the schematic, the Home tab is open and the Insert and Data tabs are closed. Each icon on a tab is connected to some analytics function like sorting a table or creating a chart.
Depending on your version of Excel, icons may appear differently, but they should always be in the same location. We’ll give you directions in each exercise to find the tools you need!
When you’re ready to explore what Excel has to offer, select