Все публикации

0:20:28

Find or check if a cell contains text from a list of values in Google Sheets (3 methods) - Tutorial

0:21:26

New 2023 Google Sheets functions to transform, clean, and organize your data - Tutorial

0:10:27

How to count the number of colored cells or formatted cells in Google Sheets - Tutorial

0:19:04

How to do a VLOOKUP with multiple conditions or criteria (3 methods) Excel/Google Sheets - Tutorial

0:16:15

How to use Slicers in Excel to filter multiple PivotTables and charts - Tutorial & Walkthrough

0:15:01

Top 3 tips for using the most important Excel feature for data analysis: Pivot Tables

0:27:37

Cleaning up data and doing exploratory analysis in Excel with Friends episodes data

0:10:40

4 methods to AutoFit column widths in Excel on Mac with only keyboard shortcuts - Tutorial

0:09:05

Create Google Calendar events by sending yourself an email in Gmail on mobile - Productivity Hack

0:10:06

Extract first name, multiple middle names, & last name into columns in Google Sheets/Excel

0:05:29

Count the number of words in a cell in Google Sheets or Excel - Tutorial

0:10:43

Creating a percentage with a calculated field in Google Sheets or Excel - Tutorial

0:20:17

How to import data from another Google Sheet and filter the data with the IMPORTRANGE function

0:18:43

Generate unique IDs for your dataset for building summary reports - Excel & Google Sheets

0:16:41

How to update and add new data to a PivotTable and keep reference updated - Excel & Google Sheets

0:19:14

Use OpenRefine to clean a messy dataset about Bitcoin Tweets - Microsoft Power Query alternative

0:12:17

How to extract text from a middle of a cell in Google Sheets or Excel using MID and FIND functions

0:07:27

How to structure your data for a PivotTable in Excel or Google Sheets (denormalizing data)

0:21:08

Tutorial to fill values down into empty cells in Google Sheets and Excel (Google Apps Script & VBA)

0:10:29

How to use VLOOKUP when doing a lookup to the left without INDEX/MATCH in Google Sheets

0:11:31

How to prevent incorrect cell references in your formulas using Reinhart & Rogoff Excel error

0:11:39

How to Generate a Random List of Names Based On Set List of Names in Google Sheets/Excel

0:22:41

Splitting Costs With Friends Template in Coda.io

0:14:21

How to Split Costs With Friends in Google Sheets