My Beginner Guide | Annie Nelson

Files from the Guide

Data cleaning functions in Sheets/Excel

Spreadsheets Common Errors and Fixes

Pivot Tables

Keyboard Functions in Sheets

How to Access Your Changelog of your spreadsheet

VLOOKUP Sheets/excel

SUMIF/COUNTIF in spreadsheets

Data cleaning functions in spreadsheets

Sheets functions learned in the Google Course

SQL Cheatsheet

SQL Best Practices

SQL Subfunctions

Temporary Tables

Intermediate Guide to SQL

CONCAT + in SQL Manipulating Strings

SQL functions learned in Google Course with examples

Resources for Combining Data in Tableau

How to Choose A Viz

What Kind of Viz

R Markdown Cheatsheet

ggplot information

R Vocab

Common Problems When Visualizing in R

Output formats in R Markdown

Operators

Keeping Your Code Readable

Vectors, Dates, and Times

Vectors and lists in R

Ways to Learn About Programming

Jupytr Notebooks

R Functions Learned in the Google Course with Examples

Creating a new R Markdown File Activty (hands on instructions)