Listen Top Shows Blog

Flashlight #3: Tricks for Formulas and PivotTables

Flashlight #3: Tricks for Formulas and PivotTables

Update: 2025-04-23

Share

Description

Struggling with formulas and PivotTables? Mariana shares practical tricks to make Excel work for you. Her insights will help you work smarter, prevent errors, and make data analysis more fun and effective.

Discover how small adjustments can make a big difference.

Comments

In Channel

Flashlight #4: Setting the Font Once and for All

Flashlight #4: Setting the Font Once and for All

2025-04-2301:49

Beauty: Conditional Formatting

Beauty: Conditional Formatting

2025-04-2327:25

Beauty: Adventure • Making Data Dance

Beauty: Adventure • Making Data Dance

2025-04-2310:13

Flashlight #3: Tricks for Formulas and PivotTables

Flashlight #3: Tricks for Formulas and PivotTables

2025-04-2303:30

Accomplishment: Strings, Booleans, Numbers, and Dates

Accomplishment: Strings, Booleans, Numbers, and Dates

2025-04-2314:16

Accomplishment: Legend • When Dreams Come True

Accomplishment: Legend • When Dreams Come True

2025-04-2312:00

Beauty – Clarity By Design

Beauty – Clarity By Design

2025-04-2312:19

Accomplishment – A Genuine Sense of Achievement

Accomplishment – A Genuine Sense of Achievement

2025-04-2308:23

Intermission: Excel Meets Rudolph!

Intermission: Excel Meets Rudolph!

2025-04-2304:02

Flashlight #2: Color-Coding Tabs

Flashlight #2: Color-Coding Tabs

2025-04-2301:00

Focus: Data Organization and Management

Focus: Data Organization and Management

2025-04-2328:16

Focus: Fantasy • The Power of Big Picture Thinking

Focus: Fantasy • The Power of Big Picture Thinking

2025-04-2306:43

Flashlight #1: Hidden, Filtered, Grouped

Flashlight #1: Hidden, Filtered, Grouped

2025-04-2304:05

Discovery: 'Analyze Data' at the Click of a Button

Discovery: 'Analyze Data' at the Click of a Button

2025-04-2306:05

Discovery: Memoir • No-Clue Intern to Dashboard Pro

Discovery: Memoir • No-Clue Intern to Dashboard Pro

2025-04-2316:34

Intermission: Journey into Excel!

Intermission: Journey into Excel!

2025-04-2305:00

=CONCAT("SIX REASONS ","TO LOVE")

=CONCAT("SIX REASONS ","TO LOVE")

2025-04-2104:45

Data Analytics, Magic Land

Data Analytics, Magic Land

2025-04-2114:14

Tableau, the New Fancy

Tableau, the New Fancy

2025-04-2106:15

Excel, Everyone's Favorite Scapegoat

Excel, Everyone's Favorite Scapegoat

2025-04-2103:50

00:00

00:00

1.0x

Flashlight #3: Tricks for Formulas and PivotTables

Flashlight #3: Tricks for Formulas and PivotTables

Excel with Mariana.