Date & Time Functions | Data with Duke Fundamentals Lesson 4
2/8/2026
In this lesson we break down how **dates and times actually work** in Google Sheets and Excel, including serial values, time as decimals, `TODAY()` vs `NOW()`, and why timestamps can silently betray you. We also cover building dates properly with `DATE()`, extracting components, and formatting dates as text — plus the *very important* warning about when a date stops being a date at all.
spreadsheetsgoogle sheetsmicrosoft exceldate time functionsdate functionstime functionstoday functionnow functionspreadsheet basicsexcel basicsgoogle sheets tutorialdata typesdata cleaningdata qualitydata literacylearn spreadsheets
Text Functions | Data with Duke Fundamentals Lesson 3
1/4/2026
In this lesson of Spreadsheet Basics, we cover the core text functions you’ll actually use: LEN, UPPER/LOWER, LEFT/RIGHT/MID, and the unsung hero TRIM (because invisible spaces are the spreadsheet equivalent of stepping on Lego)
spreadsheetsgoogle sheetsmicrosoft exceltext functionsLENTRIMUPPERLOWERLEFTRIGHTMIDFINDspreadsheet basicsexcel basicsgoogle sheets tutorialexcel tipsdatadata literacydata skillsbeginnerslearn spreadsheets
Data, Data Everywhere... but what Type? | Data with Duke Fundamentals Lesson 2
11/2/2025
Not all data is created equal... and that's by design. There are many Data Types out there... but in a Spreadsheet, there are only 2 worth worrying about.
ExcelGoogleSheetsSpreadsheetSpreadsheetTipsExcelBasicsGoogleSheetsTipsDataTypes
What's a Spreadsheet anyway? | Data with Duke Fundamentals Lesson 1
9/27/2025
You gotta start somewhere, right? Learn the basic parts of a spreadsheet and how to start creating calculations to help you in your everyday life. There's lots to learn, so let's start at the beginning!
ExcelGoogleSheetsSpreadsheetSpreadsheetTipsExcelBasicsGoogleSheetsTips
