Excel 365 Part 13 – Table and range names
In this video, we will cover the difference between a Range and a Table. A Table is a module that sits on top of Excel, similar to a chart, and has additional formatting capabilities. Tables can be used as input to a Chart or PivotTable. A Range uses the cells in an Excel sheet. Typing data in a Blank worksheet is an example of a normal range of cells.
Video Series Part 13 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch4.mp4
- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.
Courseware: Excel 365 - Formulas, Charts, And PivotTables
Courseware is available on Amazon at: https://www.amazon.com/dp/1660221943
Chapter 4 - Datasheets And Tables
In this chapter, the difference between a Range and a Table must be clearly understood. A Table is a module that sits on top of Excel, similar to a chart, and has additional formatting capabilities. Tables can be used as input to a Chart or Pivotable. A Range uses the cells in an Excel sheet. Typing data in a Blank worksheet is an example of a normal range of cells.
Chapter Contents:
Section 1: Excel Range Feature
This is a normal Excel Range containing numbers of letters in cells located on a worksheet. This is what we normally use to create data in a worksheet. The concepts that can be used in a range are Sort, Custom Sort, Filter, Advanced Filter (AND operation), Advanced Filter Criteria, Advanced Filter (OR operation), Clear, and Subtotals capabilities.
Section 2: Table Features
This is an object that sits on top of an Excel worksheet similar to a Chart. It is an object that contains additional functionality in a defined area. When used for a Chart or PivotTable, it will allow updates to occur if the data area changes. It will allow several ways to format the entire area quickly and seamlessly. One important feature is to create banded rows which will be reapplied if the data is sorted differently. The following features of a Table will be covered: Create A Table, Modify A Table, Table Style Options, Table Sorting, Text Filters, Table Styles, Insert Column, Delete Row, and Convert To Range
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
-
36:40
Microsoft Excel Full Course
3 years agoExcel 365 Part 5 – Worksheets
72 -
32:47
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 32 – Cell Manipulation
57 -
26:25
Excel For Freelancers
3 months agoExcel Named Ranges: Everything You Need To Know In Less Than 30 Minutes
47 -
35:20
Excel For Freelancers
3 years agoLearn How To Master Named Ranges In Excel In Just 35 Minutes [Full Course]
39 -
52:03
Excel For Freelancers
2 months agoHow To Master Shapes With Excel VBA - For Beginners
86 -
15:14
The Excel Zone
10 months agoExcel Tips, Tricks and Shortcuts Part 3: The Functions You Need to Know
151 -
28:56
Excel For Freelancers
3 years agoHow To Filter Excel Table Data Just By Entering Text In The Header
23 -
2:25
Excelliott Technology
1 year agoExcel - Creating Name Ranges
1 -
1:52:15
Excel For Freelancers
3 years agoLearn How To Create Excel Forms And Map Them To Tables From Scratch [GREAT FOR VBA BEGINNERS]
73 -
29:08
Excel For Freelancers
1 month agoHow To Master Arrays In Excel VBA + FREE MACROS & CHEAT SHEET
48