Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
7 Reasons Why you Should use Excel Tables
Play lesson

Excel for Beginners: Easy Steps to Get Started - 7 Reasons Why you Should use Excel Tables

5.0 (3)
22 learners

What you'll learn

This course includes

  • 14.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

In this video, I will go over 7 different reasons to use tables in Microsoft Excel. When you turn your data range into an Excel table you are unlocking more properties. Benefit from using tables in Excel. 0:00 Introduction 0:32 Creating a table in Microsoft Excel 2:05 Easy formatting with a table (banded rows, add a total) 3:27 Table headers remain visible even when you scroll down 3:44 Tables automatically create filters for each column 4:50 Tables automatically expand when you add new rows or columns 5:35 Tables automatically name ranges (can be used in formulas) 6:30 You can add totals to tables automatically 7:05 Add slicers to your table 8:05 You can create dynamic charts from Excel tables Learn more about mentioned excel topics below: Create forms to enter data in your tables: https://youtu.be/dV90KPArP5Q More about slicers in this tutorial: https://youtu.be/c8qePWuYleg More about tables in this tutorial: https://youtu.be/dV90KPArP5Q More about pivot tables: https://youtu.be/igSovq_H24A Practice File: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EQKwmxoi8yJFrrYnyk8KUYUBsQW4XelB_jkA0JwQgbiT3A?e=n8Mu0q

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere