Excel Tutorial for Mac

This tutorial is for Excel 2011 on Macs. For Excel 2010 for PCs, go here.

If you would like to request additional content, please email the Empirical Reasoning Lab. 

 

Want to use the same data as the tutorial?

Some of the exercises use data from the New York City Census Tracts. If you would like to follow along with the same data, you can download the file here.

 

Data Manipulation Basics

Getting Started with Spreadsheets

Worksheets vs. Workbooks
Saving a Workbook

Worksheet Basics

Naming a Worksheet
Adding a Worksheet
Deleting a Worksheet
Moving a Worksheet
Copying a Worksheet
Copying a Worksheet to Another Workbook
Changing the Worksheet Tab Color

Introduction to the Ribbon

Tabs, Groups, Features

Cell Manipulations

Entering Data
Selecting Cells
Selecting Non-adjacent Cells
Selecting Rows or Columns
Selecting Entire Worksheet
Changing the Size of Cells
Fixing '####' in Cells

Formatting Cells

Font
Alignment
Number

 

Copying, Cutting, & Pasting

Copying & Cutting
Pasting
"Transpose" and "Paste as Values"

Inserting & Deleting

Inserting Rows or Columns
Inserting Cells & Cell Ranges
Deleting Rows and Columns
Deleting Cells
Delete Content

Manipulating Data I

Undo 
Redo
Repeat
Customizing the Quick Access Toolbar
Find
Replace

Manipulating Data II

Sorting Basics
Sorting a Single Column
Sorting Multiple Columns
Important Sort 'FYIs'
Auto Fill 
Series Fill
Hiding 
Unhiding

Charts

Creating Charts

Creating a Chart
Selecting Data
Inserting Chart without Data
Chart Parts
The Basics of Chart Tabs

Formatting Charts

Formatting the Chart Plot Area

Changing the Size of the Plot Area
Format Plot Area

Formatting the Chart Axes

Formatting the Horizontal Axis
Formatting the Vertical Axis
Inserting Axis Titles
Horizontal Axis
Vertical Axis

 

 

Formatting the Chart Legend

Legend Options
Resizing the Legend
Legend Font

Copying, Cutting, & Pasting Charts

Trendlines, Error Bars, and Grid Lines

Linest Function

Pivot Table

 

Formulas & Functions

Formula Basics

Getting Started
Writing Formulas
Using Cell Referents
Using Auto Fill with Formulas
Relative versus Absolute Referencing

Using Excel's Functions

Function Basics
Inserting a Function
Excel Functions: Sum Example
- Using Auto Fill with Functions
Finding Functions

 

Common Function & Formula
Error Messages

Cell Referent Errors
- Dividing by Zero
- Cell Value Error
- How to Fix an Error in a Cell
Formula & Function Errors
- Circular Reference
- Missing Parenthesis & Formula Errors

Some Useful Statistical Functions

Calculating the Mean
 Standard Deviation
 T-tests

Macros

Why use Macros
Getting Started
Recording Macros
Running your Macro

Ribbon Tabs- Still to come!

File Tab
Home Tab
Insert Tab
Page Layout Tab
Formulas Tab
Data Tab
Review Tab


View Tab
Acrobat Tab

Chart Tabs

Design Tab
Layout Tab
Format Tab

 

 

Questions, comments, concerns?
Send an email to the Empirical Reasoning Lab
Or drop by during the Lab's open hours.