Dr Susanne Flach | Linguist

Neuchâtel | Switzerland

Excel

The Excel tutorial walks you through the basic principles, steps, and possible issues when working with linguistic data in Excel. The aim is to overcome that scary Excel feeling and make you comfortable enough with spreadsheet software, so that you can start to help yourself if faced with a specific task. It is the second part of the three part series on linguistic data analysis.

The tutorial assumes no prior knowledge of Excel, but may also be useful for more experienced users, as it points out “good practices” and shortcuts along the way. Many of the topics are based on holding workshops and advising in linguistic data processing and analysis. So see all tips as pieces of advice, rather than “rules”. It is probably a good idea to follow all episodes if you are a complete beginner to become more confident in a new environment, and then come back to individual clips when you need them.

(The tutorial is currently under construction. To make suggestions, send me an email.)

CONTENTS

There is no intended episode structure as yet, clips are added as the topics come to mind. If you have never (really) worked with Excel before, proceed in the order of appearance. There might be a more sensible structure in the future, along with a reference guide on which functions are discussed in which video.

Section 1: Excel basics (Playlist, average clip length: ca. 6mins)

§1 — Introduction
§2 — Basic file structure
§3 — Filling cells
§4 — Cell reference
§5 — Basic functions
§6 — Tables in Excel
§7 — Sorting and filtering
§8 — Long vs wide formats
§9 — Shortcuts

§10 — Importing concordancer output
§11 — Import problems
§12 — Adding and moving columns
§13 — Annotation basics (in post-production)
§14 — Randomisation (in post-production)
§15 — Adding basic meta info (in post-production)
§16 — Randomisation 2 (in post-production)
§17 — Documentation (in post-production)

In preparation:

Pivot tables, summary statistics, basic graphs, exporting graphs, formatting, text processing, working with meta data to facilitate annotation, advanced sorting for annotating, adding meta data from another source

Last updated: November 16, 2020