PeppubooksCreate a Database with GoogleSheet and Rust: Handling Data Validation with RustIn our last post, we explored our first request into our spreadsheet. We made a mock ‘post’ request successfully into our database. While…Apr 1, 2023Apr 1, 2023
PeppubooksHow to Use Google Sheet: GoogleSheet Search Functions (VLOOKUP, HLOOKUP, XLOOKUP).Google Sheets is a powerful tool for organising and analysing data. With its wide range of features and functions, Sheets can help you make…Mar 18, 2023Mar 18, 2023
PeppubooksCreate a Database with GoogleSheet and Rust: Mock ‘Post’ Request to GoogleSheet.In the last post, we discussed creating a service account and setting it up for our database. One important factor for choosing a database…Mar 16, 2023Mar 16, 2023
PeppubooksHow to Use Google Sheet: XLOOKUP, What Is It?Google Sheets is a widely-used tool for managing data, and one of its most important features is the ability to perform lookups. In the…Mar 13, 2023Mar 13, 2023
PeppubooksHow to Use Google Sheet: HLOOKUP, How It Works.Searching GoogleSheet effectively, allows you to work on your data better. In this tutorial we’ll explore search with Horizontal lookup.Mar 11, 2023Mar 11, 2023
PeppubooksCreate a Database with GoogleSheet and Rust: Setting up Service AccountWelcome to our guide on creating a database with GoogleSheet. First, we’ll create a service account in Google Cloud Project. Service…Mar 9, 2023Mar 9, 2023
PeppubooksHow to Use Google Sheet: VLOOKUP in GoogleSheet, How Does It Work?If you’ve ever worked with a large dataset in Google Sheets, you may have found yourself spending hours scrolling through rows and columns…Mar 6, 2023Mar 6, 2023
PeppubooksHow to Use Google Sheet: Query in GoogleSheet, How Does It Work?Google Sheets is a powerful tool for organising, analysing, and presenting data in a spreadsheet format. For instance, a teacher may want…Mar 4, 2023Mar 4, 2023
PeppubooksHow to Use Google Sheet: CountIFCountIF is a useful function in spreadsheets that allows you to count the number of cells within a range that meet a certain criteria. This…Mar 2, 2023Mar 2, 2023
PeppubooksHow to Use Google Sheet: How to Highlight Duplicates in GoogleSheetsGoogle Sheets is a powerful tool that enables users to manage and analyse data with ease. When you deal with a large data like this, one…Feb 27, 2023Feb 27, 2023