Stop Using VLOOKUP for Reports - This Excel Workflow Is Better

Stop Using VLOOKUP for Reports - This Excel Workflow Is Better

Kevin Stratvert via YouTube Direct link

- Refresh the report

7 of 9
Previous
Next

7 of 9

- Refresh the report

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Stop Using VLOOKUP for Reports - This Excel Workflow Is Better

Automatically move to the next video in the Classroom when playback concludes
  1. 1 - Why reports break
  2. 2 - A better workflow
  3. 3 - Convert data to tables
  4. 4 - Add tables to a data model
  5. 5 - Create table relationships
  6. 6 - Build the pivot table
  7. 7 - Refresh the report
  8. 8 - Add a revenue calculation
  9. 9 - Wrap up

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.