top of page

This site was designed with the

website builder. Create your website today.Start Now

Spreadsheets

On this page, I'll share some of the Google Sheets and Excel transformations I've documented. "Raw" are before versions, and "Transformed" are after versions. For insight on what's happening in the spreadsheet, you can click yellow tags in top right-hand corners of cells to reveal comments.

Tool

Years of Experience

Level

Google Sheets

Microsoft Excel

2 Years

2 Years

Advanced

Advanced

Bar Chart/Pivot Table
(Transformed)

Bar Chart/Pivot Table
(Raw Version)

Conditional Formatting (Transformed)

Conditional Formatting
(Raw)

CONVERT
(Transformed)

CONVERT (Raw)

CONCAT(Transformed)

CONCAT(Raw)

Optimizing Data(Transformed)

Optimizing Data(Raw)

VLOOKUP/Pivot Table
(Transformed)

VLOOKUP/Pivot Table
(Raw)

MAXIFS
(Transformed)

MAXIFS
(Raw)

Custom SORT
(Transformed)

Custom SORT
(Raw)

Data Cleaning
(Transformed)

Data Cleaning
(Raw)

SUMIF
(Transformed)

SUMIF
(Raw)

VLOOKUP Practice
(Transformed)

VLOOKUP Practice
(Raw)

LEFT/RIGHT/LEN
(Transformed)

LEFT/RIGHT/LEN
(Raw)new google-sheets-logo2.png

SPLIT/SORT
(Transformed)

Home

Back to the homepage.

Man Holding Bicycle

Bike Share Project

User Experience Analysis on a Bike Share Company.

Sheet 2.png

Experience

Skills and things I've learned.

Certifications

Professional Certificates I've earned.

Bellabeat Project

Product Analysis Project on a FemTech Company.

iphone

Contact

Get in touch, let's figure out the best time to schedule a chat.

bottom of page