Relax with Excel

Hi, welcome to the ninth episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the basics of how to create a dropdown list.  Having a dropdown list in Excel is highly beneficial for several reasons. Firstly, it streamlines data entry, making...

Hi, welcome to the 8th episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the CONCAT function.    The CONCAT function is a way to join two or more text strings into one. Here is a step by step approach on how to use the CONCAT functio...

Hi, welcome to the 7th episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the Text To Columns  feature.  The “Text to Column” feature is a way to split the text in a cell into multiple columns based on a delimiter or a fix...

Hi, welcome to the sixth episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the Flash Fill feature.  The flash fill feature is a way to automatically fill in data based on a pattern or example. Here is a step-by-step approach on how to use...

Hi, welcome to the 5th episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the basics of creating an X Y Scatter Chart in Excel  An X Y scatter chart, also known as a scatter plot, is a graphical representation used to display the relations...

Hi, welcome to the fourth episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the basics of XLOOKUP.  The XLOOKUP function is a powerful and versatile tool that allows you to look up values in a table or range by matching a lookup value. Yo...

Hi, welcome to the 3rd episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the basics of VLOOKUP.  VLOOKUP is one of the more well-known lookup functions in Excel.  Like most lookup functions, it’s used to find things in a table...

Hi, welcome to the second episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the basics of an Excel Table.  This was previously known as an Excel list.  When you’re putting text and numbers into some structured format where the...

Hi, welcome to the first episode of Relax with Excel where you may learn something about Excel but will probably fall asleep.  Then again maybe you’ll learn in your sleep.  In this episode we’re going to cover the basics of a Pivot Table.  First off, what is a Pivot Table.  Basically, it’s a way to quickly summarize and analyze data.  It can turn an ordin...