Why Tables?

Microsoft Excel can be used to analyze vast amounts of data, and one of the best features in Excel for this purpose is changing your data range to a table. With tables, you can quickly sort and filter your data, add new records, and see your charts and PivotTables update automatically.

Tables also take care of another one of my favorite features: “Named Ranges.” Named Ranges are covered in my Excel Intermediate course. For now, let’s look at ten (10) reasons why you should use a table with your data.

Course curriculum

    1. Getting Started (Please Read)

    1. Converting a Range to a Table

    2. Quiz 1

    3. Creating Dynamic Charts

    4. Quiz 2

    5. Auto Fill. Calculated Columns. Header Rows Repeat

    6. Convert to Range and Resize Table

About this course

  • Free
  • 7 lessons

Instructor(s)

Chris Menard

Chris Menard, a Microsoft Certified Trainer (MCT) at BakerHostetler, a leading national law firm with offices in 17 cities, is a skilled and experienced educator. With over two decades of training experience and a deep understanding of Microsoft 365, G-Suite, and eLearning, he is a sought-after speaker for organizations such as the Georgia Society of CPAs, the American Society of Administrative Professionals, EA Ignite Conference, and the University of Georgia. Chris’ impact extends beyond the lecture hall, with his popular YouTube channel boasting over 900 technology tutorials with a combined 15 million views. When not training and educating, Chris enjoys traveling and spending time with his family.

Frequently Asked Questions

  • When does the course start and finish?

    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

  • How long do I have access to the course?

    How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.

  • What if I am unhappy with the course?

    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.