Read more
LENGTH OF ACCESS: Two Months
LOCATION: Online
This project-based course is an intro to spreadsheets. We’ll be using Google Sheets in this project. We will cover the following concepts in a hands-on manner. Basic data entry, formatting, and calculations.Relative and absolute cell references. Basic functions: concatenate, split, sum, average, median, min, max, count, counta. Advanced functions: vlookup, if, and, or, iferror, countif, countifs, averageif, averageifs, sumif, sumifs\n- Dealing with error messages, formatting, filtering, sorting, basic charts to visualize our data.
Hide