S1E5-Scatter Chart

02/01/24 • 4 min

In episode five of "Relax with Excel," we gently navigate the creation of an X Y Scatter Chart, a tool for visualizing the relationship between two variables. Each dot in our chart is a peaceful point of data, illustrating how variables interact. Learn this serene method of charting, ideal for understanding complex relationships in a simple, visual format. Whether you're fully engaged or drifting off, this episode turns data visualization into a tranquil, enlightening experience.

Previous Episode

S1E4-XLOOKUP

In the fourth episode of "Relax with Excel," we delve into the world of XLOOKUP, a versatile function that revolutionizes the way you search data in Excel. Learn to effortlessly perform exact, approximate, and wildcard lookups in a soothing, easy-to-follow format. Whether you're seeking the score of "Bob" or "Eve," XLOOKUP makes finding data a breeze. Join us for a tranquil exploration of Excel's powerful tool, where learning is as relaxing as drifting off to sleep.

Next Episode

S1E6-Flash Fill

In the sixth episode of "Relax with Excel," the podcast introduces Excel's Flash Fill feature. Flash Fill automatically fills data based on patterns. The episode demonstrates this by entering names in an Excel file and using Flash Fill to format them as 'Last, First.' It explains step-by-step how to use Flash Fill both through the menu and with the keyboard shortcut Ctrl + E. This easy-to-follow guide is designed for learning, whether listeners are fully awake or drifting off to sleep.